I am in the process of converting to PostgreSQL. I would like to do everything
I need using my existing DBC/DBF files first to be
sure I have all the data access separated from the user interface and also get
some experience. This is a very old application
dating back to 1977 using Basic Plus on DEC computers, converted to Fox dos
then VFP with more than 1 million lines of code so it
will take some time. Mainly I am just playing around trying to decide how I
want to do it.
My code is using ole db and recordsets. I should have put more code: (think I
figured out how to browse using some code on
foxite.com) vfp has really incredible resources available. I hope python is
that good when I finally get everything converted in
about 4 - 6 years. I hope there are other people on this list going through a
similar conversion. Foxite has more examples than you
have time to review.
* my code below. This does work and is a good start for accessing anything in
the dbc
loCN = Createobject("ADODB.Connection")
loRS = Createobject([ADODB.RecordSet])
loCN.ConnectionString = "provider=vfpoledb.1;data
source=U:\ssi\304901\Share\ptshare.dbc"
loCN.Open
If loCN.State = 1 && If Connection is fine, create RecordSet
loRS.ActiveConnection = loCN
loRS.CursorType = 1 && adOpenKeySet
loRS.LockType = 3 && adLockOptimistic
loRS.Open("Select * From m6nmpt")
?loRS.RecordCount && Display Number of Records
loRS.MoveFirst && Start At the Top of the File
Do While Not loRS.Eof
? "******************** new record"
For lnI = 1 To loRS.Fields.Count
If lnI = 1
? loRS.Fields(lnI-1).Value
Else
? loRS.Fields(lnI-1).Value
Endif
Endfor
loRS.MoveNext()
Enddo
Endif
----- Original Message -----
From: "Stephen Russell" <[EMAIL PROTECTED]>
To: "ProFox Email List" <profox@leafe.com>
Sent: Friday, April 04, 2008 12:55 PM
Subject: Re: SQL Passthrough and ODBC
On Fri, Apr 4, 2008 at 2:48 PM, kam <[EMAIL PROTECTED]> wrote:
> Can you show me the code to browse a specific table (or select * from
> MyTable)
>
> OConn is an object with properties so the code below seems to work. In
> this dbc there is a table named m6nmpt.dbf and a view to
> look at all the data named vnmpt (the view has the same data you would
> get from select * from m6nmpt). Even better, is there a
> reference for working with oledb in vfp9 sp2? the Microsoft site has a
> lot of information, but it is very superficial and never
> (at least I can't find it) shows the code for accessing/updating data.
>
>
> OConn = CREATEOBJECT("ADODB.Connection")
> OConn.ConnectionString = "provider=vfpoledb.1;data
> source=U:\ssi\304901\Share\ptshare.dbc"
> OConn.Open
>
>
----------------------------------------------------------------------------
Are you in VFP and using ODBC for a dbf? Why?
Why not open database U:\ssi\304901\Share\ptshare.dbc
Then do the Select from there?
No if your in VB, Delphi etc then you need that oldeb functionality.
--
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN
901.246-0159
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
