PDA

Click to See Complete Forum and Search --> : errors with datagrid control


ron19
Jan 12th, 2000, 05:16 AM
I am in need of desperate help. The problem is regarding ADO and the datagrid control. I am using VB 6.0 and VFP to develop my application. The database in the server, and all the database related stuff is handled by the server dll. The database has tables which have 160,000 records in them. The user would want to see all the columns, so i chose to display the data in a datagrid. So when the client program requests data, the server dll, creates a disconnected updateable recordset and passes it to the client. The recordset is then associated with the datagrid control. The user should be able to update or add or delete the data thru the datagrid control. Then i would call a routine in the server to connect the recordset back and commit the changes to the database.

But sometimes when i change the value of a cell in the grid, it just gives me a run time error - Errors Occurred. No further details. Would appreciate any help.

I am using ODBC - Microsoft Visual Foxpro Driver to connect to the foxpro database.

ron

Clunietp
Jan 12th, 2000, 10:33 AM
loop thru the ERRORS collection to display the error messages