pcsoft.us.windevCopyright 2026, PC SOFT28 Aug 2015 16:24:00 Z27 Aug 2015 18:42:00 ZHello, Is it possible to change the record numbers in a database file? It is a table with invoice lines and i need a function to change the order of lines. It is a table with direct acces. Thanks!30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53722/read.awp28 Aug 2015 16:24:00 ZSammy Depends whether you need a permanent or temporary change to the order. If permanent then does as already suggested wit…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53722/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53722/read.awpChange record number in databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53721/read.awp28 Aug 2015 15:16:00 ZSammy If it is a temp file then just load the contents to a memory table control recording the current desired positions in a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53721/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53721/read.awpChange record number in databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53720/read.awp28 Aug 2015 15:02:00 ZI also use a process similar to what Markus mentioned. I just have a field on OrderLine called "Sequence" so that when you bring…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53720/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53720/read.awpChange record number in databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53718/read.awp28 Aug 2015 14:53:00 ZHi again personnaly, for all sort orders, I use a high precision numeric.. This allows me to add after or before a line by…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53718/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53718/read.awpChange record number in databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53716/read.awp28 Aug 2015 14:08:00 ZHi Sammy, for the orderlines i use an own field which holds an index: If you add the first orderline it gets value 1, second …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53716/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53716/read.awpChange record number in databaseCCordespcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53714/read.awp28 Aug 2015 13:40:40 ZUsually an invoice line item record will have the Id of the parent invoice, and a auto-incremented id for the line itself, You …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53714/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53714/read.awpChange record number in databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53715/read.awp28 Aug 2015 13:38:00 ZIt is a temp file that i use. What is then the best way to move the order of the lines?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53715/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53715/read.awpChange record number in databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53712/read.awp28 Aug 2015 11:52:00 ZHi Sammy I see First I have to say that I would NOT use automatic identifier as line numbers for invoices, but I would hav…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53712/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53712/read.awpChange record number in databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53711/read.awp28 Aug 2015 10:36:00 ZFabrice, First thanks for your reply! It is a data file with automatic rec numbers.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53711/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53711/read.awpChange record number in databaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53702/read.awp27 Aug 2015 19:38:00 ZHi Sammy What are your record numbers? Automatic IDs? Something else? When you are saying "it is a table...", are you talkin…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53702/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53697-change-record-number-database-53702/read.awpChange record number in database