pcsoft.us.windevCopyright 2026, PC SOFT1 Aug 2016 16:19:01 Z29 Jul 2016 18:55:04 ZHi everyone. I want to create a program that can connect to a SQLServer database, access a table and create a local copy on HFSQL. I have already written a code that works but its performance is very low, any suggestions? My actual code: [code:wl] PROCEDURE SQLtoHFSQL(cServer, cUser, cPass, cBase, cTableName) ConnectionNum is int ConnectionNum = SQLConnect(cServer, cUser, cPass, cBase,"OLEDB",hOledbSQLServer) IF ConnectionNum <> 0 THEN cQuery is string = "select * from " + cTableName IF SQLExec(cQuery, "oQry") THEN aColumnas is array of strings aCol is array of strings nCol is int = 1 // Creamos la descripcion del .Fic oFile is File Description oFile..Name = "oData" oFile..Type = hFileNormal // Describimos todos los items que contendrá el .Fic oItem is Item Description nTipo is int StringToArray(SQLColumn("oQry", True),aColumnas,CR) nColumnas is int = SQL.NbCol WHILE nCol <= nColumnas StringToArray(aColumnas[nCol],aCol,TAB) IF aCol[2] = "T" THEN nTipo = hItemText ELSE IF aCol[3] = "1" THEN nTipo = hItemBoolean ELSE nTipo = hItemNumeric END END oItem..Name = aCol[1] oItem..Type = nTipo oItem..Size = aCol[4] HDescribeItem(oFile,oItem) nCol++ END HDescribeFile(oFile) // Creamos el archivo fisico que contendrá los datos oData is Data Source HChangeName(oData,Replace(cTableName,".","_")) HCreation(oData) StringToArray(SQLColumn("oQry"),aColumnas,CR) WHILE SQLFetch("oQry") = 0 nCol = 1 WHILE nCol <= nColumnas HToItem(oData, nCol, SQLGetCol("oQry", nCol)) nCol++ END HAdd(oData) END ELSE SQLInfo("oQry") Info("SQL error: " + SQL.MesError) END SQLDisconnect() END [/code]30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58902-sql-hfsql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)HECTORpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58902-sql-hfsql-58915/read.awp1 Aug 2016 16:19:01 ZHi Fabrice. 1. I don't want to describe any file in the analysis, I want to dynamically build this files and fill them with t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58902-sql-hfsql-58915/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58902-sql-hfsql-58915/read.awpSQL to HFSQLfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58902-sql-hfsql-58911/read.awp1 Aug 2016 13:50:42 ZHi What is "very low" ? 1. YOu can create the file description in the analysis, just by conecting to your existing SQL D…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58902-sql-hfsql-58911/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58902-sql-hfsql-58911/read.awpSQL to HFSQL