CODEWITHSUNDEEP
sqlms-access
RTExeption
RTExeption

Reputation: 131

SQL command works only after manual change

I'm not a DB person but something weird is happening in Access:

I'm trying to run this SQL command: UPDATE tbl_DirectorySet SET TempRootDir='D'; on this table:

enter image description here

It doesn't do anything! I mean the field is empty as before.

If I manually set the field with some value like "aaaaa", then after I run the SQL command I can see that the command worked as expected.

Upvotes: 0

Views: 36

Answers (1)

Jorge Peris
Jorge Peris

Reputation: 345

If you don't have any record in a cell, the UPDATE command won't work. Use INSERT instead. That's why it works when you first introduce "aaaaa" and then you UPDATE.

EDIT: this link may make you understand better the principles behind the basic SQL commands: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete

Upvotes: 3

Related Questions