Hi Cetin
>Sorry, I sound to be forcing ppl to use ?m.Var style:)
No, no trouble at all, I just didn't want to agree to a method I had not tried, I had only tried it without brackets and it worked, that's all <g>.
> But my only concern is not the formatting. ?m.myVar style could be prepared and executed in a loop where formatted syntax needs to be as is per call (besides handling of formats between VFP and backend). ie:
>
SQLPrepare(m.lnHandle,'INSERT INTO X (date) values ?m.myDate')
>for ix=1 to 10
> m.myDate = date()+m.ix
> SQLExec(m.lnHandle)
>endfor
So backend needs to compile command once.
Yes, I am currently learning SPT more and more, and it get's still interesting by the day. I recently was just able to speed up a couple of SPT by just putting an index on the FB database. I had originally started with tackling it on remote view (lots of C5 in those days) then promoted myself to SPT.