Devart Forums

What is the difference between Myquery1.Open and MyQuery1.Execute

Thanks.

The TMyQuery.Open method is designed for execution of an SQL statements that returns recordset. Otherwise, call to this method will return an error. TMyQuery.Execute is designed to execute any SQL statement on the server. If the executing SQL statement returns recordset, TMyQuery.Execute will open it.