Help with Access Command

MLDatabase allows MLServer3 to interact with any ODBC database that you create or attach to. Intended for advanced users only.
User avatar
itanic
Intermediate
Intermediate
Posts: 455
Joined: Tue Jun 15, 2004 10:05 am
Location: Oregon
Contact:

Help with Access Command

Postby itanic » Wed Jan 21, 2009 1:44 pm

When I issue the command

Macro|
MLDataBase|Process_Command~Equipment_RunTime~SELECT DeviceName, Sum(DateDiff("n",([StartTime]),([EndTime]))) AS UpTime FROM RunTimes GROUP BY DeviceName~RunTime_LTD

It returns the error:

Error -2147217904([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.) @ Line 1170 in procedure doCmd of frmMain

I've tried various different ways but can't seem to get it working. Any database experts out there that can help me with this?

User avatar
CinemarDave
Site Admin
Site Admin
Posts: 10535
Joined: Fri Feb 07, 2003 8:56 am
Location: Planet Earth
Contact:

Postby CinemarDave » Wed Jan 21, 2009 1:48 pm

Change "n" to ""n"" and try that.

User avatar
itanic
Intermediate
Intermediate
Posts: 455
Joined: Tue Jun 15, 2004 10:05 am
Location: Oregon
Contact:

Postby itanic » Wed Jan 21, 2009 1:54 pm

""n"" did not work but 'n' did. Thanks


Return to “MLDatabase”

Who is online

Users browsing this forum: No registered users and 1 guest