Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Populating a table with the results of a query.
Message
From
13/11/2000 02:47:09
 
 
To
12/11/2000 23:47:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00440879
Message ID:
00440893
Views:
15
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform