Please add update condition

Scriptcase 8 Discussion
#1

Hi, I need to do :

  1. Update primary key value.
  2. Having option how SC will update the table :
    a. Update all listed columns
    b. Update modified columns

Usually I use power builder and it provides those options, it would be great when its available in scriptcase.

#2

In Scriptcase you can’t change primary keys. If you need that you need to redesign your database a bit. I.e. by using numeric keys as primary and your ‘normal’ primary as secundairy index.

#3

I wonder why SC can’t do it, as long as database permit the operation, I wish it can be done from SC.

I plan to make web version of current running desktop solution with SC, I cant just redesign the DB as new system development cycle.

Please advice.