pcsoft.us.windevCopyright 2026, PC SOFT6 Jun 2016 22:47:00 Z5 Jun 2016 12:06:00 ZHI Can anyone help with extracting a list of the field names from a table into an array. I tried FiletoArray(), but that seems to be the contents of a field... I want to populate one table from another extracted via HExecutesqlquery. I have a number of tables to do, so want to create by code rather than the following longhand... Customers.CardIdentification = myQuery.CardIdentification Customers.Name = myQuery.Name Customers.LastName = myQuery.LastName rather do something like // Step 1 - get array of table field names myArray is array of 1 strings <?> // Step 2 - scan array and populate all the fields in the table sString is string sFile = "customers" nbDim is int nbDim = ArrayInfo(myArray, tiNumberRows) nRow is int = 1 FOR nRow = 1 TO nbDim sString = sFile + "." + myArray[nRow,1] + " = myQuery." + myArray[nRow,1] executecode(sString) hAdd... hModify... xSeek = myArray[nRow,1] end Any Help Appreciated. Thanks Mark30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file-57991/read.awp6 Jun 2016 22:47:00 ZNote about the code above. It turned out to be very slow when processing a dataFile with 71000 rows. Went from 1 minute to 3 …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file-57991/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file-57991/read.awpField names from fic fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file-57974/read.awp5 Jun 2016 22:07:00 ZThanks Mike H Just what I was looking for … Windev Rocks! Here's part of my code which does a query on a remote database and…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file-57974/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file-57974/read.awpField names from fic fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file-57973/read.awp5 Jun 2016 13:33:00 ZHi, Mark HListItem returns a character string list of items in a specified file. Item names are separated by CR It should …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file-57973/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57971-field-names-from-fic-file-57973/read.awpField names from fic file