Vilmar Brazăo de Oliveira wrote:It always helps to tell us what kind of database you are using.> Good morning,
> How insert null in numerics fields?
> I can't insert 0()zero and nor other number, because any positive
> number can be a possible code to my system.
> I tried FieldX = Null, but I could not get sucess executing SQL.
Does the field/column accept Nulls, i.e., is it a Required field?
If it accepts Nulls, then usually you can simply exclude the field from the
columns list in the Insert clause in the SQL statement.
Altenatively, you can simply do this by using the Null keyword ... oh! I see
you have tried this. What happens when you do it? Error messages? If so,
what error message? Show us the code you tried
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.