How can I run a view using a variable

[Gerben]

Hello,

I got the next problem:
My father-in-law adviced me to leave the old foxpro behind and to switch over to Visual Foxpro, I'm getting used to the differences but there are things I can't work out like:
I ask for an input let's say typehere results in 2565
than I like to run a view with the result of typehere,
typehere has been set to public and is still active in the new window, but when I ask the view to show the result nothing shows up.
What am I doing wrong?


Gerben

 

[RoadRunnerOz]

I think I know what you're askin'..

This is what shows in the View Designer :

Field Name Criteria Example
table.field = ?m.typehere

View SQL:

SELECT *;
FROM yourdatabase!table;
WHERE table.field= ?m.typehere Michael Ouellette
mouellette@compuserve.com