|
Title: TCP/IP Logger and SQL Pro plugin Post by: microman3000 on September 12, 2022, 02:00:00 PM I am trying to get SQL pro plugin to check the value of a field in a MYSQL table. If the value of the field matches then update the row with the new data. If the value in the field doesn't exist then create a new row.
Basically - IF EXISTS THEN UPDATE ELSE INSERT I am tearing my hair out try to do this. Does anyone have a suggestion? Thanks. Title: Re: TCP/IP Logger and SQL Pro plugin Post by: Arthur Grasin on November 16, 2012, 08:18:11 AM You need to create a stored procedure in the database with necessary code and call it from the plugin.
Title: Re: TCP/IP Logger and SQL Pro plugin Post by: microman3000 on September 13, 2022, 02:00:00 PM Brilliant! Didn't think of that. Newbie duh!
Thanks very much |