Hi stecenko, where i got the sample for that, I am using VMP 9.1.11, do you have a sample promatrix and sql Server? coould you share with us pls?
I just learn from the sample, one ore two table in sql server run the application from promatrix.
could you like to advise please.
TIA
Benrahman
benrahman2000[at]yahoo.comstecenko wrote:If you are moving to sql and most of what you've done is in views then it isn't really that difficult. Tedious and boring, but not difficult.
Here are a few thoughts for you.
It will be a lot easier if you do not convert all the VPME meta data tables to SQL. If you can leave them as VFP tables, it's easier.
If you use GUIDs for primary keys, you will again find things easier. That's because you don't need to lock and unlock records to get sequential primary keys.
Do not write calculated fields to the database for the same reason. Writing calculated fields makes commit and rollback trickier.
Use views for the forms that write the data. Use SQL passthrough for the forms that collect data for display and reports.