-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Bapi_from_cal
Message 2 in Discussion
hi rahul
check ur challadate format in vb u have given the
value of date time format
pradeep
----- Original Message -----
From:
rahulvb
To: MumbaiUserGroup
Sent: Thursday, September 09, 2004 1:06
PM
Subject: Problem in SQL Query
New Message on MumbaiUserGroup
Problem
in SQL Query
Reply
Reply to Sender Recommend
Message 1 in
Discussion
From: rahulvb
Hi,
I have the following query for Access 2000
backend
UPDATE MatChallan SET
SuppId=13,ChallaDate='08/05/2004 10:14:19
AM',SuppChNo='
',SuppChDate='07/30/2004',VehicleNo='MH-15
G-106',UserId=1,ClientId=2,SiteId=2,DFlag='T',InvNo=26,VSize='
',EntryDate='08/05/2004',Rem1=Null,Rem2=Null,Rem3=Null
WHERE refid = 94
If executed from VB with connection object it gives error
saying "Syntax error in string in query expression"
But if the same query is executed from access - query
wizard it is running perfectly fine.
Can anyone suggest what might be the problem.
Thanks.
Rahul.
View other groups in this
category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
