It is not as simple I would like it to be. Not all fields of VFP will be converted to SQL Server tables. And there are many dependencies that I have to "manually" convert. I agree with you that in a simple world the views could be very helpful.
>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham