pcsoft.us.windevCopyright 2026, PC SOFT7 Jul 2016 08:12:00 Z3 Jul 2016 10:49:00 ZHi, Can someone help me (step-by-step) in importing a MSSQL table that is greater than 2gb into HFSQL c/s? All attempts I've made creates a 2gb max HFSQL classic table. Then after it gets created, I change its type to client/server with the 2gb switch set to "greater than 2gb". Then a 2nd import overwrites it back to a 2gb max classic file. I've tried it every way I can think of with no success. Thanks, Stanley30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58540/read.awp7 Jul 2016 08:12:00 ZHi Arie, You have been most helpful by providing solutions. Thanks, Stanleyhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58540/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58540/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58545/read.awp7 Jul 2016 08:09:00 ZHi Arie, Quote Arie Can you give us some insights about the software you want to build? Data handling? I need to d…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58545/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58545/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58541/read.awp7 Jul 2016 08:03:00 ZHi MrBlack, Quote Mr Black 1. Import the Analysis descriptions - no data. 2. Edit the Analysis descriptions, change ty…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58541/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58541/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58539/read.awp7 Jul 2016 07:03:00 ZHi Fabrice, Quote Fabrice If you have identified a bug, contact the SUPPORT and give them the exact reproduction protocol…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58539/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58539/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58538/read.awp7 Jul 2016 06:28:00 ZDW, Quote DW Please change tools... It is apparent that you are inflexible and are unwilling to change. I probably am…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58538/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58538/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58533/read.awp6 Jul 2016 15:10:00 ZStanley, I used one of the first versions of Oracle Forms. Big company, high quality databases but after a few months we find…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58533/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58533/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58531/read.awp6 Jul 2016 13:35:00 ZStanley, Please change tools... It is apparent that you are inflexible and are unwilling to change. You criticize what you do…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58531/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58531/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58530/read.awp6 Jul 2016 13:18:00 ZHi Stanley A few things... 1. If you have identified a bug, contact the SUPPORT and give them the exact reproduction proto…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58530/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58530/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58524/read.awp6 Jul 2016 02:44:00 ZHi Arie, Thanks for the script. I agree that once you have mastered the language or have special needs, then I too create scr…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58524/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58524/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58522/read.awp5 Jul 2016 19:36:00 ZStanley, you can use HLIstFile() to retrieve all table names sDatabase is string = HListFile(cMSSQL) FOR EACH STRING sFil…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58522/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58522/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58523/read.awp5 Jul 2016 19:18:00 ZStanley, look in the Help for HDescribeFile this might get you started. DWhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58523/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58523/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58521/read.awp5 Jul 2016 18:31:00 ZHi Arie, Quote Arie You say you don't know where to start when it comes to coding? Is that because you are new to Windev …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58521/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58521/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58520/read.awp5 Jul 2016 17:07:00 ZHi Arie, Thanks for the script. I will try it and study all its contained commands and functions. Also, does this script a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58520/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58520/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58519/read.awp5 Jul 2016 16:51:00 ZHi, I still believe the import wizards should always work reliably and completely because 1. for a new customer that looki…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58519/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58519/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58516/read.awp5 Jul 2016 10:05:00 ZAh I see you are using mssql. I misread that and thought you were on mYsql cMSSQL is Connection cMSSQL..Server = "192.168.0.1"…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58516/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58516/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58515/read.awp5 Jul 2016 10:02:00 ZHi Stanley, personally I never use the build in wizards, because (as you are experiening now) they never act the way you want…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58515/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58515/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58511/read.awp5 Jul 2016 04:53:00 ZStanley. It sounds like you are almost there. You already know that if you are going to do this without code and use wizards ins…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58511/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58511/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58510/read.awp5 Jul 2016 01:03:00 ZHello Stanley HF Classic is the default file structure. HFCS is just a wrapper around a set of HF Classic files. So do the i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58510/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58510/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58509/read.awp5 Jul 2016 00:55:00 ZHi Fabrice, Quote Fabrice Import the file descriptions in your analysis (without the data) as HF classic files with more …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58509/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58509/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58501/read.awp4 Jul 2016 17:48:00 ZHi Stanley, it looks like you are talking about importing from the analysis, while Allard is talking about importing in your …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58501/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58501/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58469/read.awp3 Jul 2016 19:55:00 ZHi Allard, Quote Allard How do you manage connections? Thru WinDev's import wizard's ide. To establish the connection …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58469/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58469/read.awpImporting MSSQL to HFSQL Client/Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58467/read.awp3 Jul 2016 16:12:00 ZHi, How do you manage connections? I think you just need to connect to MSSql copy table then connect to hyperfile cs and c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58467/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58456-importing-mssql-hfsql-client-server-58467/read.awpImporting MSSQL to HFSQL Client/Server