pcsoft.us.windevCopyright 2026, PC SOFT28 Jan 2015 18:58:00 Z28 Jan 2015 13:48:00 Zrecently i received request from my customer to create a simple data entry program where where staff from remote can use. web based app is the best solution . but i didn't do that. I choose to use WD19 to write windows application using webservice to access the database. I have long read about such method and want to try in real live but it become the stupid things i ever build . what i had found from this experiment? 1. alot of coding. (good bye to screentosource() and SourcetoScreen()). if you think not big deal , try to update 40 columns. 2. the speed is very very slow . even though the database and webservice is on different machine and I using native access . so slow that the program interface already finish drawing while data still loading in behind . give you async feeling. 3. primitive functions available . retrieve data using column number rather than column name is no fun . (good bye to select * from tbl) 4. alot strange error / bugs . for example i want to assign the value to a combo control . combo_test..value = SQLGetCol("QRY1", 1) error caught by exception is SQLGetCol should return a value . but if i assign it to a variable test_id is string = SQLGetCol("QRY1", 1) combo_test..value = test_id i don't know what cause the error . i have 10 combo controls and only 2 give such error. 5. sqlconnectWS() and sqldisconnect() . should i use this everytime i want to access db or should i put this at startup/end of application . i tried put at startup of application . sometime i get error "no connection" . so i try put it in begining/end of the scope of the process. this method resolve "no connection" but the webservice getting multiple connections from one program. I endup spend 2 weeks for the program which in trial , because of slow become unusable . -.-30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50166/read.awp28 Jan 2015 18:58:00 ZHi CCC2, I use my own made webservices for 2 years. You are right, thats the future, because all traffic runs over port 80 or…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50166/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50166/read.awpAccessing a database via a Webservice Live Tryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50162/read.awp28 Jan 2015 16:35:00 ZHi ccc2, Well, this way of coding is not that great for big applications since it uses SQL. But the other way to ode using We…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50162/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50162/read.awpAccessing a database via a Webservice Live Tryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50152/read.awp28 Jan 2015 14:26:00 ZQuote Steven Sitas Hi ccc2, I haven't used web services myself, but if this is very-very slow, why don't you just open …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50152/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50152/read.awpAccessing a database via a Webservice Live Tryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50151/read.awp28 Jan 2015 13:59:00 ZHi ccc2, I haven't used web services myself, but if this is very-very slow, why don't you just open a port to your C/S HFSQL se…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50151/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50149-accessing-database-via-webservice-live-try-50151/read.awpAccessing a database via a Webservice Live Try