pcsoft.us.windevCopyright 2026, PC SOFT12 Aug 2016 08:38:11 Z11 Aug 2016 16:57:00 ZGood morning, I'm trying to do a simple query to a MySQL DB using the SQLWDR function, so I need the query to be created in the editor, the problem is I don't know how to pass parameters to it. My query is the following: SELECT mantis_user_table.PASSWORD, mantis_user_table.id, mantis_user_table.username FROM mantis_user_table WHERE mantis_user_table.username = {username} the {username} must be a parameter entered by the user, any help? TIA30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)b.deividpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59066/read.awp12 Aug 2016 08:38:11 ZHi, you can put your query into a string variable and pass the username from a variable, e.g. MyData is data source sMyQ…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59066/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59066/read.awp[WD20] SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59065/read.awp11 Aug 2016 19:15:00 ZI managed to pass the desired parameter, but now Windev adds a letter "L" to my query where the parameter is passed, it tries to…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59065/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59065/read.awp[WD20] SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59061/read.awp11 Aug 2016 17:09:00 ZHello, I'm not sure I'm understanding can you be a little more clear please? I execute the Query like this: SQLExecWDR(QRY…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59061/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59061/read.awp[WD20] SQL codeguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59062/read.awp11 Aug 2016 17:01:00 ZHi Are you looking for QueryName.UserName=Value before the execution? Best regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59062/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59060-wd20-sql-code-59062/read.awp[WD20] SQL code