You say that there is more than one procedure to do this process, gathering
the data and then updating ?
Is it not possible to do the whole process in one stored procedure ?


At 10:26 04/12/2003 +0200, you wrote:

> >
> >Now if understood correctly the slow part is the FIRST part where the data
> >is saved
> >and then gathering of sales data and then updating the sales data that was
> >inserted ?
> >
> >Sorry for my ignorance :).
>
>Nope - that's cool - it's not easy to explain an app over email. :-D
>
>The slow part is the SECOND part - where the gathering of the sale data,
>updating the financial transaction in the DB, and inserting the amount
>tendered as a financial transaction in the DB. These last two things -
>updating and inserting the amount tendered - occur in ONE database
>transaction.
>
>All of this is controlled from the client - although the update and inserts
>are stored procedures which are called by the client.
>
>Thanks
>
>Tim
>
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003


[Non-text portions of this message have been removed]