Seek w/ ODBC

Last month, I received some GREAT help on this forum on
ways to use VFP and update Clipper NTX files using ODBC
and SQL pass through functions for updates and appends
(using my Merant ODBC driver).

Is there a way to "SEEK" into those Clipper files while in
VFP-8 using my ODBC driver and those same Clipper NTX-
style index files?

For example: Seek a certain date and loop through the DBF
file while that date is the same, totaling other field
info along the way (such as extended price).

I'm sure there will be more clarification requested of me
along the way. I just want to get the ball rolling here.

Tom

Anders
Wed Sep 24 05:25:55 CDT 2003

Tom,
The way to do it is with a remote parameterized view. You might want to make
it updatable too. Use trhe View Designer Criteria tab to set updatability
conditions.

OPEN DATABASE x
CREATE CONNECTION y
CREATE VIEW v_pdxdates REMOTE CONNECTION y AS SELECT col1, col2, date, col5
;
FROM Pdxtable ;
WHERE date BETWEEN ?ldDate1 AND ldDate2
ldDate1=DATE(2003,4,1)
ldDate2=DATE(2003,4,30)
USE v_pdxdates
ldDate1=DATE(2003,5,1)
ldDate2=DATE(2003,5,31)
REQEURY('v_pdxdates')

-Anders

"Tom" <tbacon@calicocorners.com> wrote in message
news:006201c37c67$6f8be260$a301280a@phx.gbl...
> Last month, I received some GREAT help on this forum on
> ways to use VFP and update Clipper NTX files using ODBC
> and SQL pass through functions for updates and appends
> (using my Merant ODBC driver).
>
> Is there a way to "SEEK" into those Clipper files while in
> VFP-8 using my ODBC driver and those same Clipper NTX-
> style index files?
>
> For example: Seek a certain date and loop through the DBF
> file while that date is the same, totaling other field
> info along the way (such as extended price).
>
> I'm sure there will be more clarification requested of me
> along the way. I just want to get the ball rolling here.
>
> Tom
>