ClientdataSet TDateTimeFile SQL Server update

Article View: borland.public.cppbuilder.database.multi-tier

Article #542

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#542

From: Bruce
Date: Wed, 04 Jul 2001 00:32

20 lines
1259 bytes

Hi,

    I'm trying to update a datetime field in a SQL Server table
    in the following way:-

    ClientDataSet->Edit ();
    ClientDataSet->FieldByName("DATE_VERIFIED")->AsDateTime= Now ();
    ClientDataSet->ApplyUpdates (-1);

    Something goes wrong though. The SQL statement generated looks like
this:-

    update LISTING_CONTACT  se
    where
    LISTING_ID = 13 and ...

    Any ideas about what's happening?

    Thanks
    Bruce

Technical Details

Message-ID: <3b4263e0_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!128.230.129.106!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,6f3dc75d136a3374,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-07-03 17:48:57 PST
From: "Bruce" <bruce@mmp.com.au>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: ClientdataSet TDateTimeFile SQL Server update
Date: Wed, 4 Jul 2001 10:32:42 +1000
Lines: 23
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
NNTP-Posting-Host: 139.130.100.41
Message-ID: <3b4263e0_2@dnews>
X-Trace: dnews 994206688 139.130.100.41 (3 Jul 2001 17:31:28 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!128.230.129.106!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews