To All, Just came across a really neat bit of software, entirely VFP and free:
http://www.glrsoftware.com/download.asp#Query.zip It allows you to get "LinQ" type queries in VFP: "The Query utility was inspired by the .Net LINQ enhancement. Like LINQ, Query allows the developer to manipulate lists of data (Collections, Arrays, delimited strings, etc) as if they were cursors or tables, using an enhanced SQL statements. In addition to the structures just mentioned, regular cursors, tables, SQL tables, XML files or strings can also be involved. The output can also result in any of the mentioned formats. For Example: SELECT Customer.FirstName, Customer.LastName FROM TABLE Customer.dbf WHERE Customer.City in (SELECT CityCollection.City FROM COLLECTION CityCollection) ORDER BY Customer.LastName ASC INTO XML lcXMLstring.xml " The documentation is excellent and he uses the classes() to query such things as arrays, VFP Keywords, Environment variable, collections etc etc. Not only can you query, but you can insert and delete in the same manner using standard SQl syntax. All in all a very neat bit of software. Dave Crozier _______________________________________________ Post Messages to: [email protected] 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.
