gate_hongs46
New Member
Greetings.
im trying to make a dynamic where for searching data.
Can i code like this:
def var fieldv as char.
fieldv = browse-name:CURRENT-COLUMN:name.
{find-data.i
&TABLE = "customer"
&FIELD = fieldv
&SEARCH = f-search:SCREEN-VALUE}
find-data.i:
FIND FIRST {&TABLE} WHERE {&FIELD} BEGINS {&SEARCH} NO-LOCK NO-ERROR.
if avail {&TABLE} then reposition browse-name to recid recid({&TABLE}) no-error.
it seems to be not working.
anything wrong with my coding.
need help. thx.
im trying to make a dynamic where for searching data.
Can i code like this:
def var fieldv as char.
fieldv = browse-name:CURRENT-COLUMN:name.
{find-data.i
&TABLE = "customer"
&FIELD = fieldv
&SEARCH = f-search:SCREEN-VALUE}
find-data.i:
FIND FIRST {&TABLE} WHERE {&FIELD} BEGINS {&SEARCH} NO-LOCK NO-ERROR.
if avail {&TABLE} then reposition browse-name to recid recid({&TABLE}) no-error.
it seems to be not working.
anything wrong with my coding.
need help. thx.