Forums Home

Thread Tools Display Modes
Old 03-Mar-2014, 6:56 am   #1
FaultWire's Avatar
Join Date: Mar 2008
Posts: 14,396
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 execution failed:
("I" at line 2, pos 59) [no error code]Query:SELECT L.ClientReference, SUM(I.Incomeamount) AS Income, M.MonthlyTakeHomePay,
M.DOB, M.CurrentStage FROM "Loans" L, "MainClientData" M, I."FFIncomeData" where M.ClientReference=L.ClientReference and
I.FactFindID=M.CurrentFFID and
L.OriginalDueDate between date'2014-02-01' and date'2014-02-28' and not L.IsReloan and not L." (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 9:47 am.

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