| |

VerySource

 Forgot password?
 Register
Search
View: 732|Reply: 4

A numeric field can be modified without error when added. Why?

[Copy link]

1

Threads

7

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 China

Post time: 2020-3-19 21:00:01
| Show all posts |Read mode
A numeric field is fine when added
But if that field is empty when added (allowing nulls)
Then if the modification is still empty (that is, leave it blank), an error occurs.
why?
Is this my problem
Reply

Use magic Report

1

Threads

7

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 China

 Author| Post time: 2020-6-24 20:45:01
| Show all posts
It seems that the types do not match
Reply

Use magic Report

0

Threads

93

Posts

46.00

Credits

Newbie

Rank: 1

Credits
46.00

 China

Post time: 2020-6-25 15:30:01
| Show all posts
No, the landlord will try like this
update table name
set A column = null
where column A is null
Reply

Use magic Report

1

Threads

7

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 China

 Author| Post time: 2020-7-8 11:30:01
| Show all posts
It turns out that I did not add a null value when adding
So nothing went wrong
When modifying, those numeric types can't add such empty values.
Reply

Use magic Report

0

Threads

126

Posts

73.00

Credits

Newbie

Rank: 1

Credits
73.00

 China

Post time: 2020-7-9 10:30:02
| Show all posts
Of course the number type cannot be ='' anymore
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list