Print Page - TCP/IP Logger and SQL Pro plugin

Title: TCP/IP Logger and SQL Pro plugin
Post by: microman3000 on September 12, 2022, 11:00:00 AM

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, 05: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, 11:00:00 AM

Brilliant! Didn't think of that. Newbie duh!

Thanks very much

AGG Software Forums

Online Help Center => Data loggers and plug-ins => Topic started by: microman3000 on September 12, 2022, 11:00:00 AM