[RBG7-L] - RE: cursor is not positioned on a valid row

[Jan Barley]

Thanks a million Dawn!  I had the property table refresh in my eep, but I kept getting the error 'Syntax is incorrect for the command SELECT (2045)', so I removed it.  Turns out, there's not property command like  PROPERTY TABLE tablename REFRESH 'TRUE' !!!  Oh, I have so much to learn!!!!!!!!   Jan ----- Original Message ----- From: Dawn Oakes To: RBG7-L Mailing List Sent: Thursday, September 29, 2005 10:49 AM Subject: [RBG7-L] - RE: cursor is not positioned on a valid row Jan, Proabably because you deleted the row where the cursor is expected to be.  If you're deleting the row in code (delete rows from table where x = x), then you need to refresh the data.  After you delete a row, issue a PROPERTY TABLE tablename 'REFRESH'.  That will re-fetch the rows and position the cursor on the next available row. You should do the same if you INSERT into the table from code (as opposed to adding a blank row using F2 or a predefined Add Row eep.) Dawn   From: Jan Barley [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 10:45 AM To: RBG7-L Mailing List Subject: [RBG7-L] - cursor is not positioned on a valid row OK, now what have I done???  I have a form which has a variable lookup listbox and 2 bit buttons, one to add and one to delete.  I can add subcategories all day and the list refreshes properly.  However, if I delete more than one subcategory, I get the dreaded error 2378.  My listbox is based on a 2 table view which links the customer and subcategory ID from one table to the subcategory ID and subcategory description from another, so that only the subcategory's description for that customer is displayed in the listbox.  Can anyone explain what causes this error message or what I can do to resolve this?  Thanks very much!   Jan Barley