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

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Glenn Denny Wed, 21 Jun 2000 00:00

#1105

Author: 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

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

#1013

Author: Mark Cashman (TeamB)
Date: Thu, 22 Jun 2000 00:00

21 lines
1504 bytes

Hi, Glenn!

I have never heard of such a thing happening. However, since this is not
a specifically multi-tier question, perhaps posting in
borland.public.cppbuilder.database.desktop, where general database
questions are asked, or in
borland.public.cppbuilder.database.sqlservers, where client server
database topics are covered, can get you a better answer.

I would also recommend you post a sample before BDE change and after BDE
change query when you post in whatever group you select so as to make
possible causes stand out better.

I hope this helps you get an answer.

------
Mark Cashman, TeamB C++ Builder
http://www.temporaldoorway.com/programming/index.htm
C++ Builder, JBuilder programming information
Home of The C++ Builder Programmer's Webring - Join us!
------

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads