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...