?? about sequences and 'Order By' clause on forms

[Quoted] Hi. Thanks for reading this.

I have a ?? about using sequences. I have a seq declared, and I want to use it to auto. update the CR_NUMBER field on a "6i" form. Currently the 'Select' statement is on a Pre Insert trigger on the data block. Somehow, the sequence is getting bumped when it is not supposed to. I want the seq. to get bumped ONLY when the user commits the record. Most of the time it works ok on the Pre Insert trigger, but now and then it bumps the sequence by several numbers instead of only 1.

Any ideas? Is there a better trigger to use for this?

Next question is about the 'Order by' clause on the data block properties. I do an 'Ececute Query' on form startup in order to get the records from the table into the form so you can look at them. I want them to come in sorted by CR_NUMBER.
I put "order by cr_number" on the Orber By clause property for the block, but this does not work.

How do you order records when you bring up a form?

Thanks for any advise,
Richard Hollingsworth Received on Thu Nov 09 2000 - 17:16:43 CET