General information
Category:
Visual FoxPro Beta
While using the View Designer, I select the new "Like" option on the filter tab and set the text to 'Unrepaired%' ... I was expecting that this action would show all of the records that started with the word 'Unrepaired' however, the data set comes up blank. I then selected 'View SQL' and saw that the SQL statement had used the '=' sign instead of the word 'LIKE' so I replaced the equal sign with the word 'LIKE' in the SQL statement and re-ran the query from the SQL page using the run (!) button. When I did this, I git the result data set that I expect. However, whenever I exit the SQL statement the "LIKE" is always replaced with the '=' sign and then I get the an empty result set when run from the main View Designer screen using the same run(!) button. FYI ... "Like" still shows up on the View Designer grid eventhough the text in the SQL statement keeps switching back to and equal sign.
I know that in native FoxPro that a single '=' sign works similar the SQL 'LIKE' keyword and that the double '==' will locate only an exact match. So, I wasn't that surpised when I saw the 'LIKE' selection translated to the single equal sign but its just not giving me the correct answer. But, forcing the work 'LIKE' into the SQL statement works like a champ!
Any ideas?
Thanks,Robert
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only