Skip site navigation (1) Skip section navigation (2)

VB, RDO, and Parameters

From: "Krasnow, Greg" <gak(at)hnc(dot)com>
To: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: VB, RDO, and Parameters
Date: 1998-05-27 21:43:40
Message-ID: C162BB3549A5CF118D7400805FD4122401576E6D@pchnc.hnc.com (view raw or flat)
Thread:
Lists: 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(at)hnc(dot)com
Direct Phone: 619.799.8341
Fax: 619.799.8036



Responses

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1998-05-27 23:03:35
Subject: Re: [INTERFACES] VB, RDO, and Parameters
Previous:From: Byron NikolaidisDate: 1998-05-27 19:33:51
Subject: Got the Cursor Library to work! YE HA!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group