Help-
How can I make sure the '%' appears in my sql statement when using the
following in Fetch Specification qualifier in EOModeler: (bookName like
$bName)
This sql statement is then generated when "THE FIRM" is entered ---v
SELECT t0.AUTHOR_ID, t0.BOOK_ID, t0.BOOK_NAME FROM BOOK t0 WHERE
UPPER(t0.BOOK_NAME) like :BOOK_NAME0 ESCAPE '\'" withBindings:{BOOK_NAME0 =
"THE FIRM";
which returns 0 rows.
the correct sql should have included the % after THE FIRM like this "THE
FIRM%"
Where did the '%' go? Should that be generated automatically?
Thank You All ...
<WO 4.0, NT4.0, Oracle 8>
