Filling SQL date field with empty date? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Filling SQL date field with empty date?

Message

De

19/11/2003 14:29:30

Harry Stottle
Royaume Uni

À

19/11/2003 11:10:29

Wayne Myers
Forte' Incorporated
Mobile, Alabama, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Filling SQL date field with empty date?

Divers

Thread ID:

00851431

Message ID:

00851589

Vues:

9

>SQL Server does not understand empty dates - make them null.
>
yeah. Tried that

SQLPREPARE(gnhandle,"update vizkeys set date_used='.NULL.' where date_used<>'.NULL.' ","real")

with and without quotes around the the .NULL.

both rejected. How are we supposed to do it?

Click here to load this message in the networking platform