Forums Home

Thread Tools Display Modes
Old 25-Feb-2014, 1:08 am   #1
FaultWire's Avatar
Join Date: Mar 2008
Posts: 14,365
Invalid ODBC Error - ODBC Error -1: "The query returned an error (ODBC ...

Dialog text:
ODBC Error -1: "The query returned an error (ODBC State: HY000)Error:NexusDB: : Query preparation failed:
Syntax error at line 1 pos 97: '-', '%', %%, '(', '*', ',', '.', '/', ||, '+', '', =, AND, AS, BETWEEN, FROM, IN, INTO, IS, LIKE, MATCH, NOT or OR expected [no error code]Query:SELECT LoanID, ClientReference, DateLoanAgreed, LoanAmount AS AppliedFor, LoanAmount, NumDays WHERE
DateLoanAgreed BETWEEN Date'2012" (HY000)

Issued by: ODBCView Application

Jump to the FaultWire page for Solutions and Fixes for this topic...

FaultWire is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -7. This page opened at 1:56 am.

  Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd.