database dip

How are database tables updated using dip in stratergy? I mean is thru procedures or is another way to update?

Thanks

best way is to use SP in your DB directly, faster and safer.

1 Like

I strongly suggest using a stored procedure to do this, especially if you are running Oracle.
When it comes to quick and dirty updates, URS’s update is more than enough; however, when it involves multiple records in several tables, stored procedure would be able to do it much faster, more reliably, and more importantly, you will have a much better ability for error-handling.

If you are just updating value A in Table B, then URS update functionality should suffice.

Vic

1 Like