🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #1105

requestlive=true query puts parantheses around fieldname in the Query->Fields->Fields->FieldName for certain queries

#1105
From: Glenn Denny
Date: Wed, 21 Jun 2000 00:00
16 lines
1373 bytes
Problem in C++ Builder 5
I am using a Pervasive SQL database that I am accessing using ODBC and
using regular (not ADO) data aware controls.

I am building a dynamic query based on criteria that the user enters.  I
have requestlive=true for this query.  On some combinations of fields in
the where clause, the BDE puts parantheses around the field name in the
"Query->Fields->Fields->FieldName" and my data aware controls on the
form that display the results of the query have "Field" set the field
name without the paranthesis around it so I get an error saying that it
is an invalid field.  This happens only to certain fields and also only
for certain combinations in the where clause.

The problem disappears when I set requestlive to false.

Veena
Technical Details
Message-ID: <3950DC24.CEA57B57@msn.com>
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: fcd2b,1cdd02c3ab09a016,start
X-Google-Attributes: gidfcd2b,public
From: Glenn Denny <nheragu@msn.com>
Subject: requestlive=true query puts parantheses around fieldname in the  Query->Fields->Fields->FieldName for certain queries
Date: 2000/06/21
Message-ID: <3950DC24.CEA57B57@msn.com>
X-Deja-AN: 637252350
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Trace: 21 Jun 2000 08:11:30 -0800, 209.215.125.84
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier