svfafel
asked on
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?
UPDATE Table SET Field = True WHERE Id = 1
Any clues?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER