on 08-12-2011 8:26 AM
I found OVS phase 2 Search too complicated to implement.
when phase 2 start, I get user input value from the structure.
But some input scenario make it difficult to search.
for example,
scenario 1), user wanna search a user by his name, but not sure of the name, so he input "*Mike".
for this, the program must check if there is a * in it, and determine whether to use 'like' in sql.
scenario 2), for a search field whose type is 'dats', and this type is not fit for "like" statment.
Thanks.
I haven't noticed that the 'like' can be used in a statement whether the value contains '%' or not.
And for the like dats problem, just forget it. In my current WD4A project, there are lots of weird requirements to realize. The clients are conservative and have no idea of ERP or SAP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
for scenario 1;
you can use "LIKE" always, simply if you read an * replace it by %. if there aren't any * you can still use "LIKE" in the select statement.
I don't understand your second scenario, why do you want to use LIKE with a DATS field ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.