VB, RDO, and Parameters - Mailing list pgsql-interfaces

From Krasnow, Greg
Subject VB, RDO, and Parameters
Date
Msg-id C162BB3549A5CF118D7400805FD4122401576E6D@pchnc.hnc.com
Whole thread Raw
List pgsql-interfaces
Has anyone been able to create Parameterized queries for PostresSQL (using
PostODBC)?

I have a VB app which works fine for Oracle, Access, DB/2, Informix, etc...
and I am trying to use it with a postgres database.  In the app I have a
parameter query (i.e. "SELECT ... WHERE fdl1 = ?")  I was getting a parse
error on this from the psotgres engine.  I then tried using "SELECT ...
WHERE fld1 = $1" and am now getting parameter $1 out of range?  Has anyone
out there done anything similar to this?

- Greg


Greg Krasnow
HNC Software Inc.
Financial Industry Solutions
Senior Software Engineer
Email: gak@hnc.com
Direct Phone: 619.799.8341
Fax: 619.799.8036



pgsql-interfaces by date:

Previous
From: Byron Nikolaidis
Date:
Subject: Got the Cursor Library to work! YE HA!
Next
From: Byron Nikolaidis
Date:
Subject: Re: [INTERFACES] VB, RDO, and Parameters