Grid / Form link to multiple connections

Applications Grid / Reports
#1

I have 2 connections.

1st connection keep all the master information, and 2nd connection keep those generated reports bi-monthly (that means will keep increase 2 new tables every month reportyyyymmp).

Now, I’ll like to create a new grid. I read the master.period file to get the available period and choose customer from master.customer. But I’ll like to get the report from bimonthly.reportyyyymmp base on the period that I selected.

I manage to do it in Perl (cgi) but how too sure how to make this work in scriptcase.

Any comments?

Regards,
CK

#2

Re: Grid / Form link to multiple connections

There is no problem. Each application of scriptcase can have different connections.

You can have one control application connected to the master connection to read the period and ny data that you want from the master connection and you can create a grid using the detail connection …
in the sql of the grid you can do something like that:

select
fieldsthatyouwant
from table
where
periodo = ‘[var_period]’

Link the control application to the grid and pass the values that the variable need. Its independent.