----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: SameerK Message 6 in Discussion Hi Rahul,<o:p></o:p> MS Access drivers by do not support the ��� (single quote) for the date updates.<o:p></o:p> <o:p> </o:p> Instead use following query<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> OR<o:p></o:p> <o:p> </o:p> I have not done the following settings but you can try it out<o:p></o:p> <o:p> </o:p> In the Menu Tools Options Tab Tables/Queries<o:p></o:p> Check �SQL Server Compatible Syntax (ANSI 92)� for �This Database�<o:p></o:p> And try executing your query.<o:p></o:p> <o:p> </o:p> Do let me know the development on this<o:p></o:p> With Regards, Sameer Koranne e-Mail : [EMAIL PROTECTED] <o:p></o:p> From: rahulvb [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 1:06 PM To: <st1:PersonName w:st="on">MumbaiUserGroup</st1:PersonName> Subject: Problem in SQL Query<o:p></o:p> <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> DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ----------------------------------------------------------- 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]
