Hey Everyone,
What i am trying to do is insert multiple records not in alphabetical order. The problem i am having is when i insert multiple records into the table instead of inserting the records as i type them , it will insert the records into the table in alphabetical order an was wondering if there was a way to insert the records as i typed them? here is what i am using to insert. the form.serialcount keeps count of how many serials i added to insert into the table.
<!—
—>
<!—
—>
exec usp_CS_Insertserial
,
‘#Form.ID#’,
,
,
,
,
,
,
,
,
Thank you in advance,
Rach
#1 by AllenMcG at June 16th, 2009
Hey Rachel, hope all is well. What makes you think the records are NOT being inserted in the order in which you are sending them? Sorry for answering your question with one of my own, but your statement (no offense) doesn’t really make sense. If you are selecting them after insertion, is it possible you are ordering them alphabetically? The primary key should also tell you the order in which they were inserted.