Re: SQL Show Status

2020-10-20 Thread Pi Digital via use-livecode
I was actually trying to look at the sslcypher tag. Wanted to see if it thought the server was enabled for it and if the certs would work. But there was no way of telling using revdb if the certs were wrong, if the server was set or anything. No one was able to tell me how to find out and was

Re: SQL Show Status

2020-10-20 Thread Bob Sneidar via use-livecode
I’m wondering what status you are trying to retrieve. If you are wanting to see if the SQL database is accessible/online, using an actual query has it’s drawbacks. Querying an SQL database that is inaccessible will result in a 60 second timeout during which Livecode will be unresponsive. What

RE: SQL Show Status

2020-10-19 Thread Ralph DiMola via use-livecode
T 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 2:31 PM To: How to use LiveCode Cc: Sean Cole (Pi) Subject: Re:

Re: SQL Show Status

2020-10-19 Thread Sean Cole (Pi) via use-livecode
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@lists.runrev.com> wrote: > You have to use > > revDataFromQuery() > > because that will execute the SQL

Re: SQL Show Status

2020-10-19 Thread matthias rebbe via use-livecode
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 > : > > Hi

Re: SQL Show Status

2020-10-19 Thread Sean Cole (Pi) via use-livecode
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

RE: SQL Show Status

2020-10-19 Thread Ralph DiMola via use-livecode
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