DeniseGoodheart
asked on
SQL Server Syntax not fast enough for Crystal Reports .NET
Good Day:
I am using SQL Server 2000 for a VB.NET application.
The following script works great when I manually execute the first Delete Script, wait a minute and then execute the second Insert Script. If I do not wait then it reports my old data instead of the new data. In other words, SQL Server does not process the data fast enough for the Crystal Reports document. Is there a way to fix this because I need to automate the process by using a stored procedure?
---Delete Script
BEGIN TRAN
DELETE FROM PackSlip
WHERE SONumber=@SONumber
COMMIT TRAN
---Insert Script
BEGIN TRAN
INSERT INTO PackSlip
Select * from vwPackSlipCreate
WHERE SONumber=@SONumber
COMMIT TRAN
Sample Data:
PackSlip Table (Old Data)
Order #: 1234
QtyOrdered: 10
QtyShipped: 5
QtyBO: 5
PackSlip Table (New Data)
Order #: 1234
QtyOrdered: 5
QtyShipped: 5
QtyBO: 0
Any suggestions?
Thanks,
Denise
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
2000 is 10 years old vb itsel is a slow language
ASKER
mattibutt:
Yes I undestand 2000 is 10 years old but it is easier to use than 2005 and 2008 because the GUI changed. I will upgrade to SQL 2008 when we are ready to go into production. VB.NET is a slow language compared to what other lanuages?
Yes I undestand 2000 is 10 years old but it is easier to use than 2005 and 2008 because the GUI changed. I will upgrade to SQL 2008 when we are ready to go into production. VB.NET is a slow language compared to what other lanuages?
ASKER
mlmcc:
I'm using Crystal Reports.NET
I'm using Crystal Reports.NET
ASKER
Hi All,
I did a quick fix to fix this problem, but now I am getting the same problem in another stored procedure. It might be that I need to extend my connection time on VB.NET. I will try this and if it does not work, then I will post a new thread.
Thanks
I did a quick fix to fix this problem, but now I am getting the same problem in another stored procedure. It might be that I need to extend my connection time on VB.NET. I will try this and if it does not work, then I will post a new thread.
Thanks
ASKER
It did not fix the problem, but they did give me valuable information.
How are you running the report?
mlmcc