| |

VerySource

 Forgot password?
 Register
Search
View: 38|Reply: 4

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

[Copy link]

2

Threads

6

Posts

7

Credits

Newbie

Rank: 1

Credits
7

 China

Post time: 2020-1-28 14:40:01
| Show all posts |Read mode
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
Reply

Use magic Report

0

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

Post time: 2020-3-3 13:30:01
| Show all posts
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.
Reply

Use magic Report

0

Threads

4

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

Post time: 2020-4-6 22:15:01
| Show all posts
Should be ok
Reply

Use magic Report

2

Threads

6

Posts

7

Credits

Newbie

Rank: 1

Credits
7

 China

 Author| Post time: 2020-6-4 12:15:01
| Show all posts
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?
Reply

Use magic Report

2

Threads

6

Posts

7

Credits

Newbie

Rank: 1

Credits
7

 China

 Author| Post time: 2020-8-4 15:15:01
| Show all posts
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!
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list