Michael
|
| Posted: 06/15/2003, 1:08 AM |
|
Can you please correct my SQL statement.
This one workss ok:
SQL = "Update table Diary set DiaryText = "&"Not Approved"
but i want it to update only the diary of the person logged in, now its not working:
SQL = "Update table Diary set DiaryText = "&"Not Approved"&"where UserID = "&CCGetUserID()
Can anybody correct me please :)
|
|
|
 |
Michael
|
| Posted: 06/15/2003, 3:43 AM |
|
Ooooh my bad luck, the update only works if the value is an integer it doesnt update when the value is a text. the field type is memo, is this the problem ?
|
|
|
|
Eric
|
| Posted: 06/15/2003, 9:14 AM |
|
Database type / version?
Possible help:
display the contents of SQL
Copy the statement
execute and debug it within the utilities of your database
This will usually point to the problem such as incorrect double quotes vs single quotes
|
|
|
|
Michael
|
| Posted: 06/15/2003, 9:35 PM |
|
Thanks eric for your reply,
SQL statement (MSaccess2000):
Update Diary set DiaryText = Not Approved where UserID = 1;
this one works, but i need to have it in the after insert so i tried doing the following:
SQL = "Update table Diary set DiaryText = "&"Not Approved"
and it doesn't update the DiaryText, but it works when i change it to an integer:
SQL = "Update table Diary set DiaryText = 1"
|
|
|
|
|
