pcsoft.us.windevCopyright 2026, PC SOFT1 Apr 2018 22:09:00 Z16 Mar 2018 22:22:00 ZBeen presented with an situation. thanks to help on this forum i have overcome saving an image to my android database. however in one of the last phases of my app development, i have been presented an issue. reading on the doc.windev.com site, in the sqlexec section, ther is a line that expresses to me to use WDBinaryMemo in my sql query if im connecting to a webservice. im not sure if im using it right, or if the data extracted from the hfsql binfile. my sql string is sBinTest1 is string = "INSERT INTO BinFile(bin_data) VALUES = {WDBinaryMemo('Temp.jpg')}30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65111/read.awp1 Apr 2018 22:09:00 ZHi Elisha, I'm not sure how to answer that one... I, personally, do not use MSSQL... Some of my customers are using MSSQL…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65111/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65111/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65085/read.awp1 Apr 2018 00:12:00 ZThank you, i will be sure to look at your link. may i inquire, are you using MSSQL?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65085/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65085/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65083/read.awp31 Mar 2018 22:53:00 ZHi Elisha I'm using my OWN rest webservice (a simple webdev awp page), and because I'm coding both sides, I can do whatever I…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65083/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65083/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65078/read.awp30 Mar 2018 22:43:00 ZAnymore thoughts on this? Better question from me, what methods outside this are you all using for similar purposes?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65078/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65078/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65020/read.awp22 Mar 2018 22:20:00 Zi followed your advice, i commented out the sqlexec line. along with the following code with the exception of the sqldisconnect …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65020/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65020/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65014/read.awp22 Mar 2018 14:47:00 Zhmmm.... try to comment out the sqlexec part and check if trying to open the image on the phone still gives you the error... …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65014/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65014/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65012/read.awp22 Mar 2018 01:58:00 ZOops, thank you Fabrice, i overlooked that. Arie, i tried that, but it was not working, as there were syntax errors from the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65012/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65012/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65003/read.awp21 Mar 2018 16:10:00 ZHi It seems that there is a syntax error in the SQL statement... According to this page: https://www.w3schools.com/sql/sql_i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65003/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-65003/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64999/read.awp21 Mar 2018 14:56:00 ZElisha, maybe you can save the image to the server by doing a regular insert, if as it were text. Like any other text-value,…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64999/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64999/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64998/read.awp20 Mar 2018 22:03:00 Zi have done a fFileExist check and it returns true. plus i have a basic image control that loads the extracted memo file. and it…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64998/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64998/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64986/read.awp20 Mar 2018 12:14:00 ZGood point. BinFile seems to be used as a reference to a local and remote database at the same time?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64986/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64986/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64981/read.awp20 Mar 2018 12:03:00 ZHi something else I don't understand You are doing a query called QRY_BinTest1 However, you are NOT reading the resulting…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64981/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64981/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64985/read.awp20 Mar 2018 11:34:00 ZWell then I'm stuck too, I wonder if this 'feature' is working in the first place. To get more info you can have a look in th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64985/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64985/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64979/read.awp20 Mar 2018 11:05:00 ZYes, i should have it there, i copied a query i was making in SSMS and it did not need the field there. i did add it in after…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64979/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64979/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64978/read.awp20 Mar 2018 11:01:00 ZI never used the webservice so I can only guess what's wrong. But shouldn't there be a fieldname in the insert-statement? "i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64978/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64978/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64984/read.awp20 Mar 2018 10:42:00 ZI did enter the fFileExist check, it returned true but browsing to it in the file explorer of my phone showed the "0" size place…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64984/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64984/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64977/read.awp20 Mar 2018 09:00:00 ZHi Elisha, can you add an extra check, just to be sure the HExtractMemo did a proper job and check if the file is actually th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64977/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64977/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64975/read.awp19 Mar 2018 23:09:00 ZThank you for pointing out my flaws in code. i have been reading the help on the website and i do see my errors now. the last 2 …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64975/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64975/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64971/read.awp19 Mar 2018 11:53:00 ZFrom the top of my head : 1. You are doing a fextractresource of '/temp.jpg" (instead of 'temp.jpg' into an empty destination…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64971/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64971/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64968/read.awp18 Mar 2018 22:32:00 ZThank you for clarifying. i assumed with my topic header with the "WM21" i was expressing that i am using Windev Mobile 21. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64968/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64968/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64967/read.awp18 Mar 2018 11:52:00 ZHi again >>>i really want to learn where im failing, what information am i not telling? You are not showing us your code …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64967/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64967/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64966/read.awp17 Mar 2018 21:31:00 ZQuote you are getting a JAVA error... this means that you are executing this code in a Java environment, most probably Androi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64966/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64966/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64965/read.awp17 Mar 2018 10:58:00 ZHi Elisha, you are getting a JAVA error... this means that you are executing this code in a Java environment, most probably A…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64965/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64965/read.awpWM21 - Binary Memo to SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64964/read.awp17 Mar 2018 06:01:00 ZWell, here is an update. an error presented using the above information. error in Left-Clicking WIN_Action_Tracker..BTN_Sync_…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64964/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64961-wm21-binary-memo-sql-server-64964/read.awpWM21 - Binary Memo to SQL Server