Dear All,
I have 2 application is one windows application and a windows service which will update query on a remote server. My problem here is that I notice that the transaction of my windows service is running the query which are not even part of the program and which are part of my windows application. Based on the log file first in my windows application the query 90have successfully with out any problem. Then again in query no 95 again all the all the sql statement is being repeated why did this happened? What did this happened?

081015 18:10:02 92 Quit
93 Connect root@localhost on mpcms5
93 Query SHOW VARIABLES
93 Query SHOW COLLATION
93 Query SET character_set_results=NULL
93 Init DB mpcms5
93 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceipt'
93 Quit
90 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceipt'
081015 18:10:07 90 Query Insert into tblReceipt Set receiptID=908, outletID=5, employeeID=24, customerName='Cash', customerPhone='', totalCostAmount=218.82, totalSellingAmount=360, totalProfitAmount=141.18, changeAmount=0, profit='y', receiptDate = '2008:10:15', receiptTime = '18:10:07'
081015 18:10:08 90 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'
90 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'
081015 18:10:09 90 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=409
081015 18:10:10 90 Query Insert into tblReceiptDetails Set receiptID=908, receiptDetailsID = 1528, outletID = 5,stockID = 1261, productID= 409, productType = 'Imei', productQuantity = 1 , productSIQ = '357850003139364', costPrice = 218.82, sellingPrice = 360, profitAmount = 141.18, profit = 'y'
081015 18:10:12 90 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -218.82 Where tblProduct.productID=409
081015 18:10:13 90 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=409
081015 18:10:16 90 Query Select tblID.lastValue From tblID Where tblID.tableName='tblPaymentDetails'
90 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblPaymentDetails'
081015 18:10:17 90 Query Insert into tblPaymentDetails Set paymentDetailsID=914, outletID = 5,receiptID = 908, paymentTypeID= 1, amount = 360
081015 18:10:19 90 Query Delete From tblTempReceipt
90 Query COMMIT
081015 18:13:17 90 Quit
081015 18:13:53 94 Connect root@localhost on mpcms5
94 Query SHOW VARIABLES
94 Query SHOW COLLATION
94 Query SET character_set_results=NULL
94 Init DB mpcms5
94 Query Select productCode, productID From tblProduct Where productStatus='y' And productType='Accessory' Order By productID
94 Quit
081015 18:14:41 95 Connect root@localhost on mpcms5
95 Query SHOW VARIABLES
95 Query SHOW COLLATION
95 Query SET character_set_results=NULL
95 Init DB mpcms5
95 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
95 Query BEGIN
96 Connect root@localhost on mpcms5
96 Query SHOW VARIABLES
96 Query SHOW COLLATION
96 Query SET character_set_results=NULL
96 Init DB mpcms5
96 Query Select tblUpdateCentralcopy.updateCentralCopyID From tblUpdateCentralCopy
081015 18:14:47 96 Quit
97 Connect root@localhost on mpcms5
97 Query SHOW VARIABLES
97 Query SHOW COLLATION
97 Query SET character_set_results=NULL
97 Init DB mpcms5
97 Query Select tblUpdateCentral.updateCentralID From tblUpdateCentral
081015 18:14:49 97 Quit
98 Connect root@localhost on mpcms5
98 Query SHOW VARIABLES
98 Query SHOW COLLATION
98 Query SET character_set_results=NULL
98 Init DB mpcms5
98 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceipt'
98 Quit
95 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceipt'
95 Query Insert into tblReceipt Set receiptID=909, outletID=5, employeeID=24, customerName='Cash', customerPhone='', totalCostAmount=218.82, totalSellingAmount=360, totalProfitAmount=141.18, changeAmount=0, profit='y', receiptDate = '2008:10:15', receiptTime = '18:14:49'
081015 18:14:50 95 Query Select tblID.lastValue From tblID Where tblID.tableName='tblReceiptDetails'
95 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblReceiptDetails'
95 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=409
95 Query Insert into tblReceiptDetails Set receiptID=909, receiptDetailsID = 1529, outletID = 5,stockID = 1261, productID= 409, productType = 'Imei', productQuantity = 1 , productSIQ = '357850003139364', costPrice = 218.82, sellingPrice = 360, profitAmount = 141.18, profit = 'y'
95 Query Update tblProduct Set tblProduct.productTotalStock = tblProduct.productTotalStock -1, tblProduct.productTotalAmount = tblProduct.productTotalAmount -218.82 Where tblProduct.productID=409
95 Query Select tblProduct.productTotalStock, tblProduct.productTotalAmount From tblProduct Where tblProduct.productID=409
95 Query Select tblID.lastValue From tblID Where tblID.tableName='tblPaymentDetails'
95 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblPaymentDetails'
95 Query Insert into tblPaymentDetails Set paymentDetailsID=915, outletID = 5,receiptID = 909, paymentTypeID= 1, amount = 360
95 Query Delete From tblTempReceipt
95 Query COMMIT
95 Quit