john230873
Programmer
Hi I using SQL server as my back end and the BDE components
I have a master table and a child table both used for order entry eg master is the headers and secondary id the order lines
In the secondary table the link is service_number and the second field to this index is line number.
When I am not in cached mode I can insert, edit etc to the secondly table (order lines) and they all stay in the order I create them (Line Number) but when in cached mode when I insert a new line it goes to the top of the dbgrid.
How do I stop this? I know it has the right line number because I can see it.
Oh yar if I go out of the order and commit the changes then go back in they are in the right order again
Any ideas what I could be doing wrong?
I have a master table and a child table both used for order entry eg master is the headers and secondary id the order lines
In the secondary table the link is service_number and the second field to this index is line number.
When I am not in cached mode I can insert, edit etc to the secondly table (order lines) and they all stay in the order I create them (Line Number) but when in cached mode when I insert a new line it goes to the top of the dbgrid.
How do I stop this? I know it has the right line number because I can see it.
Oh yar if I go out of the order and commit the changes then go back in they are in the right order again
Any ideas what I could be doing wrong?