Android Question RDC Update or Insert?

[Harris]

Is it possible to write a single SQL statement that will check to see if a record exists based on some criteria (pk, fld1, fld2, fld3) and insert it if not found or update it if it does exist?

This statement will be used in the RDC config thru a batch.

Thanks

 

[Erel]

Which database are you using?

 

[Harris]

Which database are you using?

Mysql

 

[Erel]

See this: http://stackoverflow.com/questions/4205181/insert-into-a-mysql-table-or-update-if-exists

 

[Anser]

Harris,

Another option is to use a Stored Procedure.

Regards
Anser

 

[Harris]

Harris,

Another option is to use a Stored Procedure.

Regards
Anser

I would like to, but afraid I don't know how (yet).
I have mastered triggers which work well for me. In one case, I update the shiftid field in two tables with the ID of a master shift record (where the records meet the date range of the master).

I will try the REPLACE into and see how that fairs...

Thanks