www.usoft.com To www.usoft.com

Topics started by bert.wilms

2 Topics

B
bert.wilms
asked in Share your best practices

Best Practices for Navigating from Overview to Detail Windows

I have a data block that displays records from a specific table. Can anyone tell me how to navigate from this summary window to a more detailed information window where data can be changed?To clarify, I have a sensor summary IW window and want to move from this window to a sensor edit IW window, passing as a parameter the Pk of the current record so that the selected record can be edited.We DO NOT have a USOFT web application. 

1
R
1 day ago
B
bert.wilms
asked in Share your best practices

Adding a default record when a another record is inserted

Anyone here who can show me the right direction to achieve the following ? I try to explain it clearly.  Table Aircraft_types has the columns pattern_id, aircraft_id, version_nr, aircraft_class )When someone insert a new record in this table Aircraft_types, a default record need to be inserted into the same Aircraft_types table. it's important that this new record has the same value for Aircraft_id and pattern_id. the aircraft_class need to be retrieved from the column Classid from the aircraft_pattern based on the new pattern_idand it's also important that the default record doesn't need to be created when there is already a record where pattern_id and aircraft_id are identical.So for examplesomene enters the recordpattern_id = BE9M and aircraft_id = P47.The default record that has to be created ispattern_id  = BE9M aircraft_id = BE9Maircraft_class = must contain the value of this select : select aircraft_class from aircraft_patterns where pattern_id = 'BE9M' I've tried a constraint a

1
R
29 days ago

Badge winners

Show all badges
Terms & ConditionsCookie settings