I removed all of the double quotes from the query you list below and
replaced the "?" with the start and end date of the query. It then ran
properly. I'm not sure what is causing the other errors, but it's the quotes
and the variables that are screwing you up in ISQL_w.
Sheryl D. Stover - sds@iea-software.com - http://www.iea-software.com
IEA Software Account Management and Customer Service
Phone: (509) 444-2455 ext. 51 - Fax: (509) 624-9903
Billing and Customer Care for ISPs and Communications Companies
-----Original Message-----
From: Alan D. Criado <ACriado@elink.net>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Monday, February 22, 1999 1:53 PM
Subject: RE: [Emerald] Labels & Reports
:
:
:Hello Dale.
:
:I'm running Emerald 2.5.22.
:
:Whenever I try to run the SERV-REV.RPT report, I get an SQL error:
:
:ODBS error: [Microsoft][ODBC SQL Server Driver][SQL Server]The number '0.'
:is out of the range for numeric representation [max precision:33].
:
:If I just try to run the SQL Query of that report:
:
:SELECT
: Invoices."Type", Invoices."Date",
: InvoiceItems."Login", InvoiceItems."Description",
:InvoiceItems."Amount", InvoiceItems."Tax", InvoiceItems."Quantity",
:InvoiceItems."Tax2"
:FROM
: { oj "Emerald"."dbo"."Invoices" Invoices INNER JOIN
:"Emerald"."dbo"."InvoiceItems" InvoiceItems ON
: Invoices."InvoiceID" = InvoiceItems."InvoiceID"}
:WHERE
: Invoices."Type" <> 'VOID' AND
: Invoices."Date" >= ? AND
: Invoices."Date" <= ? AND
: InvoiceItems."Amount" > 0.
:ORDER BY
: InvoiceItems."Description" ASC
:
:I get the following error message as the results:
:
:Msg 170, Level 15, State 1
:Line 2: Incorrect syntax near 'Type'.
:Msg 1007, Level 15, State 1
:The number '0.' is out of the range for numeric representation (max
:precision: 33).
:
:
:Do you have any idea what could be wrong and how to correct this?
:
:Thank you for your assistance.
:
:Alan D. Criado
:
:For more information about this list, including removal,
:please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html