pcsoft.us.windevCopyright 2026, PC SOFT28 Apr 2018 20:53:00 Z11 Apr 2018 01:51:00 ZHi All I have a real brain fart moment here. I know I have done this before but cannot locate the code. I am needing to return a value from an SQL statement, for example, count or max and so on. What is the syntax and how to use in WX? Cheers André30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65336/read.awp28 Apr 2018 20:53:00 Z//Look up the record with the Matricule no ( place key on this ) If hreadseekfirst(file,fileID,Matricule no) then tablemodifyl…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65336/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65336/read.awpSQL Syntax - Returning A Valueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65327/read.awp27 Apr 2018 13:43:00 ZUse querieshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65327/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65327/read.awpSQL Syntax - Returning A Valueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65252/read.awp17 Apr 2018 16:42:00 ZSorry for . I have re-posted on a new thread.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65252/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65252/read.awpSQL Syntax - Returning A Valueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65250/read.awp17 Apr 2018 16:16:00 ZWhy didn't you start a new thread?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65250/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65250/read.awpSQL Syntax - Returning A Valueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65249/read.awp17 Apr 2018 15:13:00 ZGreetings All I have difficulties in handling a task in Windev Browsing Table Control. Now, i am trying to build a small appli…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65249/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-browsing-table-control-65249/read.awpSQL Syntax - Returning A Valueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value-65204/read.awp12 Apr 2018 22:24:00 ZSorted - select max from table AS variable That did the trick Cheers Andréhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value-65204/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value-65204/read.awpSQL Syntax - Returning A Valueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value-65183/read.awp11 Apr 2018 10:44:00 Zuse something like: QRY is Data Source sMyQry is string = [ SELECT count(*) total_records FROM your_file ] IF NOT HExecuteS…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value-65183/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value-65183/read.awpSQL Syntax - Returning A Valueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value-65182/read.awp11 Apr 2018 10:39:00 ZTry SELECT... https://help.windev.com/en-US/?2034001&name=SQL_statementshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value-65182/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65178-sql-syntax-returning-value-65182/read.awpSQL Syntax - Returning A Value