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.
Printable View
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.
Thanks Barry...
Jim, make sure you stop the Lianja SQL Server before the install. Maybe thats the issue.
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.
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.
Ah. Sorry. You don't have RC5.4 yet. Hang off a few days.
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