sql select

[barrymavin]

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.

[jmonte407]

Thanks Barry...

[barrymavin]

Jim, make sure you stop the Lianja SQL Server before the install. Maybe thats the issue.

[jmonte407]

I did have it stopped... I tried reinstalling it 3 or 4 times... with the same results..

[jmonte407]

Success... I unistalled it again... deleted the c:\lianja folder.. installed it ... and it seems to be working fine...

Thanks
Jim

[barrymavin]

Thats good.

[jmonte407]

Back to the same issue... nothing works for select * from some file (into json) (save as json) (to file )....

[barrymavin]

Jim, try it at the console in the App Builder.

[barrymavin]

Ah. Sorry. You don't have RC5.4 yet. Hang off a few days.

[jmonte407]

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