In-Database Chained Apps

[Xeu911]

Hi everyone,

I've been looking but couldn't find an answer. I'm basically trying to build a chained app (I've already done it using In Memory tools) using in DB tools.

My use case is quite simple :

1. A connect in DB tool containing a select statement in sql oracle
2. A 1st filter in DB tool on which I'm connecting the 1st text box (The user need to enter a period format YYYYMM)
3. A 2nd filter in DB tool on which there is the 2nd text box (This time the user enter a product code)

Is there any way I could build a chained app while keeping the in db tools ?

I would appreciate any help on this.

Thanks!

Clément

[apathetichell]

Clarification --- You should not be streaming out millions of records from app 1---- unless that is the choices you plan to offer in app 2 (and if that's the case --- rethink what you are doing)... I think the max file I'd use for an interface tool would be around 50K --- and that would be a Tile Tool. --- for App 2 --- it streams out whatever you need based on your filters from app 1... If this is millions --- it's millions. That's not really for us to say --- you know your data and your use case. If there are specific combos you don't want to run because of size --- don't allow them. In-DB shouldn't have a big issue with millions of rows. hundreds of millions -- yes. millions. - no. Much of this is machine/network/db specific. Off the top of my head - the largest run I'd do on 16gb of ram was 130mm (accidental) and (32gb) purposefully around 100,000,000 of royalty reporting data.