pcsoft.us.windevCopyright 2026, PC SOFT30 Dec 2015 10:21:31 Z30 Dec 2015 10:21:31 ZI am trying to run this query using SQLExec : IF SQLExec("DECLARE @MYDATE AS DATETIME SET @MYDATE=GETDATE() SELECT @MYDATE", "QRY1")=0 THEN SQLInfo("QRY1") Info(SQL.Error + CR + SQL.MesError) END WHILE SQLFetch("QRY1") = 0 myDate1 is string = SQLGetCol("QRY1", 1) END SQLClose("QRY1") Is this possible ? Why am I not getting any result for myDate1 variable ? -- Ioakim Ioakimidis Senior Programmer ArtTec Ltd30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55676-sqlexec-and-declare/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)