I haven’t been able to use the grid editor to insert data into a table.
Most tables in our databases don’t use declarative referentiel integrity although the logical RI are usually defined using sp_primarykey and sp_foreignkey.
All our tables have got at least one unique index.
When I open the grid is opens in read-only mode because there is no key column : that’s a bit unfair.
When I want to define custom editing all columns except the datetime columns are selected by default as key columns, all columns are selected as updatable columns and the table name is absent.
When I try to enter a row of data it displays an error message. Could it be because of the dates ?
BTW the insert statements are generated by Toad and there are too many brackets for my liking.
Notice that Toad can even speak french at times.
abe.sql (1.78 KB)