Using HXTT DBF Driver; Getting Lexical Errors...
Using HXTT DBF Driver; Getting Lexical Errors...
- Subject: Using HXTT DBF Driver; Getting Lexical Errors...
- From: Clint Fleetwood <email@hidden>
- Date: Fri, 11 Feb 2005 10:47:53 -0500
I'm using the HXTT DBF Driver (com.hxtt.sql.dbf.DBFDriver) to access
DBF's. First of all, anybody familiar with this driver and any
particulars about it ? It seems that it doesn't like to be queried upon
with a manually created Fetch Specification due to the SQL that EOF
generates for it. It complains about a Lexical Error....Anybody dealt
with this before. It doesn't error out if I do a wide open fetch but of
course that's not very useful. Here's the Fetch Spec that I'm using:
// Creating the Fetch Spec here
NSArray bindings = new NSArray (new Object[] {colorName, deptCode,
pattName, vendCode});
EOQualifier qualifier =
EOQualifier.qualifierWithQualifierFormat("colorname like %@ and
deptcode like %@ and pattname like %@ and vendcode like %@" ,
bindings);
EOFetchSpecification fetchSpecTest = new
EOFetchSpecification("Invmstr", qualifier, null);
EOEditingContext myEC = this.session().defaultEditingContext();
NSArray test = new NSArray();
test = myEC.objectsWithFetchSpecification(fetchSpecTest);
AND HERE'S THE SQL EXCEPTION THAT I GET:
EvaluateExpression failed: <com.webobjects.jdbcadaptor.JDBCExpression:
"SELECT t0.COLORNAME, t0.DEPTCODE, t0.PATTNAME, t0.VENDCODE FROM
INVMSTR t0 WHERE (t0.COLORNAME like ? ESCAPE '\' AND t0.DEPTCODE like ?
ESCAPE '\' AND t0.PATTNAME like ? ESCAPE '\' AND t0.VENDCODE like ?
ESCAPE '\')" withBindings: 1:"l"(colorname), 2:"vv%"(deptcode),
3:"%"(pattname), 4:"%"(vendcode)>: Next exception:SQL State:42000 --
error code: 270336 -- msg: Lexical error: ')
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden