uniconnection database name

[Senad]

When establishing a connection to sql server using uniconnectdialog,
does uniconnection know that from now on the database name is the one
supplied in the uniconnect dialog ?
Or must I do ? :

Code: Select all

UniConnection1.Database :=UniConnectDialog1.Connection.Database;

I am asking this because I will be using many tables and I want to know
if I must specify database name for every table or the tables already know
they should use uniconnections database name.

[AlexP]

hello,

Yes, the name will be set in the UniConnection.Database property:

Code: Select all

  if UniConnectDialog1.Execute then
    ShowMessage(UniConnection1.Database);

[Senad]

Tables do follow ?

[AlexP]

If you don't specify the database name in the query explicitly, then the name set in ConnectDialog will be used. If you want to use tables from other databases, you should specify the DB name explicitly in queries.