help w/sql in macro

  • Thread starter Thread starter Daniel M
  • Start date Start date
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
 
You don't "Run" Select queries. Run is for Action queries, such as Append
and Update queries. What are you wanting to do?
 
RunSQL can only be used with action queries (append, update, etc.) and
data definition statements, not with SELECT queries.
 
Back
Top