Select * from db2.table (sql base) how to do

[JOHN]

SELECT NAME FROM db2.EMP;

am trying something like this . in sql base



eagerly waiting for someones help

[FRBhote]

Set SqlDatabase = Database1
SqlConnect( hSqlDB1 )

Set SqlDatabase = Database2
SqlConnect( hSqlDB2 )

hSqlDB1 will always access DB1 and hSqlDB2 will always access DB2.

[JOHN]

Set SqlDatabase = Database1
SqlConnect( hSqlDB1 )

Set SqlDatabase = Database2
SqlConnect( hSqlDB2 )

hSqlDB1 will always access DB1 and hSqlDB2 will always access DB2.

can we do something like SELECT NAME FROM db2.EMP;

[Igor Ivanovic]

No.

[JOHN]

No.

so we cannot access data with single statement or there is no way to acces other database tables

[Igor Ivanovic]

so we cannot access data with single statement

No.

or there is no way to acces other database tables

You already got the answer how to do it from FRBhote

And you can also use

Code: Select all

SqlConnectEx( hSql1, sDatabase1, sUser, sPassword)
SqlConnectEx( hSql2, sDatabase2, sUser, sPassword)

[JOHN]

so we cannot access data with single statement

No.

or there is no way to acces other database tables

You already got the answer how to do it from FRBhote

And you can also use

Code: Select all

SqlConnectEx( hSql1, sDatabase1, sUser, sPassword)
SqlConnectEx( hSql2, sDatabase2, sUser, sPassword)

many thanks.. but i am concerned about sqlbase only not from TD app. it is working with TD app. just need in sqlbase as a statement