Mike,

Thanks for the code. I didn't know you were using SPT against VFP data. I couldn't consistently reproduce your problem, although I did see it on a few instances. See if Message# 662942 helps.

HTH
>Hi Daniel,
>
>You got the question right.
>&& First I execute the SPT query
>csql = [Select * from acctg!items ]
>
>&& then I execute the the query
>nResult = sqlexec(vconnection,csql,'mycur')
>
>&& then I brow the created cursor
>select mycur
>browse
>
>the result for this query is okey. But after this, if i tried to change some date or insert new records in the acctg!items table using command window or native foxpro coding, then executing the same SPT commands above, the result
>does not show the record i inserted or modified.
>
>Thanks...