An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
SEARCH MEMO FIELD IN VFP9 SP2
Hi Experts
I would like to copy records to a file that has certain item values in a memo field using
Select * from MYtable where (memo field (mem_prod) has 20/5/2010 in it ) into a table or cursor
Thanks
I would like to copy records to a file that has certain item values in a memo field using
Select * from MYtable where (memo field (mem_prod) has 20/5/2010 in it ) into a table or cursor
Thanks
Asked:
2 Solutions
Pavel's advice is on the mark.
The only thing that I might add would be that you should possibly add other possibilities for the way a date might be entered into a Memo field.
This would only be necessary if the input were from individuals manually entering the memo field content.
But if that were the case you might also add:
SELECT * ;
FROM MYtable ;
WHERE "20/5/2010" $ mem_prod ;
OR "20/5/10" $ mem_prod
INTO TABLE NewTableName
NOTE - Perhaps you are entering your Date as DD/MM/YYYY in some manner and, if so, ignore this. But if you are using the more standardized MM/DD/YYYY, the sample you gave above for the Date searched for might need a look-over.
Good Luck
The only thing that I might add would be that you should possibly add other possibilities for the way a date might be entered into a Memo field.
This would only be necessary if the input were from individuals manually entering the memo field content.
But if that were the case you might also add:
SELECT * ;
FROM MYtable ;
WHERE "20/5/2010" $ mem_prod ;
OR "20/5/10" $ mem_prod
INTO TABLE NewTableName
NOTE - Perhaps you are entering your Date as DD/MM/YYYY in some manner and, if so, ignore this. But if you are using the more standardized MM/DD/YYYY, the sample you gave above for the Date searched for might need a look-over.
Good Luck
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
SELECT * FROM MYtable WHERE "20/5/2010" $ mem_prod INTO TABLE NewTableName
The "20/5/2010" string is tested for exact match, so it should not contain spaces or different separators.