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

You need a DBC to store the view itself, but you can use free tables in the
view with no problem.

Your description of your situation is standing on a table, waiving its arms,
and screaming PARAMETERIZED VIEWS!

You'll be surprised how much code you have to delete to make it work, too.
<g>

Dan

43fan wrote:
Dan,

This would require using VFP databases, correct? I'm using free
tables(.dbf) that are currently running in a FPD2.6 environment.

Shawn


"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:uqEeeftbGHA.3872@xxxxxxxxxxxxxxxxxxxxxxx
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!


.