Results 1 to 3 of 3

Thread: open database closes open database

  1. #1
    Junior Member
    Join Date
    Nov 2012
    Posts
    15

    open database closes open database

    I have problems opening two (or more databases) at the same time.
    OPEN DATABASE db1
    OPEN DATABASE db2

    Then db1 is closed again.

  2. #2
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    In Lianja you can only have one database open at a time. This is by design.

    you can however reference tables in multiple databases like this:

    Code:
    use databasename!tablename
    select * from databasename!tablename

  3. #3
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,881
    or you create a virtual table into DB1, referenced to the real table on DB2.

    Ciao
    Fabio

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us