General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Grid driving me nuts!
Environment versions
Network:
Windows 2003 Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only