Given a flat-file: 1###A###703 2###D###203 3###E###303 4###J###901
The file is sorted by field2. Field1 (the numbers) is dependent on the "position" of the record after it's sorted by field2. Say I wanted to insert a rec. w/field2=C. I'm using AnyData, so I can use SQL commands on the file. What's the best strategy to do an insert? I could just append a record, then do a sort on field2 (eg. unix sort command), and then perl process to get field1 right. But, Is the an SQl type way? Or a cleaner way? Thanks, Lee -- http://www.fastmail.fm - Does exactly what it says on the tin
