Results 1 to 5 of 5

Thread: Examples about using other database

  1. #1
    Junior Member
    Join Date
    Feb 2012
    Location
    Italy
    Posts
    25

    Examples about using other database

    Hello to everybody
    I just try for a while to use LIANJA, connecting with other database (POSTGRES, MS-SQL) but I does not have any success. Mean to make a simple application wich have a persitent connection , have a GRID, make some query, update and so on. I even try the new command "CREATE VIRTUALTABLE" but it does not work (for me !).
    So my question: does anybody of you make some test with this section of Lianja ? Can ayone help me with some indications ? For me it's very important to use other database (in this moment).
    Thanks a lot !

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,246
    Go to the console workspace and select the ODBC tab then you can see if your connection works:

    after the connection just issue:

    Code:
    dir
    then issue some SQL selects to make sure your connection is made properly.

    Yes we are using virtualtables ourselves in the product.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,261
    Please also note that for the CREATE VIRTUALTABLE syntax, the odbcdsn connection string is in quotes and the select_statement isn't.

    CREATE|ALTER VIRTUALTABLE virtual_table_name
    [IF NOT EXISTS]
    [ALIAS name]
    CONNSTR "odbcdsn"
    AS select_statement

    create virtualtable salescurr connstr "awhr" as select * from sales.currency

  4. #4
    Junior Member
    Join Date
    Feb 2012
    Location
    Italy
    Posts
    25
    For examples / or manuals / or documentation I mean some code wich I can study / understand / use. I'd like to understand how to make a GRID, how to add my methods in , make reports, and so on.. I don't want to use Lianja only for editing data .
    Other way , some months ago I ask Lianja team about courses / seminares (even paying of course); did you have any notice abit this ?
    Thanks a lot

  5. #5
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,246
    Yes we did and we have mentioned that when we ship the product in final release we will be offering training courses to help you make the best of Lianja.

    There are many examples in the blogs and developers guide already. We will be producing more now that the overall product is maturing.

    Remember that Lianja is still in beta. If you read the code in the demo apps you can get a good idea on how to use Lianja.

    These forums are for you, so ask questions here and we will do our best to answer them.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

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