Skip to Content
Former Member
Jul 15, 2008 at 01:11 PM

Rare DI-server ExecuteSQL bug


I have written a wrapper that gives me the ReturnValue of an ExecuteSQL command to the DI server. When I supply SQL which contains a field that contains 'from', I don't get the expected SQL:

SELECT ItemCode, CardCode, LINENUM, Price, Currency, Discount, ListNum,

FromDate, ToDate, AutoUpdt, Expand FROM SPP1 WHERE ItemCode = 'A00001'

AND FromDate < GetDate() AND ToDate > GetDate() - 1

When I run this through the DI server, I receive this XML:

<?xml version="1.0"?>">







< Date >














</ Date >






I expected the highlighted tag 'Date' to be SPP1, since that is the table I queried and common convention. In stead, it seemed to look for the nearest FROM and got the next alphanumeric bit. It should look for ' FROM '. I'm now looking for a work-around, but I thought I'd share this with you, guys.


Edited by: Vincent van Tongeren on Jul 15, 2008 3:15 PM