TCP/IP Logger and SQL Pro plugin

[microman3000]

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.

[Arthur Grasin]

You need to create a stored procedure in the database with necessary code and call it from the plugin.

[microman3000]

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

Thanks very much