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

I'm still confused Dan. I'm trying to use the command like the example
shows, like this.
CREATE SQL VIEW myview AS SELECT * FROM alignmentdatabase;
WHERE vehicle = "137"

I get an error message stating no database is open or no current database.



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




.

Loading