Re: update table with the word Null

Bob,
I used your suggestion and still get type mismatch.
UPDATE projects
SET floorplan = "Null"
WHERE floorplan = ""
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'UPDATE'

Joe T


Use the Access Query Builder to generate sql statements until you are
comfortable writing them yourself

Joe T wrote:

UPDATE Projects (floorplan)
SET floorplan = 'Null'
WHERE floorplan = ''''

I tested and receive:
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'projects'
Any one know why I receive error?

Yes. It's because the syntax is incorrect. Assuming the name of the
table is "Projects", the correct syntax is:

UPDATE Projects
SET floorplan = 'Null'
WHERE floorplan = ''''



--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.