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: (view raw or whole thread)
Lists: pgsql-interfaces
Has anyone been able to create Parameterized queries for PostresSQL (using

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


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-2015 The PostgreSQL Global Development Group