SQL Show Status

[matthias_livecode_150811 at m-r-d.de]

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 at 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 at 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
>> rdimola at evergreeninfo.net
>> 
>> 
>> -----Original Message-----
>> From: use-livecode [mailto:use-livecode-bounces at 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode