Trust ID PBCEX logo 300x102

We can not delete or edit a data record.

6 years 10 months ago
Mkorremans
Fresh Boarder
Fresh Boarder
Posts: 14
More
Topic Author
We can not delete or edit a data record. #3050
We use cardexchange 8.
We have make a tamplete with database connection to excel.
The strange thing is that we can insert a new record in excel, but we are not able to delete or edit a record.
6 years 10 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
We can not delete or edit a data record. #3051
Hello Mkorremans,

When connecting to Excel, it is important that you link to a worksheet rather than a named region. In the table selection drop-down menu you can recognize the worksheets by there name and a trailing $ sign. If you link to named regions, editing data, especially inserting new records, will be problematic.

In the database setup, you can specify whether you allow inserting, updating and/or deletion of records, so please, check your settings in the database setup. For Excel, deleting records is not supported, but editing should be.

If you are connecting to a CSV file rather than a real Excel file, only inserting is supported, not updating and/or deletion.

For any further questions, please, be more explicit about the error messages you see or what exactly happens when you try to edit the data.

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
×

Notice

The forum is in read only mode.