SQL Database Integration

Re: Using SQL statement to add up budget for depts.

Michael71 — Tue, 07 Nov 2006 16:14:46 GMT

Patrick,
What type of code will I have to enter in the OnAfterChange event handler.....I guess VBScript or VB.net.....help please

Re: Using SQL statement to add up budget for depts.

Michael71 — Tue, 07 Nov 2006 16:09:35 GMT

Patrick,

I tried a rule, but I couldn't figure it out. Could you get me started?

Re: Using SQL statement to add up budget for depts.

Michael71 — Tue, 07 Nov 2006 14:51:01 GMT

How much does the Database Accelerator Suite cost?

Re: Using SQL statement to add up budget for depts.

Patrick Halstead — Tue, 07 Nov 2006 03:58:14 GMT

Hi Michael,

You could add an OnAfterChange event handler (code) that gets called when they select the department. Or, you could add a rule that fires when a value changes and the rule could query the database based on the value. This is tricky and will require some hardcoding because the query strings don't support passing parameters.

The other possibility is to use our Database Accelerator Suite which will allow you to do this without writing any code.

Good luck!

Using SQL statement to add up budget for depts.

Michael71 — Mon, 06 Nov 2006 16:26:15 GMT

I have 6 different departments and all of them have a different department budget. I'm storing their budget information in a database. How do I query just for one department and add that department budget up when a user openings up a form. Example....

the user clicks a drop down box that says: Application Department

but I have 6 other department in the same database and their monthly budget report. How and where do I write a query statement to query just that department and sum up all of its previous budget data for that year.