Use data from a memo field for SQL expression(s) 1

[Millard]

I would like the user to enter expression(s) criteria into a
memo field for SQL retreival. Can this be done with the STRTRAN() OR EVALUATE() function?

 

[foxdev]

You might explore using the VFP Application Object's DOCMD method. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[jimstarr]

Assuming that the memo field contains a valid FoxPro command, a simple method would be:

char1 = alltrim(memofield)
&char1

Jim

 

[weedz]

EVALUATE() only 'evaluates' an expression, it does not execute a command.

I also use contructions like Jim's. For most cases it is the easiest way.

HTH,
Weedz (Wietze Veld)
veld4663@exact.nl

They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best.

After the GoldRush - Steve McConnell