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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 ,,,,, "[EMAIL PROTECTED]", "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 > &",,,,,"[EMAIL PROTECTED]","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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
