problem using TTable->Filter with date fields

Hi,

I´m having some trouble with MyODBC. When I make a filter for a Date
field in a TTable in Borland C++ Builder, I got an "Operation not
applicable" error. What´s wrong ????

table->Filter = "mydate = '01/01/2004'";
table->Filtered=true;

I´m working with MyODBC 3.51.

Thanks in advance.

Denys Sene
Lorena/São Paulo/Brazil



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: problem using TTable->Filter with date fields

Try this:

table->Filter = "mydate = '2004-01-01'";
table->Filtered=true;


Or better yet just add this filter as a where clause when you open the resultset.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: problem using TTable->Filter with date fields

with this format I have : "Invalid date format" because ODBC works with
the dd/mm/yyyy format.
But I don?t know why this happens. I?m very acostumated with SQL syntax
and I use the format yyyy-mm-dd... ODBC is new for me... maybe I doing
some mistake here.
Also the other suggestion from Jeff, with yyyy/mm/dd did not work.
Anyone more????

robert_rowe wrote:

>Try this:
>
>table->Filter = "mydate = '2004-01-01'";
>table->Filtered=true;
>
>
>Or better yet just add this filter as a where clause when you open the resultset.
>
>
>


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: problem using TTable->Filter with date fields

Hi,
Open recordset with date converted to string and use the filter it will
work.
Even VB Adodd filter method also it gives this error.
So try convert all into string and check

Regards
John
-----Original Message-----
From: Denys Sene dos Santos [mailto:denys.sene@itelefonica.com.br]
Sent: Monday, January 05, 2004 06:19
To: myodbc@lists.mysql.com
Subject: Re: problem using TTable->Filter with date fields



with this format I have : "Invalid date format" because ODBC works with
the dd/mm/yyyy format.
But I don?t know why this happens. I?m very acostumated with SQL syntax
and I use the format yyyy-mm-dd... ODBC is new for me... maybe I doing
some mistake here.
Also the other suggestion from Jeff, with yyyy/mm/dd did not work.
Anyone more????

robert_rowe wrote:

>Try this:
>
>table->Filter = "mydate = '2004-01-01'";
>table->Filtered=true;
>
>
>Or better yet just add this filter as a where clause when you open the
>resultset.
>
>
>


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:
http://lists.mysql.com/myodbc?unsub=johnphilip@justdial.com



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org