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
---
_______________________________________________
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.
