>>The version of Btrieve that I'm working with as a back end to my VFP front end doesn't support JOINs according to it's help file. How could I accomplish the following without using a JOIN?
>>
>>SELECT TableA.Field1 + TableB.Field2 FROM TableA JOIN TableB ON TableA.Field1 = TableB.Field3
>
>What are you using to access btrieve data? How much is it and where do I get it?

Evan

I'm working against two existing accounting applications (one called Platinum, and the other called Magic), both using Btrieve data, that use a product called Pervasive.SQL from Pervasive Software Inc. I believe that Pervasive "bought" Btrieve and are now the only suppliers, but I'm not sure on this one.

This has been installed on each of the users' machines (and now on mine as well). I'm not sure exactly how extensive this particular package is, but it includes at least an ODBC driver for Btrieve, and as I understand it, the Btrieve database engine itself. I don't know if just the ODBC driver can be purchased separately.

Sorry, I don't have any cost info, but their web site is http://www.pervasive.com

I've done all my reporting using just VFP's built in report writer, feeding it cursors that I have built using sqlconnect() and sqlexec()

Bob