Neil,
Thank you very much for your compliments (but I must admit there many others with much better .NET from me here:)
I meant with free tables all you need is to have a dbc. It might be any dbc, even one that you create :
create database myDummy
Once you have it as datasource you might refer to any table in any path either within a dbc, a free table or same name table within in another dbc with the same name. Only you change the from or into part to a fully qualified name :
"Provider=VFPOLEDB.1;Data source=c:\myPath\dummy.dbc;"
Select * from ('c:\my FPW path\data\FreeTable.dbf') ...
Insert into ('c:\my FPW path\data\FreeTable.dbf') ...
This works from within .NET, ASP, ASP.NET, SQL server (ie:OpenRowSet)
I don't know why VFPOLEDB expects a DBC and if there's a way to convince it you were not using a DBC at all :)
Cetin
>Cetin,
>
>Yes. I am working from within the .net framework. C# is not my native programming language (vfp is) but I find that your examples in vfp were priceless. The info you have provided here is excellent but I must throw in a minor complication. I an working with older fpw26 *FREE* tables that hav no associated dbc. Therefore, the *STORED PROC* example will not help me send UPDATE, INSERT, or DELETE commands to the tables.
>
>Any thoughts?
>PS You have certainly provided more useful info regarding vfp as a datastore for .net than any other UT participant. Sure, everyone else give examples of SELECT statements for retrieving data but no one has provided anything for manipulating the actual data in a free table, which is acting as a datastore for an app running in the .net framework. Your contribution towards this end is be priceless and should be published as a KB article. It would be a source of info greatly needed to bring new life to older fpw26 applications. It is also necessary for those newer vfp apps that have free tables in the datastore.
>
>Thank you ever so much,
>You continue to be a much needed and appreciated source of info an inspiration,
>
>Thanx,
>DR.G (Neil)
>
< Snip ... >
