Update & Delete from grid

[Tonybho]

Hi, I've a problem with update and delete record in dBASE.
I use C#.

I must update, insert or delete displayed records in a gridcontrol.

Select is on TABMAG : SELECT * FROM TABMAG and records are displayed correctly.

When I try to update or delete an existing record, I've this error:

"Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information."

This is my table structure:
Name : TABMAG
Fields : GRMER, CODE, DESC
Indexes : TABMAG1, TABMAG2

TABMAG1 have as "Expression index" GRMER + CODE and as option only "Maintaned" checked.

TABMAG2 have as "Expression index" GRMER + DESC + CODE and as option only "Maintaned" checked.

I don't undestand where is the problem.
Can you help me?

Thanx

 

[MiggyD]

Have you tried typing "help delete" at the command prompt for the correct syntax/parameters?

You can also type "help select".


My mind not only wanders, it sometimes leaves completely.