Page 1 of 1

Installing SQLYoga

Posted: Mon Dec 25, 2017 8:36 am
by gagsoft
I coppied the SQLYoga downloaded folder into documents\my Livecode but it does not show in the development\plugins list.
I am totally new to SQLYoga and would really appreciate it if someone could just tell me where the files must go.
When playing with the French regions sample downloaded from the site, prior to loading the library, had no issue working through the demo. I noticed that the sql_yoga.rev file in the same folder as the sample

Many thanks
Peter G

Re: Installing SQLYoga

Posted: Tue Dec 26, 2017 12:35 am
by jameshale

Re: Installing SQLYoga

Posted: Tue Jan 02, 2018 6:03 am
by gagsoft
Hi james thank you for the link.

Much appreciated
Peter G

Re: Installing SQLYoga

Posted: Tue Jan 02, 2018 6:32 am
by gagsoft
Thanks for all the help.
Got sorted with the installation
Now got my first connection going and I am sort of stuck.
global dbID
set itemdelimiter to tab
put fld "sql1" into theQuery
put revDataFromQuery(,,dbID,theQuery) into theData
if theData contains "revdberr" then
answer warning "There is an error "&theData
exit to top
end if
put theData into fld "theResult"
Got it to store the data in a field but would like to rather put it into a datagrid.
Any advise on using the revDataFromQuery to achieve this would be appreciated.
Many Thanks

Peter G

Re: Installing SQLYoga

Posted: Tue Jan 02, 2018 6:46 am
by jameshale
Check out “dgData” in the dictionary.

Also, if using the current stable release of LC click on the “Guide” tab when you open the dictionary and have a look through the guide to the Data Grid, it is in the intermediate section.