execute("SELECT * FROM OPENQUERY(TESTSERVER,"" SELECT * FROM TEST.XYZ.POLICY
"") ")

How can I do an insert? The above select works.

Tried the below:

execute("SELECT * FROM OPENQUERY(TESTSERVER,"" Insert into TEST.XYZ.POLICY
(testcolumn) values (1) "") 
")


Thanks,
Nathan Stanford
Senior Programmer/Analyst
[EMAIL PROTECTED]



-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com

-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org

Reply via email to