----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: PreetamKumar Message 4 in Discussion Try this .. <o:p></o:p> 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<o:p></o:p> <o:p> </o:p> Put date in between ##. <o:p></o:p> <o:p> </o:p> prakash<o:p></o:p> -----Original Message----- From: rahulvb [mailto:[EMAIL PROTECTED] Sent: <st1:date Month="9" Day="9" Year="2004">Thursday, September 09, 2004</st1:date> <st1:time Hour="13" Minute="6">1:06 PM</st1:time> To: MumbaiUserGroup Subject: Problem in SQL Query <o:p> </o:p> <o:p></o:p> <o:p></o:p> New Message on MumbaiUserGroup<o:p></o:p> <o:p></o:p> <o:p> </o:p> Problem in SQL Query<o:p></o:p> Reply <o:p></o:p> <o:p></o:p> Reply to Sender Recommend <o:p></o:p> Message 1 in Discussion <o:p></o:p> <o:p></o:p> From: rahulvb <o:p></o:p> <o:p> </o:p> Hi,<o:p></o:p> I have the following query for Access 2000 backend<o:p></o:p> <o:p></o:p> 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<o:p></o:p> <o:p></o:p> If executed from VB with connection object it gives error saying "Syntax error in string in query expression"<o:p></o:p> <o:p></o:p> But if the same query is executed from access - query wizard it is running perfectly fine.<o:p></o:p> <o:p></o:p> Can anyone suggest what might be the problem.<o:p></o:p> <o:p></o:p> Thanks.<o:p></o:p> Rahul.<o:p></o:p> <o:p></o:p> View other groups in this category. language="JavaScript" type="text/javascript"> document.write(''); </script> ----------------------------------------------------------- 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]
