SBPro4
3 messages in this thread
Has anyone else found that the Filter logic on Queries is 'different' when
it comes to searching on text fields? I have managed to get around this by
always ending the test data with "*", but don't seem to have the same
flexibility as I was used to under 3.0/exit
Loren,
I'm not sure what you mean. It's been years since I played around with 3.0
and in the interim I've been using the Windows version fairly exclusively.
I do know that in the SB4W V1.3 (latest release) there was a new optimizer
built into the system for text searches and one should use LIKE and not the
= or other relative operators when searching for text. It could be that
this also got into the Amiga release.
Ciao, Neil
I found a long time ago that LIKE provides better results than ' = ' on
text, but now seem to have to always end mask with * when I didn't have to
before. Seems to bee seeing all charcters in field, even trailing blanks.
Not a big complaint in this, I was just trying to warn others that
SBPro4/Amiga is not as forgiving as 3.0 (translates: Wont let you be a
sloppy in you code)