See, I tried that but hadn't put the delimiters in. I need a break :/ Thanks Matthias :)
Sean Cole *Pi Digital* On Mon, 19 Oct 2020 at 18:53, matthias rebbe via use-livecode < use-livecode@lists.runrev.com> wrote: > You have to use > > revDataFromQuery() > > because that will execute the SQL statement and will return any data that > is coming from the DB Server. > > Regards, > Matthias > > - > Matthias Rebbe > Life Is Too Short For Boring Code > > > Am 19.10.2020 um 19:41 schrieb Sean Cole (Pi) via use-livecode < > use-livecode@lists.runrev.com>: > > > > Hi Ralph, > > > > What do I do to see the data in the two columns? My brain is hurting too > > much to figure it out. > > > > Thanks > > Sean > > > > On Mon, 19 Oct 2020 at 18:26, Ralph DiMola via use-livecode < > > use-livecode@lists.runrev.com> wrote: > > > >> Sean, > >> > >> revQueryDatabase(tConnId, “SHOW STATUS”) only returns an integer > >> > >> That integer is a record set. > >> In my case it returned 536 rows. > >> Each row has two columns: > >> Variable_name > >> Value > >> > >> > >> Let me tell you Mr. Johnson... Some very interesting stuff in there. > >> > >> Ralph DiMola > >> IT Director > >> Evergreen Information Services > >> rdim...@evergreeninfo.net > >> > >> > >> -----Original Message----- > >> From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On > >> Behalf Of Sean Cole (Pi) via use-livecode > >> Sent: Monday, October 19, 2020 12:50 PM > >> To: How to use LiveCode > >> Cc: Sean Cole (Pi) > >> Subject: SQL Show Status > >> > >> Hi > >> > >> As everyone likes to hijack threads here, I’ve started another to make > >> sure it gets seen. > >> > >> > >> revQueryDatabase(tConnId, “SHOW STATUS”) only returns an integer > >> > >> Same for revdb_execute which returns 0 > >> > >> Any clues on how to actually get the status back? > >> > >> Still trying to work out why these certificates are not working. > >> -- > >> Sean Cole > >> *Pi Digital Productions Ltd* > >> www.pidigital.co.uk > >> +44(1634)402193 > >> +44(7702)116447 > >> 'Don't try to think outside the box. Just remember the truth: There is > no > >> box!' > >> 'For then you realise it is not the box you are trying to look outside > of, > >> but it is yourself!' > >> > >> eMail Ts & Cs <http://pidigital.co.uk/emailTCs.rtf> Pi Digital > >> Productions Ltd is a UK registered limited company, no. 5255609 > >> _______________________________________________ > >> use-livecode mailing list > >> use-livecode@lists.runrev.com > >> Please visit this url to subscribe, unsubscribe and manage your > >> subscription preferences: > >> http://lists.runrev.com/mailman/listinfo/use-livecode > >> > >> > >> _______________________________________________ > >> use-livecode mailing list > >> use-livecode@lists.runrev.com > >> Please visit this url to subscribe, unsubscribe and manage your > >> subscription preferences: > >> http://lists.runrev.com/mailman/listinfo/use-livecode > >> > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
