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

When you change the parameter, use Requery() to refresh the data, and the
call the Form.Refresh() to update controls based on the data.

As for why it isn't working, well, it's anyone's guess. It could be as
simple as the wrong SET ANSI setting to the parameter variable not being
scoped the way you think it is.

Dan

43fan wrote:
Actually... it's not finding any "new" data, that's why it doesn't
appear to be refreshing. I ran the code in the command window, and
get a 0 records selected in 0.00 seconds message. Ran it using a
literal for the vehicle, and one that I know there are records for.
I did a filter on the dbf and it finds them that way just fine.

"43fan" <sleap13@xxxxxxxxxxxx> wrote in message
news:HeKdnb8WJdzg3MfZ4p2dnA@xxxxxxxxxxxxxxxxx
Thanks. Well, I do, and I don't. For some reason, the view's not
refreshing if I change the vehicle number. Not sure why it's not
either. I'm using a memory variable to store the vehicle number,
then using that variable to do the select.

"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:eksoHL6bGHA.4040@xxxxxxxxxxxxxxxxxxxxxxx
Yep. Simple as that.

Glad you got it going!

Dan

43fan wrote:
Never mind... got it. I just use it as a table then. :)

Thanks!!

"43fan" <sleap13@xxxxxxxxxxxx> wrote in message
news:iaqdnVJFAqMqp8fZ4p2dnA@xxxxxxxxxxxxxxxxx
Ok... got that part now(I think)... but then how do I use it? Is
there a control I place on the form to use the view in? Initially
was going to use a grid box to have everything in, as I could name
the tags on the fields the way I wanted, put the fields in the
order I wanted, etc...

In the original FPD program, it just creates a window and then
does a browse within that window.

I tried using the grid box I already have on the form, but
evidently not doing something right there either, as it doesn't
show any data. But if I just run the code, then do a "use myview"
and a browse, it shows up fine.

Thanks!!

"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:%238gX7Z5bGHA.3956@xxxxxxxxxxxxxxxxxxxxxxx
You're tripping over terminology.

For years in Fox2x and prior, we called a dbf file a database. It
isn't. It's a table. A database is a collection of tables,
relations, indexes, and
views. In VFP, it's represented by a DBC and you open it with the
OPEN DATABASE command.

You're not using any of the database features in your Fox2x app
because they're not supported, but you can still use views from
VFP. They must be stored in a DBC.

CREATE DATABASE MyData
* From here on in, just
* OPEN DATABASE myData
CREATE SQL VIEW myview AS SELECT * FROM alignmentdatabase;
WHERE vehicle = ?lcVehicle
* From here on in, just
* lcVehicle = "137"
* USE myview

Dan


43fan wrote:
That's where I'm getting somewhat confused(more than somewhat
actually). Alignmentdatabase is not a VFP database. It's a free
table(FPD2.6 dbf file). I "use alignment" prior to trying the
create sql view command, and still get the same error message.
I'm not understanding now to open a DB(that I won't be using
anything from, what needs to be in it?) and also then use a free
table to get the info I need.


"JWB" <none@xxxxxxxx> wrote in message
news:WNo6g.63$WP5.36@xxxxxxxxxxxxxxxxxxxxxxxx
you have to have the DB open. I use open database and set
default.

if !dbused('MyDB')
open database (cDefdata) + 'MyDB'
endif
set database to (cDefdata) + 'MyDB'


"43fan" <sleap13@xxxxxxxxxxxx> wrote in message
news:3-ydnQR2O68wYsTZnZ2dnUVZ_vudnZ2d@xxxxxxxxxxxxxxxxx
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!


.