Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 41

Thread: sql select

  1. #21
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,730
    Hi Jim, It will be fixed in RC5.4 -- its just the expiry date on the beta. Will be available within a day or so.
    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

  2. #22
    Member
    Join Date
    Jun 2012
    Posts
    55
    Thanks Barry...

  3. #23
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,730
    Jim, make sure you stop the Lianja SQL Server before the install. Maybe thats the issue.
    Last edited by barrymavin; 2013-04-16 at 08:07.
    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

  4. #24
    Member
    Join Date
    Jun 2012
    Posts
    55
    I did have it stopped... I tried reinstalling it 3 or 4 times... with the same results..

  5. #25
    Member
    Join Date
    Jun 2012
    Posts
    55
    Success... I unistalled it again... deleted the c:\lianja folder.. installed it ... and it seems to be working fine...

    Thanks
    Jim

  6. #26
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,730
    Thats good.
    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

  7. #27
    Member
    Join Date
    Jun 2012
    Posts
    55
    Back to the same issue... nothing works for select * from some file (into json) (save as json) (to file )....

  8. #28
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,730
    Jim, try it at the console in the App Builder.
    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

  9. #29
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,730
    Ah. Sorry. You don't have RC5.4 yet. Hang off a few days.
    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

  10. #30
    Member
    Join Date
    Jun 2012
    Posts
    55
    just downloaded everything again.. tried to create json files from select statement in both vfp9 and the lianje command/console window.. no file is ever produced

    here is the code again...

    clear
    lcDSNLess="DRIVER=Lianja ODBC Driver; SERVERNAME=10.0.0.5;USERNAME=?;PASSWORD=?;DATABASE =jimsdatabase"
    lnConnHandle=SQLSTRINGCONNECT(lcDSNLess)
    ?lnConnHandle
    if lnConnHandle > 0
    a = sqlexec(lnConnHandle,"select * from inventory into JSON C:\TEMP2\stdout.TXT") <-- doesnt work
    a = sqlexec(lnConnHandle,"select * from inventory save as JSON stdout.txt") <-- doesnt work
    a = sqlexec(lnConnHandle,"select * from inventory to file C:\TEMP2\sdtout.txt") <-- doesnt work


    WAIT WINDOW STR(a)

    sqldisconnect(lnConnHandle)

    ELSE
    WAIT WINDOW "no connhandle"

    endif

Page 3 of 5 FirstFirst 12345 LastLast

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