Article View: borland.public.cppbuilder.database.ado
Article #4510ADO MSAccess SQL Query Problem
From: Michael Mouer
Date: Wed, 12 Dec 2001 20:13
Date: Wed, 12 Dec 2001 20:13
16 lines
1487 bytes
1487 bytes
Check the following please: "Select * From TableName Where Field1 = Variable1 And Field2 = Variable2" Error Message is "Project X.exe raised exception class EOleException with Message 'Parameter Variable1 has no default value'. Process stopped. Use Step or Run to continue." When I substitute a literal, 123, for variable1 and literal, 456, for variable2 it works correctly. Variable1 is a long integer and variable is a single float. I searched the Builder and MSAccess help files to no avail. Any help or suggestions greatly appreciated. Michael Mouer
Technical Details
Message-ID:
<3c17ba51$1_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed.frii.net!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,994d42e49a41be55,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-12-12 12:21:37 PST From: "Michael Mouer" <michael.mouer@sherwin.com> Sender: "Michael Mouer" <michael.mouer@sherwin.com> Reply-To: "Michael Mouer" <michael.mouer@sherwin.com> Subject: ADO MSAccess SQL Query Problem Newsgroups: borland.public.cppbuilder.database.ado X-User-Info: 148.141.31.19 148.141.31.19 NNTP-Posting-Host: 207.105.83.65 Message-ID: <3c17ba51$1_1@dnews> Date: 12 Dec 2001 12:13:05 -0800 X-Trace: dnews 1008187985 207.105.83.65 (12 Dec 2001 12:13:05 -0800) Lines: 17 Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed.frii.net!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews