Help with SQL

Topic

New Reply

Hi,

I am getting a few problems with write conflicts with our access front end and sql back end and the guidance is to convert the bit fields from null to ‘0’.

However I do not know how to do this within SQL server itself.

My table is ‘tblValuation’ and the field is ‘OMDone’

I try to do an update query in access, but it already recognises the fields as 0. In sql, it recognises them as null when the value is not true so will not update.

Going forward I hve now assigned a default value to new record created with this field as ‘0’

Anyone help with the SQL to run?

Reply | Quote

Replies

If you can run the query directly on the SQL Server database, the syntax would be something like this:

Code:

UPDATE tblValuation SET OMDone=0 WHERE OMDone IS NULL;

Reply | Quote

From the Access side, you might try:
Update tblValuation SET OMDone=False WHERE OMDone=False

Reply | Quote