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>

Reply via email to