Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid Query: How do i determine if I am on the last row
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01536814
Message ID:
01536834
Vues:
49
>Hi Koen,
>
>EOF() will not be triggered if there are other detail lines belong to other header records. Fro example if there are two invoices and I am on the first one and the pointer is on the last detail line of the invoice and i issue skip. The record pointer will not move to eof() marker as there are still other details lines that match to a different header. If I am on the last line of the second invoice and that was the last detail line captured then the next physical record will be EOF marker.
>
>Hence my problem.

My suggestion is to do a select statement to get all invoices for the parent. You can do this select into a temp cursor or array. Then you will be able to compare this temp cursor / array Child PK against grid's records and thus will know if you're on the last invoice for the order or not.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform