February 11, 2009 at 1:49 pm
Hi All!
I have a visual foxpro 9 application that uses SQL Server 2000 as a backend. The application communicates using SQL pass through.
I have a new problem, something we have never noticed before. All of a sudden, I have a situation where the app is sending INSERTs and UPDATE, the server is not reporting an error yet the data changes never happen. I can see the statements coming through on SQL Profiler but it tells me that there are zero writes for the statement.
It gets a little better, here. This is not 100% consistent. They can enter the same transaction multiple times and it won't work x times but at x+1 it will write. Obviously, the code being executed at the client is exactly the same.
The client OS is win2000 Pro and the SQL Server os in win2000 Server.
Any ideas?
Menachem Bazian, CPA
President
February 11, 2009 at 9:20 pm
So you see what you expect in Profiler, but no changes in SQL? Open transaction? Explicit transactions set?
February 12, 2009 at 9:32 am
Pretty much. No transactions or anything funny. I just to a sqlconnect in VFP and then a SQL Exec with the insert statement. Nothing fancy beyond that. The only thing I do NOT see in profiler that I would expect to see is that there were writes...
Oh, and I checked the version of the server... it's base SP4 -- version 8 build 2039...
February 13, 2009 at 9:41 am
One reason why an INSERT or UPDATE does nothing without reporting an error is a WHERE clause that evaluates as false the conditions under which the staement should apply. It is possible that a parameter or a value is null for instance.
If you want to go anywhere further with this, the forum members could be of assistance if you posted:
1. The table creation script
2. Data insertion script
3. The SQL statement which does not appear to work reliably.
February 13, 2009 at 2:29 pm
check for triggers. You might have something failiing a validation somewhere and getting rolled back.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply