Article View: borland.public.cppbuilder.database.multi-tier
Article #1105requestlive=true query puts parantheses around fieldname in the Query->Fields->Fields->FieldName for certain queries
From: Glenn Denny
Date: Wed, 21 Jun 2000 00:00
Date: Wed, 21 Jun 2000 00:00
16 lines
1373 bytes
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-mailShow 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