pcsoft.us.windevCopyright 2026, PC SOFT31 Oct 2014 16:34:00 Z31 Oct 2014 09:02:00 ZHi, my WD14 project runs fine but needs an update to WD19. Thats the time to redesign the architecture. In WD14 I use a direct connection with HFSQL over the Internet and at the server side runs a program which checks every 30 seconds if something happens. One of these things is receiving (and unzipping) ZIP-Files. I want change the architecture to webservice + stored procedures at server side (to avoid starting a special program) , but I don´t know how to implement the zip and unzip because its not allowed in SP. One idea was to creating a windows service but I don´t want split the functionality in too many pieces ... any ideas ?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48740/read.awp31 Oct 2014 16:34:00 ZHi Arie, ok, it looks like I have to explore another (dark) site of the PC Soft WLanguage jungle :-)https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48740/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48740/read.awp[WD19] Zip in Stored Proceduresguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48739/read.awp31 Oct 2014 16:17:00 ZHi Michael, just study the WDService example. It is quite complete and shows you how things work. (found a bug almost immedi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48739/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48739/read.awp[WD19] Zip in Stored Proceduresguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48738/read.awp31 Oct 2014 14:28:00 ZHi Arie, yes that could be possible. But whats about error handling in a service ? If something went wrong can I see a error …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48738/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48738/read.awp[WD19] Zip in Stored Proceduresguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48737/read.awp31 Oct 2014 14:20:00 ZMichael, if 'starting a special program' is an issue, you could also wrap your existing code in a service. Then it will run in…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48737/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48737/read.awp[WD19] Zip in Stored Proceduresguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48736/read.awp31 Oct 2014 14:16:00 ZHi Derek, > I do not see how you would call a webservice method from a stored procedure. according to the help it should b…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48736/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48736/read.awp[WD19] Zip in Stored Proceduresguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48735/read.awp31 Oct 2014 14:06:00 ZMichael I do not see how you would call a webservice method from a stored procedure. Can you not set up an 'Automatic Timer'…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48735/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48735/read.awp[WD19] Zip in Stored Proceduresguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48733/read.awp31 Oct 2014 12:34:00 ZH Derek, mmh, that means that is a synchron handling. Thats not good if the zip file is 2 GB with hundrets of files, because …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48733/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48733/read.awp[WD19] Zip in Stored Proceduresguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48731/read.awp31 Oct 2014 12:24:00 ZMichael You should be able to serialize the zip file into a buffer and send from the web service. On receipt deserialise a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48731/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48720-wd19-zip-stored-procedures-48731/read.awp[WD19] Zip in Stored Procedures