ado for odbc

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 jane Tue, 10 Apr 2001 05:41

#661

Author: jane
Date: Tue, 10 Apr 2001 05:41

19 lines
1569 bytes

For three_tier application,on the appliction server, I put
a TADOConnection,a TADODataSet,a TDataSetProvider In the
Transaction Data Module. The TADOConnect connect a
SQLSERVER database by ado for odbc.

in sqlserver database table,i have a datatime field,
it's default value is (getdate()).

in client app,i insert a new record ,i don't set the
datatime field's value,i want the default value.The
ClientDataSet execute ApplyUpdates(0) successfully.
then i modify one of the records ,error "user by another
user" display.
that is, inserting a new record is right,modifiing a
record is error,why???

thanks

(i am sorry that my english is poor)

Re: ado for odbc

#685

Author: jane
Date: Tue, 24 Apr 2001 08:44

30 lines
1814 bytes

it is about precision.
in sqlserver,getdate() has time  00:00.00000
but general,time likes 00:00

jane <janez@pbtco.com> wrote in message news:3ad29b55_2@dnews...
> For three_tier application,on the appliction server, I put
> a TADOConnection,a TADODataSet,a TDataSetProvider In the
> Transaction Data Module. The TADOConnect connect a
> SQLSERVER database by ado for odbc.
>
> in sqlserver database table,i have a datatime field,
> it's default value is (getdate()).
>
> in client app,i insert a new record ,i don't set the
> datatime field's value,i want the default value.The
> ClientDataSet execute ApplyUpdates(0) successfully.
> then i modify one of the records ,error "user by another
> user" display.
> that is, inserting a new record is right,modifiing a
> record is error,why???
>
> thanks
>
> (i am sorry that my english is poor)
>
>
>
>
>
>

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