Search results

Hello to everybody, Someone could justify that Progress is a HPC software ??? Thanks !!! ;)

Hi mrobles, each day you learn new things . . . It's rare, trigger above work fine on idproy field trigger (assign), but it doesn't on table's trigger (create) . . . Thanks for help :)

Hi mrobles. I agree with you, this validation must be on idproy on Proyecto table (principal table) and the validation on idproy on Usuario table (secondary table) has to be validated with CAN-FIND(proyect OF usuario) (referential itegrity), but the problem is that using the validation button...

I need to validate data-entry on field IDProy just like: alter table USUARIO add constraint CK_IDProy check (IDProy LIKE 'IC[A-I][0-9][0-9][0-9][0-9]') using Data Dictionary (Progress 9.1D). I tried Validation button with LIKE but failed . . . I don't know using format field is enough . . ...

I need to validate data-entry on field IDProy just like: alter table USUARIO add constraint CK_IDProy check (IDProy LIKE 'IC[A-I][0-9][0-9][0-9][0-9]') using Data Dictionary (Progress 9.1D). I tried Validation button with LIKE but failed . . . I don't know using format field is enough . . ...

I agree with MaximMonin, you can import data from SQL to Excel and concatenate the necessary to make the insert statement with all data imported, you have to work with the first row in excel for concatenation, for the others statements Excel automatically do it. Then use SSIS to change the...