Hi.
Quote:
"update [SIM-TAB] set UPDATE-FLAG=false, UPDATE-DT= '10/09/2007
4:09:59 PM' WHERE ICCID='I1' "
1.) The dash sign means "subtract the value on the right from the value on
the left." As written, your query is attempting to subtract the value of
FLAG from the value of UPDATE and then subtract the value of DT from the
value of UPDATE. There is no UPDATE column, nor FLAG column, nor DT column.
Also, the above syntax assigning values to an expression just won't work.
2.) UPDATE is a Reserved word, and Reserved words should not be used to
name columns (or any other identifier for that matter), because Jet may use
the Reserved word for its intented purpose, not the use you want to assign
to it.
3.) A date data type must be bracketed by the pound sign, #, both before
and after the date in Jet SQL. For example:
UPDATE MyTable
SET MyDate = #10/09/2007 4:09:59 PM#
WHERE MyDept = 'Accounting';
It's important to use US format dates (mm/dd/yyyy) in Jet queries.
Therefore, the above date is 9 Oct. 2007, not 10 Sept. 2007.
4.) One may either change the names of columns so that Reserved words
aren't used and illegal characters aren't used (only use alphanumeric
characters and the underscore character), or one may put brackets around the
names of the bad column names, but the latter method isn't guaranteed to
work, so it's best to avoid the problems in the first place by using
acceptable names for all identifiers.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs:
www.DataDevilDog.BlogSpot.com,
www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
