Hi Doug,
Hmmm - this still isn't clear in my mind (also a newbie). Are you saying that I should resupply to the client the database container (DBC, DCX & DCT), (but not the tables) plus the new metadata (CoreMeta and SDTMeta) and then do an Update()? won't VFP complain about the desynchronisation of container with tables?
This may be the answer to something I coudn't get to work - here is what I was trying to do, maybe you can suggest a better way...
I wanted to get rid of all the "deleted()" tags in my databse. I know you advise against this, but my customers use my app over a network, and there have been various articles both here and in other formums saying that you shouldn't use deleted() tags over a LAN.
I deleted all appropriate index references (clients.deleted, invoices.deleted etc.), both from coremeta and sdtmeta, and then called the Update() method. No change to the database. I tried with the Reindex() method, but that didn't do anything either. When I ran the SDT Database Explorer, it revalidated all my tables and added the deleted() tag back to each table.
Finally, I went through every table in the database highlighting the Deleted tag IN THE TREEVIEW, but made the hideous mistake of hitting the "Del" key thinking that this would remove the tag. Being an experienced developer, I didn't bother reading thze confirmation message, and deleted half the tables from the database before realising what was happening.
After putting them all back into the database, I couldn't find a quicker way of getting rid of the deleted tag than this :
1 - Double-click on the table
2 - Click on the Indexes Tab
3 - Right-Click on the Deleted() tag
4 - Choose Delete Tag
5 - Confirm that I want to delete the thing
6 - Click on the Save button
That's a lot of clicks. The other people in the office kept coming over to see what game I was playing ...
Cheers,
Neil
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only