SQL Commands

SQL Commands

Postby 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
T.Winkler
 
Posts: 16
Joined: Fri 03 Feb 2006 19:50

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL