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
>
--Todd Sherman
-Wake Up! Smell the Coffee!