Board index » delphi » Can't SQLClientDataSet support Date type data?

wen

Delphi Developer
Fri, 17 Dec 2004 16:20:43 GMT

Can't SQLClientDataSet support Date type data?

I use a SQLClientDataSet control to connect a InterBase Database table which
have some Date type fields. When i set the SQLClientDataSet's active
property to 'true',i get a error message which say:
'unknown data type.  Client SQL dialect 1 does not support reference to DATE
datatype.'

Can't  SQLClientDataSet support Date type data?
Can i have another way to solve the proble?

 
Dave Rowntre

Delphi Developer
Fri, 17 Dec 2004 18:18:36 GMT

Re:Can't SQLClientDataSet support Date type data?


Don't use TSQLClientDataSet. It is not recommended for use in an
application. Use
 TSQLDataSet/TSQLQuery -> TDataSetProvider -> TClientDataSet
instead.

Have a look in Google for more information on TSQLClientDataSet.

--
Dave Rowntree

Quote
"wen" <yh...@163.com> wrote in message news:3d2011e6_1@dnews...
> I use a SQLClientDataSet control to connect a InterBase Database table
which
> have some Date type fields. When i set the SQLClientDataSet's active
> property to 'true',i get a error message which say:
> 'unknown data type.  Client SQL dialect 1 does not support reference to
DATE
> datatype.'

> Can't  SQLClientDataSet support Date type data?
> Can i have another way to solve the proble?

Bill Tod

Delphi Developer
Fri, 17 Dec 2004 20:52:24 GMT

Re:Can't SQLClientDataSet support Date type data?


As Dave said, do not use TSQLClientDataSet. Also, set the dialect in
the Params property of the SQLConnection to 3 to match the dialect of
your database.

Quote
On Mon, 1 Jul 2002 16:20:43 +0800, "wen" <yh...@163.com> wrote:
>I use a SQLClientDataSet control to connect a InterBase Database table which
>have some Date type fields. When i set the SQLClientDataSet's active
>property to 'true',i get a error message which say:
>'unknown data type.  Client SQL dialect 1 does not support reference to DATE
>datatype.'

>Can't  SQLClientDataSet support Date type data?
>Can i have another way to solve the proble?

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
wen

Delphi Developer
Fri, 17 Dec 2004 22:07:13 GMT

Re:Can't SQLClientDataSet support Date type data?


Thank Dave and Bill.
But i can not understand why all of you suggest me not use TSQLClientDataSet
since Borland have offered me the contrl? Would you like give me a
explanation?
Quote
"Bill Todd" <b...@notthis.dbginc.com> wrote in message

news:92k0iuskq314qtat199t2a0uj5k9pegpov@4ax.com...
Quote
> As Dave said, do not use TSQLClientDataSet. Also, set the dialect in
> the Params property of the SQLConnection to 3 to match the dialect of
> your database.

> On Mon, 1 Jul 2002 16:20:43 +0800, "wen" <yh...@163.com> wrote:

> >I use a SQLClientDataSet control to connect a InterBase Database table
which
> >have some Date type fields. When i set the SQLClientDataSet's active
> >property to 'true',i get a error message which say:
> >'unknown data type.  Client SQL dialect 1 does not support reference to
DATE
> >datatype.'

> >Can't  SQLClientDataSet support Date type data?
> >Can i have another way to solve the proble?

> --
> Bill (TeamB)
> (TeamB cannot respond to questions received via email)

Dave Rowntre

Delphi Developer
Fri, 17 Dec 2004 23:09:22 GMT

Re:Can't SQLClientDataSet support Date type data?


Quote
> But i can not understand why all of you suggest me not use
TSQLClientDataSet
> since Borland have offered me the contrl? Would you like give me a
> explanation?

Not really :)

There are numerous problems. Take my advise and have a look in Google for
information. Do a search on 'SQLClientDataSet' here:
http://www.google.com/advanced_group_search?hl=en

--
Dave Rowntree

Bill Tod

Delphi Developer
Sat, 18 Dec 2004 02:25:19 GMT

Re:Can't SQLClientDataSet support Date type data?


Many problems with SQLClientDataSet surfaced after D6 shipped and
Borland now recommends that it not be used. If you want examples do a
search on Google Groups.

Quote
On Mon, 1 Jul 2002 22:07:13 +0800, "wen" <yh...@163.com> wrote:
>Thank Dave and Bill.
>But i can not understand why all of you suggest me not use TSQLClientDataSet
>since Borland have offered me the contrl? Would you like give me a
>explanation?
>"Bill Todd" <b...@notthis.dbginc.com> wrote in message
>news:92k0iuskq314qtat199t2a0uj5k9pegpov@4ax.com...
>> As Dave said, do not use TSQLClientDataSet. Also, set the dialect in
>> the Params property of the SQLConnection to 3 to match the dialect of
>> your database.

>> On Mon, 1 Jul 2002 16:20:43 +0800, "wen" <yh...@163.com> wrote:

>> >I use a SQLClientDataSet control to connect a InterBase Database table
>which
>> >have some Date type fields. When i set the SQLClientDataSet's active
>> >property to 'true',i get a error message which say:
>> >'unknown data type.  Client SQL dialect 1 does not support reference to
>DATE
>> >datatype.'

>> >Can't  SQLClientDataSet support Date type data?
>> >Can i have another way to solve the proble?

>> --
>> Bill (TeamB)
>> (TeamB cannot respond to questions received via email)

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads

1. IB's DATE data type

2. It's not bad canned meat...

3. SQLClientDataSet.LoadFromFile('file.xml') doesnt work :-(

4. why ADO not support oracle BLOB data type?

5. Blob and array data types are not supported for compare operation

6. BLOB and array data types are not supported...

7. BLOB and array data types are not supported for move operation

8. BDE support of the Text data type in SQL Server 2000

9. BLOB and array data types are not supported for compare operation

10. Blob and array data types are not supported for compare operation