Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Schema property



Permlink Replies: 6 - Last Post: Jan 9, 2018 12:20 PM Last Post By: Bob Gambler Threads: [ Previous | Next ]
Bob Gambler

Posts: 61
Registered: 8/23/10
Schema property
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 2, 2018 5:22 AM
Hi all,

below, a piece of my code, when creating my connection. How can i inform the schema property?

         vSqlConnection                      := TFDConnection.Create(nil);
         vSqlConnection.TxOptions.Isolation  := xiReadCommitted;
         vSqlConnection.TxOptions.AutoCommit := False;
         vSqlConnection.LoginPrompt          := False;
         vSqlConnection.DriverName           := myDriver;
         vSqlConnection.Params.UserName      := myUserName;
         vSqlConnection.Params.Password      := myPassword;


Edited by: Bob Gambler on Jan 2, 2018 5:23 AM
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Schema property
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 4, 2018 7:21 AM   in response to: Bob Gambler in response to: Bob Gambler
What is a "schema" property ? Is it a database ? Or ... ?

--
With best regards,
Dmitry
Bob Gambler

Posts: 61
Registered: 8/23/10
Re: Schema property
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 4, 2018 8:04 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Database. Something like mySchema.myTable...

Dmitry Arefiev wrote:
What is a "schema" property ? Is it a database ? Or ... ?

--
With best regards,
Dmitry
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Schema property
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 5, 2018 7:27 AM   in response to: Bob Gambler in response to: Bob Gambler
And what is your DBMS ?

--
With best regards,
Dmitry
Bob Gambler

Posts: 61
Registered: 8/23/10
Re: Schema property
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 8, 2018 8:50 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Postgresql, Sql Server, Oracle, Mysql...

Dmitry Arefiev wrote:
And what is your DBMS ?

--
With best regards,
Dmitry
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Schema property
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 9, 2018 7:16 AM   in response to: Bob Gambler in response to: Bob Gambler
vSqlConnection.Params.Database := '....';
--
With best regards,
Dmitry
Bob Gambler

Posts: 61
Registered: 8/23/10
Re: Schema property
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 9, 2018 12:20 PM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Thanks

Dmitry Arefiev wrote:
vSqlConnection.Params.Database := '....';
--
With best regards,
Dmitry
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02