Installing SQLYoga

This is the place to post technical queries about SQL Yoga

Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore

Post Reply
gagsoft
Posts: 168
Joined: Sat Jun 29, 2013 7:56 pm

Installing SQLYoga

Post by gagsoft » Mon Dec 25, 2017 8:36 am

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

jameshale
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 474
Joined: Thu Sep 04, 2008 6:23 am
Location: Melbourne Australia

Re: Installing SQLYoga

Post by jameshale » Tue Dec 26, 2017 12:35 am


gagsoft
Posts: 168
Joined: Sat Jun 29, 2013 7:56 pm

Re: Installing SQLYoga

Post by gagsoft » Tue Jan 02, 2018 6:03 am

Hi james thank you for the link.

Much appreciated
Peter G

gagsoft
Posts: 168
Joined: Sat Jun 29, 2013 7:56 pm

Re: Installing SQLYoga

Post by gagsoft » Tue Jan 02, 2018 6:32 am

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

jameshale
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 474
Joined: Thu Sep 04, 2008 6:23 am
Location: Melbourne Australia

Re: Installing SQLYoga

Post by jameshale » Tue Jan 02, 2018 6:46 am

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.

Post Reply

Return to “SQL Yoga”