SQL Show Status

[Ralph DiMola]

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