Ok, I have another question. How would I do something like the following using the OleDbCommands in .Net:
Select * from sometable into cursor somecursor Copy to "C:\somenewtable.dbf" type fox2x Thanks, Nick Cipollina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, July 24, 2006 9:45 AM To: [EMAIL PROTECTED] Subject: RE: Multiple VFP sql statements from .NET > From: "Nick Cipollina" <[EMAIL PROTECTED]> > I am wondering if there is a way to specify multiple VFP statements in a single OleDbCommand from .NET. An example would be: > > DELETE FROM sometable WHERE something = something > PACK sometable > > Is there a way to do this without specifying more than one OleDbCommand or changing it's CommandText and execute twice? Why pack frequently? Pack is one of the hardest concepts of FP/VFP I ever had to explain to system admins. Most were use to a delete command actually removing the data, not setting a flag for the row. To answer the Q, each command must be individual in VFP. [excessive quoting removed by server] _______________________________________________ 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 ** 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.
