sql query against an in memory dataset with VFP COM components

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this issue has been beaten heavily here a few times, but i was looking
for advice on a solution that i saw posted as it goes into some areas that
i'm frankly not familliar with (yet), mostly the whole VFP COM components
part.

over on http://www.kamalpatel.net/Default.htm (where i go for most of my c#
to vb.net conversions) - i saw that Kamal Patel posted an article back in
June of 2002 with what looks to me like a solution for querying an in memory
dataset using SQL (not usre yet know if its ansi 92), and his solution uses
some VFP COM components. While I'm working thru and building the sample he
provides, has anyone else seen this and tried it either with or without
success? Is this inherantly a bad idea from vb.net?

//gabe

the link to his doc explaining it,
http://www.kamalpatel.net/Downloads/Querying ADO.NET DataSets.zip
 
gabe,

I've tried this. It does require VFP and a knowledge of VFP SQL syntax
(very Access like if I recall). Each query requires the DataSet to be
converted to an XML string before Execution (which can be expensive). The
result is a DataSet.

You might be interested in the assembly I've been working on at
http://www.queryadataset.com. It lets you perform complex SQL SELECT
statements including UNION, JOINS, GROUP BY, HAVING, ORDER BY, DISTINCT,
aggregates, sub-queries, etc against the tables in a dataset. Also, it
doesn't depend on any other Microsoft or 3rd party product to be installed.

The web-site allows you to upload your own XML document or DataSet and issue
queries using the QueryADataSet assembly. If the query returns the results
you expect, then this assembly might be what you are looking for. Note the
result of any query from this assembly is a standard DataView object.

You can download a .NET 2.0 Beta 2 or .NET 1.1 beta version to try.

Hope this helps
Ad.
 
excellent, someone who has tried it. thank-you, were you using vfp 7 as in
the article or a more recent version (like 9)?
i see an aweful lot of place to start learning .net from vfp, but havent
seen any for .net to vfp. if you know of any other that the get starting vfp
doc, please lemme know.

And yeah, I'm extremly interested in the assembly you've been workiing on,..
depending on how you license it. What is the intended license for your
component, any plans of making the source available?

gabe
 
Back
Top