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

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!






.