Table Adapters
Posted: Thu 19 Oct 2006 08:52
Hello.
I use PGSQL DLL Version 2.50.21.0 pro for DotNet 2.0 and have some trouble with the table adapters. So, if I use the PGSQL dataset wizard it looks like everything is ok, but the update insert and delete command contains the name of the database like:
Delete from database.schema.table…….
It works but if I change the connection string to an other database it generates an error like Cross reference are not supported.
Now, I can change the command text without the wizard ( edit the text only in the box of the properties) and the update and insert command will be work. But the delete command generates wrong parameter.
If I change the command text with the wizard he generates for all commands to much and also wrong parameters.
So it is not possible to change some commands.
Do you see some help for this problem?
Regards
Thomas
I use PGSQL DLL Version 2.50.21.0 pro for DotNet 2.0 and have some trouble with the table adapters. So, if I use the PGSQL dataset wizard it looks like everything is ok, but the update insert and delete command contains the name of the database like:
Delete from database.schema.table…….
It works but if I change the connection string to an other database it generates an error like Cross reference are not supported.
Now, I can change the command text without the wizard ( edit the text only in the box of the properties) and the update and insert command will be work. But the delete command generates wrong parameter.
If I change the command text with the wizard he generates for all commands to much and also wrong parameters.
So it is not possible to change some commands.
Do you see some help for this problem?
Regards
Thomas