How insert null in numerics fields?

[Vilmar Brazão de Oliveira]

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.

thanks,

--

««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC

[Bob Barrows]

Vilmar Brazão de Oliveira wrote:

> 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.
>
> thanks,

It always helps to tell us what kind of database you are using.

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


Bob Barrows
--
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.

[Vilmar Brazão de Oliveira]

hi,
my database is sql server 2000.
field:
1 AgCodEmpresa float 8 1(it accepts null)
instruction sql:
SQLNotificacao = "Insert into
Agenda_Condominios(AgDtHora,AgSeq,AgEmpresa,AgBloc o,AgApto,AgDepartamento,Ag
Descricao,AgSolucionado,Ag3Dias,Ag2Dias,Ag1Dia,AgE mail,AgEmailsCopia,AgCodEm
presa,AgNome,AgCodCliente) values ('" _
& AgDtHora & "'," & AgSeq & "," & AgEmpresa & ",'" & AgBloco & "','" &
AgApto & "'," & AgDepartamento & ",'" & AgDescricao & "','" & AgSolucionado
& "','" & Ag3Dias & "','" & Ag2Dias & "','" & Ag1Dia & "','" & AgEmail _
& "','" & AgEmailsCopia & "'," & AgCodEmpresa & ",'" & AgNome & "'," &
Session("SiCod") & ")"

I wouldn´t like to use an conditional IF to check if I have to put the
numbers fields in select or not.
thanks your hope,

--

««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> escreveu na mensagem
news:#drqGxe1DHA.3824@TK2MSFTNGP11.phx.gbl...

> Vilmar Brazão de Oliveira wrote:

> > 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.
> >
> > thanks,

>
> It always helps to tell us what kind of database you are using.
>
> 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
>
>
> Bob Barrows
> --
> 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.
>
>

[Bob Barrows]

Vilmar Brazão de Oliveira wrote:

> hi,
> my database is sql server 2000.
> field:
> 1 AgCodEmpresa float 8 1(it accepts null)
> instruction sql:
> SQLNotificacao = "Insert into
>

Agenda_Condominios(AgDtHora,AgSeq,AgEmpresa,AgBloc o,AgApto,AgDepartamento,Ag

>

Descricao,AgSolucionado,Ag3Dias,Ag2Dias,Ag1Dia,AgE mail,AgEmailsCopia,AgCodEm

> presa,AgNome,AgCodCliente) values ('" _
> & AgDtHora & "'," & AgSeq & "," & AgEmpresa & ",'" & AgBloco &
> "','" & AgApto & "'," & AgDepartamento & ",'" & AgDescricao & "','" &
> AgSolucionado & "','" & Ag3Dias & "','" & Ag2Dias & "','" & Ag1Dia &
> "','" & AgEmail _ & "','" & AgEmailsCopia & "'," & AgCodEmpresa &
> ",'" & AgNome & "'," & Session("SiCod") & ")"
>
> I wouldn´t like to use an conditional IF to check if I have to put
> the numbers fields in select or not.

What does Response.Write SQLNotificacao show?

Have you tried this:
If len(AgCodEmpresa) = 0 then AgCodEmpresa = "Null"

Bob Barrows

--
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.

[Mark Schupp]

use a function to format your values:


Function SQLFloat( nIn )

SQLFloat= "null"

If Not IsNull( nIn ) Then
If IsNumeric(nIn) Then
SQLFloat = CStr(nIn) ' might want to use FormatNumber here
End If
End If

End Function

Then build your SQL with the function

....
"','" & AgEmail _ & "','" & AgEmailsCopia & "'," & SQLFloat(AgCodEmpresa)
&
....

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:eVUf1Bf1DHA.2528@TK2MSFTNGP10.phx.gbl...

> Vilmar Brazão de Oliveira wrote:

> > hi,
> > my database is sql server 2000.
> > field:
> > 1 AgCodEmpresa float 8 1(it accepts null)
> > instruction sql:
> > SQLNotificacao = "Insert into
> >

>

Agenda_Condominios(AgDtHora,AgSeq,AgEmpresa,AgBloc o,AgApto,AgDepartamento,Ag

> >

>

Descricao,AgSolucionado,Ag3Dias,Ag2Dias,Ag1Dia,AgE mail,AgEmailsCopia,AgCodEm

> > presa,AgNome,AgCodCliente) values ('" _
> > & AgDtHora & "'," & AgSeq & "," & AgEmpresa & ",'" & AgBloco &
> > "','" & AgApto & "'," & AgDepartamento & ",'" & AgDescricao & "','" &
> > AgSolucionado & "','" & Ag3Dias & "','" & Ag2Dias & "','" & Ag1Dia &
> > "','" & AgEmail _ & "','" & AgEmailsCopia & "'," & AgCodEmpresa &
> > ",'" & AgNome & "'," & Session("SiCod") & ")"
> >
> > I wouldn´t like to use an conditional IF to check if I have to put
> > the numbers fields in select or not.

>
> What does Response.Write SQLNotificacao show?
>
> Have you tried this:
> If len(AgCodEmpresa) = 0 then AgCodEmpresa = "Null"
>
> Bob Barrows
>
> --
> 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.
>
>

[Vilmar Brazão de Oliveira]

HI Bob and every body else,
this kind of things runs marvellous OK!
If len(AgCodEmpresa) = 0 then AgCodEmpresa = "Null"
OR
If AgCodEmpresa = "" then AgCodEmpresa = "Null"

I had forgot the ""(quotation marks)!!
thanks,

--

««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC
"Bob Barrows" <reb01501@NOyahoo.SPAMcom> escreveu na mensagem
news:eVUf1Bf1DHA.2528@TK2MSFTNGP10.phx.gbl...

> Vilmar Brazão de Oliveira wrote:

> > hi,
> > my database is sql server 2000.
> > field:
> > 1 AgCodEmpresa float 8 1(it accepts null)
> > instruction sql:
> > SQLNotificacao = "Insert into
> >

>

Agenda_Condominios(AgDtHora,AgSeq,AgEmpresa,AgBloc o,AgApto,AgDepartamento,Ag

> >

>

Descricao,AgSolucionado,Ag3Dias,Ag2Dias,Ag1Dia,AgE mail,AgEmailsCopia,AgCodEm

> > presa,AgNome,AgCodCliente) values ('" _
> > & AgDtHora & "'," & AgSeq & "," & AgEmpresa & ",'" & AgBloco &
> > "','" & AgApto & "'," & AgDepartamento & ",'" & AgDescricao & "','" &
> > AgSolucionado & "','" & Ag3Dias & "','" & Ag2Dias & "','" & Ag1Dia &
> > "','" & AgEmail _ & "','" & AgEmailsCopia & "'," & AgCodEmpresa &
> > ",'" & AgNome & "'," & Session("SiCod") & ")"
> >
> > I wouldn´t like to use an conditional IF to check if I have to put
> > the numbers fields in select or not.

>
> What does Response.Write SQLNotificacao show?
>
> Have you tried this:
> If len(AgCodEmpresa) = 0 then AgCodEmpresa = "Null"
>
> Bob Barrows
>
> --
> 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.
>
>