SQL Show Status

[Ralph DiMola]

I don't use this method but this works.

put revDataFromQuery(,,YourDataseID,"SHOW STATUS")
This will return a tab delimited list, one per line.

put revDataFromQuery(comma,cr,YourDataseID,"SHOW STATUS")
This will return a comma delimited list, one per line.

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 2:31 PM
To: How to use LiveCode
Cc: Sean Cole (Pi)
Subject: Re: SQL Show Status

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 at 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 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
>
>
> _______________________________________________
> 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