Hi,
You've all been incredibly helpful to the point that I usually don't even need to post my question or problem. This time I'm not finding much to help me work through the two issues I'm experiencing. They may be related, but may also be totally separate. I have no idea. I'm hoping you all can help me work through this. Please keep in mind that I'm no expert. Sorry in advance for such a long post.
First problem is related to the Restore feature of the database. I have an edit version of the program that I use to make all of my database updates and edits. When I'm ready to update the live version for everyone, I take a backup of the live data and restore only the data files into my edit version. There are times where I'll restore the data, but when I go back and look not all of the tables restored and not all of them are available to restore if I look for them on the list. If I take that file and put it on my desktop, all of the files are there and the database works fine. Any idea what could be going on with that? It's incredibly frustrating and sucking up a lot of time.
Next problem I discovered while trying to troubleshoot the first problem. If I check the indexes of all tables, I am getting errors on some of the mapped tables, not all. Hopefully uploaded below. It says "Script: UI_MODELESS_DLG_BOX:Check Indexes line:99 result = check_index_local(a_tables[indx].name) Variable "FIELD NAME" not found.
Sometimes there is no "FIELD NAME" and just says 'No such field' instead. I found a way to get it working so I went in and fixed the few maps with issues yesterday, but today, the error is showing up again in different maps. I have no idea what's going on. Do any of you have any ideas or information that can help?
error.jpg
Thank you for any help you can provide!
Alicia
4:24 p.m. The more I look at it, the more it looks like the maps with issues were created in V10 or before. Could that be related?
You've all been incredibly helpful to the point that I usually don't even need to post my question or problem. This time I'm not finding much to help me work through the two issues I'm experiencing. They may be related, but may also be totally separate. I have no idea. I'm hoping you all can help me work through this. Please keep in mind that I'm no expert. Sorry in advance for such a long post.
First problem is related to the Restore feature of the database. I have an edit version of the program that I use to make all of my database updates and edits. When I'm ready to update the live version for everyone, I take a backup of the live data and restore only the data files into my edit version. There are times where I'll restore the data, but when I go back and look not all of the tables restored and not all of them are available to restore if I look for them on the list. If I take that file and put it on my desktop, all of the files are there and the database works fine. Any idea what could be going on with that? It's incredibly frustrating and sucking up a lot of time.
Next problem I discovered while trying to troubleshoot the first problem. If I check the indexes of all tables, I am getting errors on some of the mapped tables, not all. Hopefully uploaded below. It says "Script: UI_MODELESS_DLG_BOX:Check Indexes line:99 result = check_index_local(a_tables[indx].name) Variable "FIELD NAME" not found.
Sometimes there is no "FIELD NAME" and just says 'No such field' instead. I found a way to get it working so I went in and fixed the few maps with issues yesterday, but today, the error is showing up again in different maps. I have no idea what's going on. Do any of you have any ideas or information that can help?
error.jpg
Thank you for any help you can provide!
Alicia
4:24 p.m. The more I look at it, the more it looks like the maps with issues were created in V10 or before. Could that be related?
Comment