Re: Grids... simple, but I don't know...

See the help topic "Limiting the Scope of a View", and everything related to
CREATE SQL VIEW.

Dan


43fan wrote:
Thanks Dan, I'll check out the alias possibility. Um...
parameterized view?

"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:ewKP5ksbGHA.4372@xxxxxxxxxxxxxxxxxxxxxxx
1. Sounds like you've got the grid bound to the wrong alias. If it
isn't bound, it'll use whatever alias is currently selected.

2. Don't use filters with grids prior to VFP9. Ever. Put one hand on
the desk and slap it with the other. <g> This situation is
absolutely perfect for a parameterized view.

Dan

43fan wrote:
VFP 8. Have a grid that's populated from a table(free table).
Initial form asks for user to input a vehicle number, then it does a
seek in the vehicle db and displays description, etc. User can then
click a button to display alignment data for this vehicle. I have
the dbf open in the data environment, and have a filter set to
filter the records to the vehicle number the user entered. When I
click on the button and pull up the form with the grid on it, I get
a list of records, all for that particular vehicle, but, I'm
getting just a list of multiple records that are exactly the same.
For the one vehicle I'm using to test this with, I should have
approx. 10 records, all different of course. That's not what I'm
seeing though, I'm seeing about 30 records, all exactly the same.

Any help? I'm sure it's something simple, but I'm very
inexperienced with VFP.

Thanks!


.