pcsoft.us.windevCopyright 2026, PC SOFT12 Feb 2016 18:44:00 Z10 Feb 2016 01:42:00 ZI can't figure out how to reference global variables in a SQL statement. I have a table called clockinout with an int element called storenum. In the table I have many records with a storenum of 10. Using the following SQL works fine: "Select * from clockinout where clockinout.storenum = 10 " but the following does not: gnThisStoreNum=10 "Select * from clockinout where clockinout.storenum = gnThisStoreNum " Nor does this: "Select * from clockinout where clockinout.storenum = 'gnThisStoreNum' "30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56397/read.awp12 Feb 2016 18:44:00 ZYour problem is only in the generation of the select, just use: "Select * from clockinout where clockinout.storenum ="+ gnThisS…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56397/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56397/read.awpReferencing variables in a SQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56342/read.awp10 Feb 2016 14:44:00 ZFabrice 'when you change DB type, it automatically translates the sql language for the target DB' really.... Define a c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56342/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56342/read.awpReferencing variables in a SQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56341/read.awp10 Feb 2016 14:19:00 ZHi again "nice" is not why you should use it. The reasons are: - when you use it and you change the analysis, it changes the…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56341/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56341/read.awpReferencing variables in a SQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56322/read.awp10 Feb 2016 04:20:00 ZAhhh - thank you! Used to using it as a direct language. The query editor is a little cumbersome for simple sql statements, but …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56322/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56322/read.awpReferencing variables in a SQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56321/read.awp10 Feb 2016 01:51:00 ZHi Peter, 1. You should use the query editor for that, it's much simpler 2. IF you -REALLY- want to write yor own sql code…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56321/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56315-referencing-variables-sql-statement-56321/read.awpReferencing variables in a SQL statement