datetime format error

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

Article #313

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

#313

From: chinawsb
Date: Fri, 04 Jan 2002 00:47

8 lines
1273 bytes

Hi,everyone:
   I create a table with datetime format in SQL Server 2000,and in a
multi-tier client,I wan't update it some field values, I find the MIDAS
generate the SQL Command like this:
   sp_executesql 'Update XXX Set Value=@P0 where
AField=@P1',N'@P0=102,@P='2001-12-30 9:00 PM'
   But in table XXX,AField value like '2001-12-30 9:00:34.230',so the
command update nothing.Can you tell me what can I to do?

Technical Details

Message-ID: <3c34fbc4_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!KWeb!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,a7cf59ab98ff92cd,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2002-01-03 16:53:22 PST
Reply-To: "chinawsb" <chinawsb@163.net>
From: "chinawsb" <chinawsb@163.net>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: datetime format error
Date: Fri, 4 Jan 2002 08:47:36 +0800
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 61.139.130.110
Message-ID: <3c34fbc4_2@dnews>
X-Trace: dnews 1010105284 61.139.130.110 (3 Jan 2002 16:48:04 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!KWeb!dnews