novaBBS - comp.lang.clipper.visual-objects

Re: Vo2Ado Empty dates

<8e08b5f7-500f-45ea-bb89-0beb90591229n@googlegroups.com>

https://www.novabbs.com/devel/article-flat.php?id=10088&group=comp.lang.clipper.visual-objects#10088

copy link Newsgroups: comp.lang.clipper.visual-objects

X-Received: by 2002:ad4:48d4:0:b0:66d:7ee:670d with SMTP id v20-20020ad448d4000000b0066d07ee670dmr253504qvx.10.1698777762499;
Tue, 31 Oct 2023 11:42:42 -0700 (PDT)
X-Received: by 2002:a05:6870:d1d0:b0:1e9:a86f:ec44 with SMTP id
b16-20020a056870d1d000b001e9a86fec44mr1646498oac.2.1698777762263; Tue, 31 Oct
2023 11:42:42 -0700 (PDT)
Path: i2pn2.org!i2pn.org!paganini.bofh.team!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Tue, 31 Oct 2023 11:42:41 -0700 (PDT)
In-Reply-To: <s8bc93$1p6$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=80.32.130.199; posting-account=y25v8QoAAACSc7riUyaoZvUyK7P_Is2q
NNTP-Posting-Host: 80.32.130.199
References: <b068bd7d-14db-46d7-a927-43c69640f2a6n@googlegroups.com> <s8bc93$1p6$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <8e08b5f7-500f-45ea-bb89-0beb90591229n@googlegroups.com>
Subject: Re: Vo2Ado Empty dates
From: frinc...@gmail.com (Carlos Vazquez)
Injection-Date: Tue, 31 Oct 2023 18:42:42 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

by: Carlos Vazquez - Tue, 31 Oct 2023 18:42 UTC

Jamal, sorry for ultra-late response... :)
I was (again) looking for an answer to "How to send NULL values to SQL servers" and see this message. Your anwser is the one I needed. Thx!!!

El sábado, 22 de mayo de 2021 a las 18:42:13 UTC+2, Jamal escribió:
> In your app, try calling
>
> AdoConvertNullStringToNull ( TRUE )
>
>
> P.S. I don't use the Vo2Ado, but I looked at the documentation. Source:
>
>
> FUNCTION AdoConvertNullStringToNull ( lSet ) AS
>
> Argument(s)
>
> lSet When TRUE, NULL_STRINGS will be converted to NULL, else an Empty
> value is passed to COM. The default behaviour is NOT to convert them to NULL
>
>
> Return
>
>
> The process of converting NULL_STRINGS can be switched ON/OFF by calling
> the AdoCheckNullString function
>
>
> See Also
>
> Support functions, AdoCheckNullString, Data Types
>
>
> HTH,
> Jamal
> On 5/19/2021 8:40 AM, Carlos Vazquez wrote:
> > Hi!
> > I'm converting some DBF table to SQLServer. When there is an empty date value, the following code throws an error "type conflict: text is not compatible with date".
> >
> > How can I pass empty date values to SQLServer?
> >
> > Thanks!!
> > ****************
> >
> > aParametros := ArrayCreate(2)
> >
> > oCmd:CommandText := "INSERT INTO [Ark].[dbo].[Cliente] ( [Ark].[dbo].[Cliente].[Codigo], [Ark].[dbo].[Cliente].[Fecha] ) VALUES (?,?)"
> >
> > sCliente:GoTop()
> > WHILE !sCliente:EoF
> > aParametros[ 1] := sCliente:FIELDGET( #CODIGO )
> > aParametros[ 2] := sCliente:FIELDGET( #FECHA )
> > //
> > oCmd:Execute(@uResult,aParametros,NIL)
> > IF uResult != 1
> > MostrarError( oCmd:Error:description )
> > BREAK
> > ENDIF
> > sCliente:Skip()
> > ENDDO
> >

Subject	Author
Vo2Ado Empty dates	Carlos Vazquez

"Stupidity, like virtue, is its own reward" -- William E. Davidsen

devel / comp.lang.clipper.visual-objects / Re: Vo2Ado Empty dates