Hi Dan,
Nice to see you here. I've been learning from most of your post in microsoft.public.fox.programmer.exchange all this time :-)
>I agree with Wayne in questioning your use of MSDE with 15-20 users.
Can you refer to my reply to Wayne about this? What do you think about the post I include with my reply to him?
>But I disagree with him about the lookup tables. I've done this with SQL-Server systems since the Fox 2.x days....
Did you mean Fox 2.x for Windows or for DOS? If you meant Fox 2.x for DOS, can you tell me how you connected your apps with SQL Server?
> and it can really cut down network traffic for those relatively static lookup tables.
>I've always kept a "version" table, both on the server and on the workstation. Every time the app starts, it compares version #'s for each of the tables involved. If the server version is later than the workstation version, the file gets copied down (or updated). To distribute changes, make the change on the server version of the table and increment the version number.
Thanks for your idea. The idea of using a 'version' table is interesting. Basically, I've been using George Tasker's GenLoader all this time. It's easy to modified the script a bit to check more than one file.
WBR,
Willianto
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