pcsoft.us.windevCopyright 2026, PC SOFT29 Aug 2018 19:18:04 Z28 Dec 2009 22:15:09 ZI have a Windev project (My First) that I am trying to get the code behind a button to display info from a SQL query. My project has an analysis attached to a Microsoft Access database. There is a table named Dealers that I wish to open and loop through in the code. Here is what I have so far: i is int = 0 LocationID is string SQLText is string SQLText = "SELECT LocationID From Dealers" IF NOT SQLExec(SQLText,"QRYTest") THEN Error("Error") // Retrieve the query line by line WHILE SQLFetch("QRYTest") = 0 // There is still another line to read i++ // Retrieve the data LocationID = SQLGetCol("QRYTest", 1) Info(LocationID) END SQLClose("QRYTest") When I execute this code I get an error that says "No Current Connection" which seems to imply that I need to create a connection to the Analysis somewhere in the code. The help examples seem to imply that as long as the the table is in the Analysis attached to the project, the connection is implied. Can anyone help me out with this? Thanks....30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/23394-sqlexec-error/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Bollerpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/23394-sqlexec-error-66792/read.awp29 Aug 2018 19:18:04 ZHi, I opened a call at PCSOFT and I got this message too. -- Adriano José Boller _______________________________________…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/23394-sqlexec-error-66792/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/23394-sqlexec-error-66792/read.awpSQLExec error