SQL Show Status

Sean Cole (Pi) sean at pidigital.co.uk
Mon Oct 19 13:41:53 EDT 2020


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
>



More information about the use-livecode mailing list