Hi all,
I’ve started an application with 4 forms with 3 nesting levels.
I’m not sure if this is feasible or if I should take another approach.
I’ll explain with an example that’s different from the real one, but easier to understand.
Levels > 1 can accommodate multiple entries.
- General form (e.g., Shipping general data)
- Large containers (e.g., big box)
- Medium containers within the large one (box)
- Products within the medium containers (products)
One topic where I really can’t find anything practical is this:
In levels 2 and 3, I need to perform a container select that allows me to see the inserted containers and select new ones for insertion.
The problem is that they must be selected from available ones that haven’t already been sent/shipped or used previously.
Either I only see the inserted ones or those to be inserted. There’s no way to see both. Something is handled differently between insert and update in Scriptcase, so I get errors in one case or the other.
Select example
SELECT ID, code
FROM container
WHERE contType = 3
AND (
ID NOT IN (SELECT container_id3 FROM trackable_mov_container3)
OR ID = COALESCE(’{container_id3}’, 0)
)
ORDER BY code
trackable_mov_container3 → level 3 containers table already inserted…
contType = 3 → boxes…
If I remove the OR ID… I see them in insert but I don’t see “itself” in update (already inserted).
In many cases, I see that the various cascading apps get corrupted for some reason, and I’m wasting a lot of time recreating them.
Is this the recommended approach? Obviously, I try to use as little code as possible.
Thanks