Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Populating a table with the results of a query.
Message
De
13/11/2000 02:47:09
 
 
À
12/11/2000 23:47:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00440879
Message ID:
00440893
Vues:
24
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform