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