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.
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
Thanks Barry...
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
I did have it stopped... I tried reinstalling it 3 or 4 times... with the same results..
Success... I unistalled it again... deleted the c:\lianja folder.. installed it ... and it seems to be working fine...
Thanks
Jim
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
Back to the same issue... nothing works for select * from some file (into json) (save as json) (to file )....
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
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
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
Bookmarks