To be totally honest, I never used views in my life, but I thought this is was a runonce kind of conversion no?


>>>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?) :
>
>Not necessarily - views carry maintenance, there's the dbc contention, and, besides, with views you're letting Fox do things automatically behind your back. With SPT you have much more control. Even in the case at hand, one can check for unchanged fields and omit them from the string - feasible with views, too, but not as easily.