Issue 3873 - Using ':x' in criterion of a query desgin generates an error
Summary: Using ':x' in criterion of a query desgin generates an error
Status: CLOSED DUPLICATE of issue 2794
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 641
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dirk.grobler
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-04-04 21:13 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-04-04 21:13:08 UTC 
Specs:

OO 641D (binaries)
RH 7.2
unixODBC 2.2.1
PostgreSQL 7.1.2

Using the ':x', i.e. ask for a variable on running query (its probably got a 
posh name!) causes the following error on excuting the query:

The data content could not be loaded /n Invalid descriptor index' 

It doesn't matter whether the field queried is an index or not.

The SQL status is 07009
Comment 1 Frank Schönheit 2002-04-05 07:57:44 UTC 
Garf,

does the solution suggested in
http://dba.openoffice.org/howto/param_subst.html solve your problem?
In this case, I'd like to mark this bug here as a duplicate of issue 2794.

- Frank
Comment 2 Unknown 2002-04-11 09:07:24 UTC 
Frank, my ignorance really comes out here. I've never used 
StarBasic and wouldn't know were to start :) Any guidance 
you could supply as to how I'm supposed to use this chunk of 
code would be appreciated. 
 
I've now found that using subforms causes the same problem, 
i.e. the same error. I'm trying to link master and slave 
variables between parent form and subform. Subforms are 
something I could really do with. 
 
Anyhow the error message is coming from the unixODBC driver, 
so I may give Nick over at EasySoft a quick email to see if 
there is anything he can do.
Comment 3 Frank Schönheit 2002-04-11 12:06:21 UTC 
Garf,

it's simple once you know it :):
* Tools/Macros
* Select Standard/Main
* Edit
=> the Basic IDE pops up
* repleace everything in the window with the macro text got from our site
* press F5
=> there you go


for the subforms problem: It's not surprising that it yields the same
effects: In both situations, we try to use named parameters (":x"
instead of "?"), which are obviously not supported by the driver (or
driver manager, not sure).
Comment 4 dirk.grobler 2002-04-22 07:53:45 UTC 
Marked as dublicate, as Frank suggested.

*** This issue has been marked as a duplicate of 2794 ***
Comment 5 michael.bemmer 2003-03-11 17:20:13 UTC 
As mentioned on the qa dev list on March 5th I will close all resolved duplicate
issues. Please see this posting for details. First step in IssueZilla is
unfortunately to set them to verified.
Comment 6 michael.bemmer 2003-03-11 17:58:00 UTC 
As mentioned on the qa dev list on March 5th I will close all resolved duplicate
issues. Please see this posting for details.
Comment 7 hans_werner67 2004-02-02 12:56:52 UTC 
change subcomponent to 'none'