Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid driving me nuts!
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Grid driving me nuts!
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01293774
Message ID:
01293774
Views:
47
Thanks to all for help in the past. This is a summary of things I've tried since my last query to you. Also, I've reworded the question a bit. I still have no solution yet.

User grid has a check box to select records to process.
I would like to return to the next record to process after the user has
processed records that have been checked.

This is the idea I've tried
1. Keep track of where user stops - via the key for table - Invoice No.
2. Prior to processing list, skip a record - get that invoice number, store it
- lnInvNo
3. process the data and do a tableupdate of underlying view(data source for
grid) (this does not fail)
4. do a seek(lnInvNo,'DISPATCH','INVOICENO') where dispatch is name of view,
and
invoiceno is an index created when form loads on grid.
5. Setfocus to the grids, first column first textbox. i.e.
thisform.cgrid1.column1.text1.setfocus()

However when this is done, the grid gets the focus and not at the record
selected above, but at the top of the grid.

I have confirmed the above: the seek returns to the right record. Yet once the
grid gets focus, it goes to the top (aaarrggghhh!)

I have tried the following:
Added a property to the grid to hold the lnInvNo
In the gotfocus event of the textbox in column1, I added code to check the
value
of the lnInvNo and do the seek above. Again it appears to find the right
record,
yet the grid goes to the first record.

I also have added grid refreshes, form refreshes etc to no avail.

Also weird behaivour of grid in debugger. If debugger is on, I cannot select
any
record at all. Clicking anywhere on the grid goes to the BOTTTOM (go figure) of
the grid and stays there.

Any ideas about what is going on?

TIA,
Mike
Next
Reply
Map
View

Click here to load this message in the networking platform