Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Query: How do i determine if I am on the last row
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01536814
Message ID:
01536834
Views:
47
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform