Search:

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...
...

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

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

Thanks
Jim

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

Thanks Barry...

Just install the latest of everything... I was going to test the Lianja SQL server to see if the select to json stuff worked... however, nothing seemed to happen... then I looked to see if the...

I know this... was just hoping something like this could be done "Select * from somefile INTO STRINGJSON" LOL....

Thanks Barry... 99% of what we will be retrieving from the server will be json.. One quick question... Why can't the result just be returned as a long string? instead of a file ...

Thanks Barry.... I'm only testing this stuff with VFP9.. I will eventually be using node.js instead of aspx to server my data "in the json format"......

I'm an adminstrator on this computer.. the folder is set for "everyone" read/write.. connection is successful.. It works if i'm just creating a cursor.. all the records are returned... but...

I'm running the code from the server.. is it saving to the lianja sql install folder? if it is saving.. why does it produce a cursor too?... I'm running the code from vfp9 in a prg file... no...

why doesnt this code produce json? it creates a sqlcursor... I've tried SAVE AS ... INTO... TO FILE.... only produces cursors...

clear
lcDSNLess="DRIVER=Lianja ODBC Driver;...

Thanks Barry.. Very Cool!

I was going through the docs about json... In a SQL select statement there are options to return the results to file "json format is one the supported types"

Do I still need the added step of ...