Hi Wade,
I'm unsure why you send me this code...I'm not using nor have used the
Postgre DBMS.
Sorry, looks like the connection is similar to the mySQL sequence.
If you are the person that I was talking to on the RB Database Forums
about connection code, then I was inquiring about connecting to DBF files.
But not just that, I have an email into RB about how to convert the files
over to RealSQLDatabase. Seems like the cursor functions are needed and are
not documented. I still don't know how to get to the data field level.
Thanks for your response.
Dale Meier
----- Original Message -----
From: "Wade Little" <[EMAIL PROTECTED]>
To: "REALbasic NUG" <[email protected]>
Sent: Saturday, April 01, 2006 9:50 PM
Subject: Re: Postgre Plugin
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 3:38 PM, Christian Miller wrote:
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.
I use the PostgreSQL plugin almost daily without issue. Why don't you
show us your code?
Christian
Pariahware, Inc. Custom Software
<[EMAIL PROTECTED]>
<http://www.pariahware.com>
--
God loved you so much that He gave His only son Jesus. What have you
done with God's gift?
_______________________________________________
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>
_______________________________________________
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>
_______________________________________________
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>