Joy Conner
29th May 2008, 17:45
Has anyone ever used a domain in a table that is a SET Data type? I have done this and generated a maintain session on the table and I'm having difficulty inputting a record.
shah_bs
30th May 2008, 16:36
I have not used it personally in my own programming, but I was searching for an example that might help you:
Take a look at the session tppdm6100m000 - Maintain Projects. On Form 8 (this is for the A&D version of the session - maybe the form [ and even the field name] is different in your version of BAAN), there is a field called Relevant Billing Cycles. This is a 'set' type of field and I had no problem saving the record after making a test change to the field.
For example, I could change the value to "Cyle1 / Cycle2" and save it (old value was Cycle1).
zardoz
2nd June 2008, 13:04
In bw, you can select multiple values of a set by clicking on it and pressing <ctrl> key in the same moment.
Personally, I dont like this kind of control, if the possible values arent so many I prefer to substitute it with a list of tcyesno variables.
Hitesh Shah
2nd June 2008, 15:24
In bw, you can select multiple values of a set by clicking on it and pressing <ctrl> key in the same moment.
Personally, I dont like this kind of control, if the possible values arent so many I prefer to substitute it with a list of tcyesno variables.
In Baan set data type is used in SMI module , authorizations , audit management . The set data type is stored as long value in the table. U can only use long value of the same in select statement.
I have used the same with bit.and / bit.or functions in allowing user multiple period types / multiple hierarchies which can reduce complex codes to few lines .