----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: chandramukhi_mug Message 1 in Discussion Hi All, I am back with yet another serious prblem Very strange. It's in my accounting Apps. In voucher entry option, let's say user has entered about 100 records The same are accepted in a temporary table. At the end, when user presses OK and if the total debit / credit tallies, the same is updated to my SQL server 7 database in a table call TRXN table. Before update, I issue a BEGIN TRANS commnad and at the end after all 100 records are updated I issue COMMIT TRANS command. While this voucher is being updated, If the user takes any report (Using CRYSTAL REPORT VER 8.5) it print transaction which are updated IN THE trxn table at that point in time. So the whole system goes for a toss, as the complete voucher is not yet FULLY updated in the TRXN table. To SUm up, even though I have used BEGIN TRANS and COMMIT TRANS , the transaction are available to another user before COMMIT TRANS is issued. (If I END in between, all the transactions are rolled back as such, which is as expected). One more, If I issue any SQL query (usign ISQL) while the transactions are being updated, the ISQL throws time out error. I do this by HALTING the execution of VB program in debug mode. In crystal report, We connect to the database using ODBC connection string. In the DSN which I have created, I select driver as SQL SERVER. And than I select the server name which I want to connect to. I use SQL Server authentication. Than I change the default database to my application database. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
