Autosearch with datetime

rbuser

Hello, i couldn't found anyone with a problem like this....

i need an autosearch panel on a DateTime Field...

the query designer puts like it was a date field... so....

...
where
mydate between '2001-08-09' and '2001-08-09'


and i want that it do

...
where
cast(mydate as date) between '2001-08-09' and '2001-08-09'

i'm trying without sucess to create an autosearchpanel to this... but i
can't change the field_alias in sql from an autosearch panel... i can?


thanks...

digitalmetaphors

You can extract the TdaSQL object, if you want to change the SQL field
alias. There is a techtip article in the CodeBased newsgroup thread which
describes how to do this. To get a select field, use the
TdaSQL.SelectFields[] and SelectFieldsCount properties. This array property
will give you access to the SQL SELECT field objects. You can look in
TdaSQL.pas for the TdaField class if you want to change the TdaField's field
alias.


Cheers,

Jim Bennett
Digital Metaphors