MB Software Solutions General Account wrote: > Got a client who's got a Progress DB and he wants me to be able to make > changes (add/edit/delete) to it. Not structural changes...only data > changes (at least to start). > > Has anyone here ever worked with a Progress database from VFP? > > tia! > --Michael > > Yes, version 8. They are upgrading to 9 right now. In version 8 I was told there was no way to odbc (though I saw some references in google it never amounted to anything), so what we did is to send the query as an ascii file to a Progress procedure which reads it, sends the request to the engine, and puts the result in another ascii file. Sounds complicated but works ok. BTW, at least in progress 8 be careful with the indexes you have, if a certain index can be used for your query then in the where clause you should use the filters IN THE SAME ORDER as they are in the index so that the engine can optimize it. If P8 is your case (too old, probably not) then I may ask here for the procedure we use and some better advice on how to take advantage of indexes (P8 is very slow compared with MSSQLServer 2000).
Ricardo _______________________________________________ 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.
