Need some help with Visual Foxpro

I was wondering if anyone could help me out with this...

How do you create a shortcut directly to a form inside a database??.....any input would be much appreciated.

Siddharth

What version of VFP? Is this Version 5 or greater or before 5? I only have experience with VFP 5 and above. What are you trying to do exactly?

Are you trying to store a menu in a database?

You could store a code block which calls the form in a field and then call an Evaluate on it or use macro substitution:

Say you you have a form call you have stored in a string variable called menuitem from you extracted from an array you filed from a select from a table:

Here is the syntax for the DO FORM command:

DO FORM FormName | ? [NAME VarName [LINKED]] [WITH cParameterList]

[TO VarName] [NOREAD] [NOSHOW]

call the form with DO FORM by replacing the stuff after the FORM keyword with the menuitem string like this

eg.

DO FORM &menuitem.

The syntax for macro substitution is & followed by the variable then the . symbol.

But if possible, use EVALUATE because it is faster:

Here is a link to Evaluate

http://msdn.microsoft.com/library/default....aluatelp_rp.asp

For evaluate, you could store the entire call to the form including the Do FORM in the table field and then read it into the string and call it like so:

EVALUATE(menuitem)

I cannot get more specific because I want to keep my job. If you have any more Question RTFM.

#4159