help w/sql in macro

D

Daniel M

I am trying to run a sql qry in a macro with the RUNSQL command.

I am trying to run a select command but it keeps failing. can anyone help?

SELECT serialnumber FROM devices WHERE ipaddress=ESN
 
W

Wayne Morgan

You don't "Run" Select queries. Run is for Action queries, such as Append
and Update queries. What are you wanting to do?
 
J

John Nurick

RunSQL can only be used with action queries (append, update, etc.) and
data definition statements, not with SELECT queries.
 
Top