Article View: borland.public.intrabuilder.data.sql
Article #6multiple parameters problem
From: TOM DELANEY
Date: Mon, 27 Oct 1997 00:00
Date: Mon, 27 Oct 1997 00:00
23 lines
1309 bytes
1309 bytes
Environment: Intrabuilder 1.01 the client/server trial version Database: Oracle 7 I am trying to run a huge, complex sql that has 4 parameters. One is a string, one numeric and two are dates. Each of these parameters are repeated several times throughout the statement (for a total of 20). If I try to run the sql with just the 4 parameters repeated throughout, I get the message: Database Engine Error: Parameter not set in query string. I have gotten my big query to work if I specify the 4 parameters just once in the sql and hard code the values in the other spots. (which obviously is not a working solution) It's a huge drag to make each parameter unique (ex. pat_dob, pat_dob2). I have gotten this to work on a much simpler query, but on this big query I get an incorrect result. I know the sql works because it has worked for months in PowerBuilder and PL/SQL. Any ideas??
Technical Details
Message-ID:
<345530F5.222@postoffice.worldnet.att.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 101d9a,2df098a3ddab6ed1,start X-Google-Attributes: gid101d9a,public From: TOM DELANEY <TOMDELANEY@postoffice.worldnet.att.net> Subject: multiple parameters problem Date: 1997/10/27 Message-ID: <345530F5.222@postoffice.worldnet.att.net> X-Deja-AN: 285436290 Organization: None Newsgroups: borland.public.intrabuilder.data.sql