subject:"SQL Show Status"

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 just flying blind 
(as is often the case with LC documentation). 

But I’ve abandoned revdb now and opted entirely for php. That way I just use 
https for security. 

Next issue when I transfer back to HTML5 deployment of these apps is to work 
out how to get RSA encryption working. Probably another php script (which again 
will be insecure while feeding through JS, unless the Post command works ok in 
that environment - ??).  

All the best Bob 

Sean Cole
Pi Digital


> On 20 Oct 2020, at 22:20, Bob Sneidar via use-livecode 
>  wrote:
> 
> 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 I do instead is I first execute a telnet command using shell(). This 
> will tell me if I can get to the SQL server and if it’s listening. The next 
> thing you can do is execute a simple query SHOW STATUS will work as well as 
> anything else. You can also execute something like select 1+1 as sum. You 
> don’t even need to know a table or column. 
> 
> Bob S
> 
> 
>> On Oct 19, 2020, at 10:53 AM, matthias rebbe via use-livecode 
>>  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 
>>>> :
>>> 
>>> 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
>>>> 
>>>> 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
>>>> 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 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!'
>>>> 
> 
> ___
> use-livecode mailing list
> use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

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 I do instead is I first execute a telnet command using shell(). This will 
tell me if I can get to the SQL server and if it’s listening. The next thing 
you can do is execute a simple query SHOW STATUS will work as well as anything 
else. You can also execute something like select 1+1 as sum. You don’t even 
need to know a table or column. 

Bob S


> On Oct 19, 2020, at 10:53 AM, matthias rebbe via use-livecode 
>  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 
>> :
>> 
>> 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
>>> 
>>> 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
>>> 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 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!'
>>> 

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: SQL Show Status

2020-10-19 Thread Ralph DiMola via use-livecode

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
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: 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@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@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@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
> >> 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 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@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@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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

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 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@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@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
> >> 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 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@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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

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 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
>> 
>> 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
>> 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 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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

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
>
> 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
> 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 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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

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 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 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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

SQL Show Status

2020-10-19 Thread Sean Cole (Pi) via use-livecode

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    Pi Digital
Productions Ltd is a UK registered limited company, no. 5255609
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: SQL Show Status

Re: SQL Show Status

RE: SQL Show Status

Re: SQL Show Status

Re: SQL Show Status

Re: SQL Show Status

RE: SQL Show Status

SQL Show Status

8 matches

Site Navigation

Mail list logo

Footer information