main logo
Subject: Updateing??
Author: Claudius Sailer
Posted: 2001/12/30 09:01:08
 
View Entire Thread
New Search


Hi,

I made some tests with UPDATE but I always got the same result

SQLString="UPDATE Depot SET Depot_ID='"+ContextualText(i,3)+"' WHERE
RecID='"+str(AusgewaehlteBuchung)+"'"
--> SQLString=UPDATE Depot SET Depot_ID='3' WHERE RecID='2'
count=meineDatenbank.SqlExecute(SQLString)


SQLString="UPDATE Depot SET Depot_ID='"+ContextualText(i,3)+"' WHERE
WP_ID='"+str(AusgewaehlteBuchung)+"'"
--> SQLString=UPDATE Depot SET Depot_ID='3' WHERE WP_ID='2'
count=meineDatenbank.SqlExecute(SQLString)


--> count was every time 0

But I have both records and it should normaly change something.

At first I tested it without using ' but with the same result.

Whats my fault?


Claudius
 
©2001 Claudius Sailer
<-- Prior Message New Search Next Message -->