> 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. _______________________________________________ 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.
