When attempting to insert mulitple lines into a new invoice using the FQSaveToCache my invoice lines are inserted out of sequence when using items and ItemGroups. No matter what the items go first and then all the group items.
For example:
Psuedo Code:
insert into InvoiceLine GroupItem1 with FQSaveToCache = 1
insert into InvoiceLine GroupItem2 with FQSaveToCache = 1
insert into InvoiceLine tem1 with FQSaveToCache = 1
insert into InvoiceLine Item2 with FQSaveToCache = 0
This should insert two group items first and then two Items. However when I run a select query on the recently created invoiceLine I see the follwing results.
Item1, InvoiceLineSeqNo =1
Item2, InvoiceLineSeqNo =2
GroupItem1, InvoiceLineSeqNo = 3
GroupItem2, InvoiceLineSeqNo = 4
Essentially, what I'm saying is that no matter what order I insert GroupItems in, they always come out last in the invoice. It seems like the QODBC inserts all Items first and then Inserts GroupItems.
|