Board index » cppbuilder » TQuery returning nonsence

2004-09-29 08:35:31 PM
cppbuilder64
Hi all,
I've got one problem on TQuery,
when it's querying a table which has some fields empty, it puts some stupid
characters in there...
didn't realize why, because there's nothing in physical database...
I have oracle8.i
thanks for assistance anyway :)
bye bye
 

Hello George,
Are you using ODBC ?
Jayme.
"George" < XXXX@XXXXX.COM >escreveu na mensagem

Hello Jayme,
no I'm using BDE...
"Jayme Jeffman Filho" < XXXX@XXXXX.COM >wrote in message

{smallsort}

Hello George,
I've had some problems with BDE-Oracle data retrieval, especially
when getting nulls from a date field. You can check if it is your problem
or BDE, configuring an alias to connect to the same Oracle database
and try the same query on Database Explorer.
You can try fill up null values with default values, as an empty string
for varchar fields and TDateTime(0) for date fields and so on.
The problems you're facing may actually be BDE bugs.
I've only got rid of this problems when I've gave away the SQL links
or ODBC drivers and started to use the components of Crlab (ODAC).
Nowadays I'm very comfortable using them.
HTH.
Jayme.
"George" < XXXX@XXXXX.COM >escreveu na mensagem

Yes that must be it...
actually I already figured out that default values are helping out with this
problem.
thanks a lot.
and well, I have a really big project which is more then 50mb already,
and well I really have a lot and a lot TQuery's inside.
so changing the component is not my option at this moment.
thanks anyway.
and by the way, is that component you mentioned free??
I might need it in future.
"Jayme Jeffman Filho" < XXXX@XXXXX.COM >wrote in message

No, I'm sorry, but they are very cheap, US$ 99 for a single license, and
I bet you'll make much more using them. You can download a demo
version from their web site www.crlab.com . Why don't you give them a
try ?
Good luck.
Jayme.
"George" < XXXX@XXXXX.COM >escreveu na mensagem

thanks Jayme!
"Jayme Jeffman Filho" < XXXX@XXXXX.COM >wrote in message