Is this any faster than creating a view of the table, buffering the view, and then inserting records into the view from memvars and then doing a table update command to write the record?

Is there a way to get the error type if for some reason the insert fails?

Its too late to change for this project, but I am hoping to get another similar project in the near future.

Plus (I just thought of this) then to see what was written, I would have to requery the view, right? Unless of course I wrote the records to a local copy first, and then made my update routine do the SPT to do the insert. hmmmm...



>Well, let's see:
>

>Use myfoxdbf
>x=SqlConnect("mydsn")
>Store "" To myfld1, myfld2
>y=SqlPrepare(x, "Insert Into mysqltbl Values(?myfld1, ?myfld2)")
>Scan
>    myfld1 = myfoxdbf.field1
>    myfld2 = myfoxdbf.field2
>    SqlExec(x)
>EndScan
>SqlDisconnect(x)
>Use In myfoxdbf
>