Search:

Type: Posts; User: jmonte407

Search: Search took 0.00 seconds.

  1. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    just downloaded everything again.. tried to...

    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...
    ...
  2. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    Back to the same issue... nothing works for...

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

    by jmonte407
    Replies
    40
    Views
    12,078

    Success... I unistalled it again... deleted the...

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

    Thanks
    Jim
  4. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    I did have it stopped... I tried reinstalling...

    I did have it stopped... I tried reinstalling it 3 or 4 times... with the same results..
  5. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    Thanks Barry...

    Thanks Barry...
  6. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    Just install the latest of everything... I was...

    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...
  7. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    I know this... was just hoping something like...

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

    by jmonte407
    Replies
    40
    Views
    12,078

    Thanks Barry... 99% of what we will be...

    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 ...
  9. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    Thanks Barry.... I'm only testing this stuff...

    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"......
  10. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    I'm an adminstrator on this computer.. the folder...

    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...
  11. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    I'm running the code from the server.. is it...

    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...
  12. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    why doesnt this code produce json? it creates a...

    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;...
  13. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    Thanks Barry.. Very Cool!

    Thanks Barry.. Very Cool!
  14. Thread: sql select

    by jmonte407
    Replies
    40
    Views
    12,078

    sql select

    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 ...
Results 1 to 14 of 14
Journey into the Cloud
Join us