Source language: Translate to:

Syntax Error!

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Syntax Error!

Postby TonyL » Fri Feb 15, 2008 10:05 am

I keep getting this error: "Syntax Error [missing operator] in query" using the following piece of code:

dbpQuery "Writing Planner" "Entries" "Start Time = [#34]1:00 am[#34]"

Probably something simply stupid I am overlooking. But I'm having a major brain fart trying to get this little piece of code to work.

Thanks,
Tony
TonyL
 
Posts: 40
Joined: Mon Sep 19, 2005 7:20 pm

Postby Gaev » Fri Feb 15, 2008 10:33 am

Tony:

a) Is your field named "Start Time" ? ... helps not to have spaces in field names ... also "Time" is a reserved word ... so using it as a field name will confuse the command parser

b) Your Database ID also appears to contain a space
User avatar
Gaev
 
Posts: 3738
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Postby TonyL » Fri Feb 15, 2008 10:45 am

Thanks Gaev.

I knew it was something simple. [/quote]
TonyL
 
Posts: 40
Joined: Mon Sep 19, 2005 7:20 pm


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest

cron