pcsoft.us.windevCopyright 2026, PC SOFT31 Oct 2017 12:55:46 Z29 Oct 2017 12:49:33 ZI have a query that selects ALL the fields in a database file, like SELECT * FROM DBfile WHERE ... I use the records in the query to fill the fields in a window. If I modify a (query)field, is there any way to write the modified record back to the datafile whitout having to manually pair each queryfield with the corresponding databasefield? Insted of ... DBfile.field1 = QRY.field1 DBfile.field2 = QRY.field2 DBfile.field3 = QRY.field3 HModify(DBfile) I am looking for something like DBfile.Record = QRY.Record HModify(DBfile) Best regards, Carl30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63135-pairing-query-fields-and-database-fields/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)carl.bergmanpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63135-pairing-query-fields-and-database-fields-63172/read.awp31 Oct 2017 12:55:46 ZHi Fabrice, thanks, I tested it and it works. :)https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63135-pairing-query-fields-and-database-fields-63172/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63135-pairing-query-fields-and-database-fields-63172/read.awpPairing query fields and database fieldsfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63135-pairing-query-fields-and-database-fields-63158/read.awp30 Oct 2017 12:30:18 ZHello Carl, 1. your query has to have the MODIFY option set 2. Your query has to wrok on only one file 3. You fields must b…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63135-pairing-query-fields-and-database-fields-63158/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63135-pairing-query-fields-and-database-fields-63158/read.awpPairing query fields and database fields