Dear Erik,
What am I wrong in this case??
I made a cursor to use source of a main form and turned it table like this
to make some index fields
lo=Thisform
lo.cSub=SYS(2015)
lcTemp=SYS(2015)
Create cursor (lcTemp) (..........)
USE DBF(lcTemp) again in 0 alias (This.cSub)
USE IN (lcTemp)
select (This.cSub)
INDEX ON XXXX Tag XXXX
And filled some necessary data from other sql result,there in no problem.
I assigned each control's source and display it and delte,add..all fine.
But, When I query some result from this table(?) through sql, there is no
record, apprently there is record within criteria.
To make me crazy more, When I go through on command window with same command
in form's method, I can get the result.
Maybe There is something I don't completely understand to treat cursor.
Your kind advice would be highly appreciated.
TIA
p.s. Always reading your message with thanks..^^
MCP