Variable Database in revdb_connect

Jeff Honken jhonken at
Wed Jan 4 12:57:07 EST 2006

That worked great thanks,  With the little test script that I wrote it
connects great the first time but if I press the button a second time it
gives me an error.  Can you give me some insight into why it errors on
the second attempt to connect.  Will it always error if I don't close
the connection of the previous connection first?  I thought it would
just connect again with a different connection ID. 

-----Original Message-----
From: use-revolution-bounces at
[mailto:use-revolution-bounces at] On Behalf Of Björnke
von Gierke
Sent: Wednesday, January 04, 2006 10:16 AM
To: How to use Revolution
Subject: Re: Variable Database in revdb_connect

You got some errors in your query...
try this string:

put revdb_connect("sqlite", database ,,,,, "Address at", "bdJycJ") 
into tConID

also it is recommended to always quote strings, as it could get you in 
trouble if you later make a variable with that name:

put "x12provider" into database

On Jan 04 2006, at 18:02, Jeff Honken wrote:

> on mouseUp
>      put x12provider into database
>   put revdb_connect("sqlite","& database
> &",,,,,"Address at","bdJycJ") into tConID
>   if tConID is "" then
>     answer warning "Problem creating or accessing database!"
>   else
>     put tConID into gConID
>   end if
>   answer gConID
> end mouseUp

use-revolution mailing list
use-revolution at
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:

More information about the Use-livecode mailing list