I do beg your pardon. I HAD created the table csrStops as permanent, as part of the soln. to my last posted problem (and there was a version left on disc), but subsequently I've commented out the code where it's created and, indeed, it's just used as and when it's created via the SQL. So the version left on disc must have been left over from then, or it's been created but failed to self-destruct when my bugs have crashed MI.
So I've now got rid of the commit and pack code and it's not a problem. Stand by for my next! -----Original Message----- From: Terry McDonnell Sent: 16 May 2005 12:46 To: Terry McDonnell Subject: RE: MI-L Why can't I pack? Hi Greg Well, yes and no. You can see the query in the included SQL. I did suspect that cursors built on the fly, via SQL, would not be packable (although Help doesn't proscribe such!). On the other hand, it IS a permanent table, as I've laid out in my final paragraph. It's supposed to be filled and emptied as required. That's why I delete and pack. Terry ________________________________ From: Driver, Greg 9434 [mailto:[EMAIL PROTECTED] Sent: 16 May 2005 12:30 To: Terry McDonnell Subject: RE: MI-L Why can't I pack? Terry, Is csrstops a query? If so then that'll be the problem. You can only pack a table, rather than a query based on the table. Greg --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16488
