pcsoft.us.windevCopyright 2026, PC SOFT17 Jan 2020 15:37:37 Z16 Jan 2020 09:51:55 Zhello everybody please consider the sql code below, use on a "simple" HF table [code:sql] CREATE TABLE Shoes_Temp AS SELECT Shoes_Tag.Data AS Data, Shoes_Tag.Numero AS Numero, Shoes_Tag.Fornitore AS Fornitore, Shoes_Tag.Brand AS Brand, Shoes_Tag.FTY AS FTY, Shoes_Tag.TFS AS TFS, Shoes_Tag.Esito AS Esito, Shoes_Tag.Full AS FULL, Shoes_Tag.Minor AS Minor, Shoes_Tag.Sostituiti AS Sostituiti, Shoes_Tag.Riparati AS Riparati, Shoes_Tag."Non Conformi" AS Non_Conformi, Shoes_Tag."Da Sostituire" AS Da_Sostituire, Shoes_Tag."Da Riparare" AS Da_Riparare, Shoes_Tag."Non Conformi1" AS Non_Conformi1, Shoes_Tag.Note AS Note, Shoes_Tag.TFS1 AS TFS1, Shoes_Tag.FTY1 AS FTY1, Shoes_Tag.Filename AS Filename, Shoes_Tag."Num# Foto" AS "Num#_Foto" FROM Shoes_Tag WHERE LEFT (Shoes_Tag.Numero, 6) = ParamNumero ORDER BY Numero DESC [/code] the idea is to create a phisical copy of some data present in the "main" table but I get errors when I try to pass the parameter I would like to use something like [code:wl] HExecuteQuery(QRY_NoName_AQL_Shoes_Boss1, hQueryDefault, "123456") [/code] but if you have other ideas, you're welcome (I would like, also, use a sql sintax like "SELECT … INTO TABLE …" but I can't find this type of syntax thank you very much30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67579-wd24-sql-how-create-temporary-table/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)paopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67579-wd24-sql-how-create-temporary-table-67588/read.awp17 Jan 2020 15:37:37 ZDid you try something like this: my_sql is string=[ CREATE TABLE Shoes_Temp AS SELECT Shoes_Tag.Data AS Data, Shoes_Tag.Num…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67579-wd24-sql-how-create-temporary-table-67588/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67579-wd24-sql-how-create-temporary-table-67588/read.awp[WD24] SQL: how to create a temporary table?