BBritain
VIP Member
Hi Gurus,
I know I've done this before (maybe 7.x) but can't seem to figure it out again. I have a field where I want to search a table (via Table I/O) for "IL-K*" where the asterisk is any of several characters. I know that in the Select I can set the compare to a "Like" (the cross between and equals and a simile) but can't seem to find the code that fetches any records.
I can see matching records in UTB, and can see in debug that the Select function has "is Like" between the left and right operands but always get SV File_IO_Status = ERROR on the Fetch.Next command.
***Note to web master **** I also tried searching for "Like" but you consider it too common of a word to search on.
Can anyone help?
Ben again,
I know I've done this before (maybe 7.x) but can't seem to figure it out again. I have a field where I want to search a table (via Table I/O) for "IL-K*" where the asterisk is any of several characters. I know that in the Select I can set the compare to a "Like" (the cross between and equals and a simile) but can't seem to find the code that fetches any records.
I can see matching records in UTB, and can see in debug that the Select function has "is Like" between the left and right operands but always get SV File_IO_Status = ERROR on the Fetch.Next command.
***Note to web master **** I also tried searching for "Like" but you consider it too common of a word to search on.
Can anyone help?
Ben again,