Results 1 to 8 of 8

Thread: Can Lianja be used in other development environments?

  1. #1
    Senior Member
    Join Date
    Feb 2012
    Location
    Barrie, ON
    Posts
    191

    Can Lianja be used in other development environments?

    Hi

    I have used the Advantage Database server on a occasion more specifically the Client Engine dll with programming languages like PowerBasic and Purebasic. Is it possible to use Lianja the same way and access all the data handling capabilities from other development environments? If not is this something that could be considered in the future?

    Thanks,
    Simon

  2. #2
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    Yes, the Lianja SQL Server has an ODBC driver and a JDBC driver

  3. #3
    Senior Member
    Join Date
    Feb 2012
    Location
    Barrie, ON
    Posts
    191
    Quote Originally Posted by lianjasupport View Post
    Yes, the Lianja SQL Server has an ODBC driver and a JDBC driver
    Using ODBC means we lose the Data Manipulation commands like "Seek", "Skip", "Replace" etc. which is a little different than the Advantage Client which gives you access to all the SQL commands and Data manipulation commands.

  4. #4
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    We are not planning to provide such low level functionality. Our vision is more focussed on cloud and mobile.

  5. #5
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    Although it is worth pointing out that stored procedures can be written in vfp and use those navigational data commands.

  6. #6
    Junior Member
    Join Date
    May 2012
    Posts
    7
    Planning to test Lianja against my needs soon and will have a huge amount of web based functionality to bring over

    So far, have imagined that I could use ODBC to get data from an existing SQL server as I do now.
    Does the above mean that the resulting data set is not in the form of a fox cursor (meaning Data Manipulation commands like "Seek", "Skip", "Replace" are NOT available ) ?

    If not, then how do we navigate the data and replace data items ?

  7. #7
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    Yes of course it does support VFP style local cursors as it has full vfp implementation built in. The thread above is talking about SQL odbc access. Full local cursor access (from sqlexec() etc) is supported just like VFP.

  8. #8
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,771
    Since this question was asked we have released Lianja SQL Server which provides the ability to write stored procedures in Lianja/VFP so all of the commands you mentioned are available.

    You can find details here.
    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