Hi Mike, I think you got your answer from Theirry? Don't use the DBF function in your ALTER TABLE statement when you're working with a cursor.
ACTIVATE SCREEN CLEAR CREATE CURSOR test (test1 c(10)) DISPLAY STRUCTURE ALTER TABLE test ADD COLUMN test2 c(20) DISPLAY STRUCTURE ALTER TABLE test Alter COLUMN test1 n(8) DISPLAY STRUCTURE USE IN SELECT([test]) -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Thursday, July 11, 2013 1:23 PM To: [email protected] Subject: Re: Why can't I ALTER TABLE on a cursor? It's not a table, it's a cursor created via CREATE CURSOR CRAP: CREATE CURSOR crap (provnum c(9), datepaid c(8), lastdos c(8), reimbamt n(15,2), bonusamt n(15,2), datepaid2 d, lastdos2 d, filename v(200), tstamp t) I guess I could just make it an actual DBF file and be done with it, but that doesn't answer my original question. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD0442284263994@ACKBWDDQH1.artfact.local ** 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.
