DRW custom query

T

Tim Thorp

The following query works great in Access, but fails when put into DRW
Custom Query in FP2002 with a default scripting language of JavaScript:

SELECT registrations.platform, Count(registrations.registrationID) AS
CountOfWindows
FROM registrations
GROUP BY registrations.platform
HAVING (((registrations.platform)="Windows"));

The error message is

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DRW Error 0
SQL Statement 4
Shorter format for Date field from Access 1
data results error with union query? 9
Delete Record 4
User Defined Function 1
Database Results Error 2
Help! Help! ASP Form 6

Top