SQL Commands

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
T.Winkler
Posts: 16
Joined: Fri 03 Feb 2006 19:50

SQL Commands

Post by T.Winkler » Sat 21 Apr 2007 11:00

Hi there,

now, I have a trial to use version 3 of PGSQL and it seem that the most problems are solved, but the SQL string contains always the name of the database in front of them.
An update command, generated with a wizard looks like that:
UPDATE [dbo].[Auftrag_Artikel] SET [Lfdnr_Auftrag] =
UPDATE "pconnect_ww"."periwww"."artikel" SET ......
It’s wrong, perhaps "pconnect_ww" is the name of the database which is specified in the connection string of the corresponding connection.
Yes it works, but there is no possibility to change the database at runtime.
Also, if you re-enter the wizard, the failure will be solved!
So, the work around will to open and close the wizard for each command.
Is it necessary?

Regards
Thomas

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 24 Apr 2007 07:41

but there is no possibility to change the database at runtime.
Why? There is a ChangeDatabase method in the PgSqlConnection class.

Post Reply