🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.intrabuilder.data.sql
Article #6

multiple parameters problem

#6
From: TOM DELANEY
Date: Mon, 27 Oct 1997 00:00
23 lines
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-mail

Show 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