Hi Wade,
It looks like you made a RB syntax error. Remove the "End If" line
just above the "ElseIf."
Cheers,
Marc
PS: If you're serious about PostgreSQL and want to be able to use all
of its features, do have a look at pgSQL4RB. ;-)
Here is my code to open the connection or close the connection.
This plugin workers great if the DB is available...the problem is
only if the DB is not available....it properly detects that the
db.connect fails but then if I close the application it end
unexpectedly with error.
This is in a method that is passed open or close and returns Boolean:
db=New PostgreSQLDatabase
db.host="10.0.1.7"
db.port=5432
db.databaseName="postgres"
db.userName="postgres"
db.Password="postgres"
If command="open" then
If db.Connect then
Return true
else
Return false
end if
end if
Elseif command="close" then
db.close
return true
end if
On Apr 1, 2006, at 12:11 AM, Wade Little wrote:
Does anyone else on here use the Postgre plugin for RB? I am
having trying to use it and for the most part it does work but
there are some issues that I cant figure out. When my
application starts up I verify that I can make a connection to the
database by connecting to it which works fine if it passes. The
problem is when the connection does not pass so the database
connection never opened.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
