datawindow does not support dblink table update! !! !!

mokuei

I have a table on a remote library, accessed by dblink, and datawindow is available (DW SQL: select * from mytable @ mydblink), but when updating (calling update ()), it reports datawindow does NOT have UPDATE capability! I have set it in the Update properties menu!

Please help me, thank you

Ragina

That should not be a problem with datawindow. In fact, the submission mechanism of datawindow is very clear and simple.
You check the SQL statement submitted by datawindow. It is possible that this SQL statement is not supported by dblink itself.
Or your dblink definition cannot be updated.

wzchuan

Should be ok

mokuei

I have tried various methods, but it still doesn't work!

Maybe pb will read the metadata of the table, can't read it through dblink?

mokuei

The problem is solved, it is still a PB bug! Summarized as follows:

The problem that Datawindow cannot update the table through DB-LINK has been resolved: Synonyms are created locally to point to the DB-LINK table.
Analysis: Because Datawindow cannot recognize the'@' symbol in the table name, in the Rows->Update Properties dialog box at design time, select the table and field to be updated. If the table name contains @, the save time will report "table not found" This has already been explained. Therefore, a synonym with the same name can be established on the detailed list database to solve the problem of Datawindow update, because in fact, Datawindow handles the table name transparently (generates the SQL statement submitted to the database), but thinks that'@' is a special symbol and cannot identify the table name.
Restriction: Because PB does not support synonyms well, for a DataWindow of a SELECT synonym table, do not open the SQL drawing board, otherwise the IDE will crash, so change the SQL statement and use Edit Source.

Thank you again!