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


Am Sonntag den, 30. Dezember 2001, um 15:01, schrieb Claudius Sailer:

> 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)

Okay now I found it. ne Spaces are absolutely necessary ;-))

SQLString=UPDATE Depot SET Depot_ID = '3' WHERE RecID = '2'
SQLString=UPDATE Depot SET Depot_ID = '3' WHERE WP_ID = '2'


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