pcsoft.us.windevCopyright 2026, PC SOFT13 Mar 2018 10:23:00 Z12 Mar 2018 17:49:00 ZDear All, I have struggled with a challenge for while and thought I will share it here for help. I have the code below; I want to create a temporary table in MySQL and insert records into it to speed up a process that is running slow updating directly on disk. =========Code============== ShtTable is string="MF" indb is string="INFILE" SQL1, SQL2 are Data Source sQuery is string="create temporary table "+ShtTable +" ("+... "`country` varchar(10) NOT NULL,"+... "`towncode` varchar(10) default NULL,"+... "`townaddress` varchar(20) default NULL,"+... "`townDigiLoc` varchar(20) default NULL'" IF NOT HExecuteSQLQuery(SQL1 , mainConnect, hQueryDefault+hQueryWithoutCorrection, sQuery ) THEN Error(HErrorInfo(hErrFullDetails)) RETURN END sQuery2="insert into "+ShtTable+"select * from "+indb IF NOT HExecuteSQLQuery(SQL2, mainConnect, hQueryDefault+hQueryWithoutCorrection, sQuery2) THEN Error(HErrorInfo(hErrFullDetails)) RETURN END ===The above works without error but when I try to display contents of SQL2 as below, I get an error that SQL2 is not initialized. BuildBrowsingTable(TABLE2, SQL2, taItemCaption+taFillTable) I will appreciate any help to get over this since I really need to reduce the processing speed. I could also do with another method than this approach. Sam30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table-64929/read.awp13 Mar 2018 10:23:00 ZThanks for the comments and lead. sQuery2 is defined before usage so it works well. Moreover I have used this mode of access …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table-64929/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table-64929/read.awpWD21: How to Create & Update MySQL Tempoary Tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table-64927/read.awp13 Mar 2018 06:12:00 Ztry to put create and insert in one sqlhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table-64927/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table-64927/read.awpWD21: How to Create & Update MySQL Tempoary Tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table-64923/read.awp13 Mar 2018 02:22:00 ZHi Sam, Are you sure your code works... i.e. where is your sQuery2 variable created? Is this all your code or are you tryi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table-64923/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64917-wd21-how-create-amp-update-mysql-tempoary-table-64923/read.awpWD21: How to Create & Update MySQL Tempoary Table