Forums Home

Thread Tools Display Modes
Old 03-Mar-2014, 2:03 am   #1
FaultWire's Avatar
Join Date: Mar 2008
Posts: 14,376
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 4 pos 43: ',', ';', , ASC, COLLATE, DESC, EXCEPT, IGNORE, INTERSECT, LOCALE, NO, NULLS or UNION expected [no error code]Query:SELECT L.ClientReference, L.BasicLoan, L.OriginalDueDate, L.DateDue, L.DateLoanAgreed, L.TotalDue, L.AmountOutstanding, L.NumDays, L.WasExtended,
M.DOB, M.MonthlyTakeHomePay, M.CurrentStage FROM "Loans" L, "MainClientData" M w" (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 10:57 am.

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