J
John
Guest
I am getting an error on ALL updates made from the "show all records" screen using any update record icon.
When I select "show all", the database records are displayed correctly. When I click on the Update icon (adjacent to any record on the page)
DaDaBik displays the wrong record for update.
I turned on debug and sql display flags to see what was going on and to
verify I wasnt getting the "Limit" condition I saw in older Posts. It appears only the first column of the base table's compound primary key is being used
to construct the record to extract for update.
The select statement used to pull the record for update ignores all compound primary key columns after the first;
It is probably getting the first record from the table that matches the first primary key value.
My underlying table has 3 concatenated primary key columns.
(pkcol1,pkcol2,pkcol3)
Eg;
Debug Query to extract record for update is displayed like:
select col1,col2,coln from table where pkcol1 = 'somevalue'
Record extracted for update should be:
select col1,col2,coln from table where pkcol1='somevalue1'
and pkcol2 = 'somevalue2' and pkcol3 = 'somevalue3'
All other functionality is great!
I see new version is out, but "fixes map" doesn't talk about anything that might affect this.
Help is appreciated...
John
When I select "show all", the database records are displayed correctly. When I click on the Update icon (adjacent to any record on the page)
DaDaBik displays the wrong record for update.
I turned on debug and sql display flags to see what was going on and to
verify I wasnt getting the "Limit" condition I saw in older Posts. It appears only the first column of the base table's compound primary key is being used
to construct the record to extract for update.
The select statement used to pull the record for update ignores all compound primary key columns after the first;
It is probably getting the first record from the table that matches the first primary key value.
My underlying table has 3 concatenated primary key columns.
(pkcol1,pkcol2,pkcol3)
Eg;
Debug Query to extract record for update is displayed like:
select col1,col2,coln from table where pkcol1 = 'somevalue'
Record extracted for update should be:
select col1,col2,coln from table where pkcol1='somevalue1'
and pkcol2 = 'somevalue2' and pkcol3 = 'somevalue3'
All other functionality is great!
I see new version is out, but "fixes map" doesn't talk about anything that might affect this.
Help is appreciated...
John