You're the boss of course, but I thought that if your tables already existed in your sqlserver, then all this would take is a scan through your vfp table, a scatter memvar and an insert into sqlservertableview from memvar.
You could even do that automatically by scanning through all you tables.
Not sure what you and dragan mean by "maintenance" of views though, especially since this is a "on time" thing.
Ah well.
>>>Hi,
>>>
>>>I am getting an error a line very similar to the following. The error says "command contains unrecognize phrase/keyword".
>>>
>>>
>>>cSqlInsert = "insert into Mytable (fld1, fld2, fld3) values (?MyTable.fld1, ?MyTable.fld2, ?MyTable.fld3)"
>>>
>>>
>>>The list of fields is actually considerably longer. But what should I be looking at? TIA.
>>
>>Wouldn't it have made more sense to have created views around the msql table and then apply a scatter memvar, insert into .... from memvar? (admittedly for the last time?) :
>
>In my case, this procedure is a "one-time" only approach; on moving the data from VFP data to SQL Server. Creating views would take time and maintenance. And my goal is to get it done asap.
>Thank you.
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.