DF 20 - Db2 - Can`t change PK values from dbExplorer
I am not able to edit/change column values that belongs to PK from dbExplorer.
Original PK value :
[CODE]
Column1: Wo.ZEvent.oEvaluatedPath.Caption
Column2: en-us
[/CODE]
Find this row in dbExplorer, try to change Column1 value, and save the row.. I get :
[CODE]
c:\program files\dataflex 20.0\bin64\dbexplor.exe
Erro genérico 02000 (100)--[IBM][CLI Driver][DB2/NT64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000
Table = TRANSLATIONS (5), Source = DB2_DRV.Save
Error: 12289
MSG_ERROR_REPORT (433) - oErrorDialog (90) - at address 68396
MSG_REQUEST_SAVE (375) - oTRANSLATIONS_DD (2193) - at address 18318
MSG_REQUEST_SAVE (375) - oRecordEditContainer (2206) - at address 21989
MSG_REQUEST_SAVE (375) - oRecordEditContainer (2206) - at address 92500
MSG_REQUEST_SAVE (375) - oSCONTENTdbForm (2262) - at address 23414
MSG_REQUEST_SAVE (375) - oSCONTENTdbForm (2262) - at address 23598
MSG_REQUEST_SAVE (375) - oSCONTENTdbForm (2262) - at address 92735
MSG_ONEXECUTE (9355) - oSaveCurrentRecordButton (342) - at address 73990
MSG_EXECUTE (9354) - oSaveCurrentRecordButton (342) - at address 58189
MSG_ONCOMEXECUTE (8477) - oRebar (199) - at address 57179
[start] - at address 104952
It looks it`s trying to use the new values to find the row, instead of using the original ones...
[/CODE]
hope this is a dbexplorer issue, instead of a driver one.
if this is the case, feel free to move the thread to the correct forum
Re: DF 20 - Db2 - Can`t change PK values from dbExplorer
This is actually a driver issue that we have already a fix for.
I will send you the latest drivers build with the fix.
We intend to publish an update shortly.
Re: DF 20 - Db2 - Can`t change PK values from dbExplorer
Samuel,
Next to Martin's reply:
Did you choose to open related tables in Database Explorer? Only then it replaces the foreign key column DEO for the related to column and thus finds the parent.
In the future when you think you did "right" thing I would like to ask you to create a test workspace, create a HDE ticket and upload it.
Re: DF 20 - Db2 - Can`t change PK values from dbExplorer
Hum. I never changed this parameter. But I will double check!
Thanks
Re: DF 20 - Db2 - Can`t change PK values from dbExplorer
Re: DF 20 - Db2 - Can`t change PK values from dbExplorer
Samuel,
Performance wise you better don't set the parameter to true (and the same for child tables) but you might have a situation (rules from the database itself) that require the setting. You can also decide to add parent tables later or rebuild the dataview using a column from a parent table.
Re: DF 20 - Db2 - Can`t change PK values from dbExplorer
[QUOTE][COLOR=#333333]Did you choose to open related tables in Database Explorer?[/COLOR][/QUOTE]
Hi Vincent.. just double checked and this option was not enabled..
Anyway, thanks for the feedbacks..