🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.cppbuilder.database.multi-tier
1 messages
1 total messages Started by Bruce Wed, 04 Jul 2001 00:32
ClientdataSet TDateTimeFile SQL Server update
#542
Author: 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
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