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

Re: Passing parameters to postgreSQL from MS Access 2000

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: ben sewell <mosherben(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Passing parameters to postgreSQL from MS Access 2000
Date: 2006-08-23 20:04:51
Message-ID: 20060823200451.53614.qmail@web31807.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
>     MyQry.SQL = "select * from reports
>
([Adviser_ID.Text],[Provider_ID.Text],[Introducer_ID.Text],[PlanGroup_ID.Text],[PlanType_ID.Text],[DateSpecific_Start.Text],[DateSpecific_End.Text],
> Child24.Form.CurrentRecord , Child26.Form.CurrentRecord) as
> (employee_first_name varchar,employee_last_name varchar,date_issued
> date,client_first_name varchar,client_middle_names varchar,client_surname
> varchar,tblplantypes.plantype_group varchar,plangroups.plangroups_groupvarchar,
> tblproviders.provider_company varchar,policy_number varchar,sum_assured
> numeric,benefit varchar, premium numeric,brokerage numeric, comments text);"


I think I see your problem here. You still need to parse you sql strings with &.
So where ever you need to pass a integer it must be passed like:

"select * from reports (" & [adviser_ID.text] & ", .... "  -- for integer parameters and

",'" & [dateSpecific_end.Text] & "', .... "  -- for string parameters.


This link http://www.fontstuff.com/access/acctut20.htm show how to incorporate Access controls
into the sql string.

Regards,

Richard Broersma Jr.

In response to

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2006-08-23 20:57:44
Subject: Re: Conditional INSERT: if not exists
Previous:From: Don MorrisonDate: 2006-08-23 19:48:53
Subject: Re: Conditional INSERT: if not exists

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