Access to SQL7 and update query

I have just moved an Access97 database to a SQL7 database and am testing my queries.  My update queries are failing because of the Boolean updates.  When i analyze it on the SQL server, it doesn't seem to be able to interpret the TRUE and FALSE expressions.  It fails on a statement liek this:  
UPDATE Table SET Field = True WHERE Id = 1

Any clues?
Who is Participating?
Renato102098Connect With a Mentor Commented:
In SQL70 do not recognize true or false
True = 1 and False = 0
Your sentence must be:
UPDATE Table SET Field = 1 WHERE Id = 1

svfafelAuthor Commented:
sorry for the delay...had a baby boy (#2)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.