Re: Lettura dati da tabella access

Article View: free.it.visual-basic

Article #1614

Back to free.it.visual-basic Previous Next

#1614

From: Francesco Sorrentino
Date: Tue, 30 Mar 2004 09:00

22 lines
1795 bytes

"elvis" <nella.pedron@tin.it> ha scritto nel messaggio
news:XDS9c.115989$z23.4938268@news3.tin.it...
> Ho il seguente problema :
> devo leggere dei dati da una tabella access,
> in alcuni casi i campi del record sono vuoti quindi = Null ( ?)
> ma in fase di lettura utilizzando vb non riesco a determinare se tale
campo
> sia appunto = Null

La gestione del NULL in VB � gestita da una funzione ben precisa chiama
"isNull"

>
> mi spiego :
>
> if record.recordset!nomecampo = Null then textn.text="campo vuoto"

la seguente istruzione la modifichi cos�:
if isNull(record.recordset!nomecampo) then textn.text="campo vuoto"

Ciao
Francesco

Technical Details

Message-ID: <c4bd02$977$1@newsreader.mailgate.org>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!ecngs!feeder.ecngs.de!news.cambrium.nl!news.cambrium.nl!news2.euro.net!news.mailgate.org!newsreader.mailgate.org!not-for-mail

References: <XDS9c.115989$z23.4938268@news3.tin.it>

Show Full Headers

Complete Article Headers

X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,72218b787cce42d6
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2004-03-30 01:00:51 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!ecngs!feeder.ecngs.de!news.cambrium.nl!news.cambrium.nl!news2.euro.net!news.mailgate.org!newsreader.mailgate.org!not-for-mail
From: "Francesco Sorrentino" <f.sorrentinoTOGLIMI@tin.it>
Newsgroups: free.it.visual-basic
Subject: Re: Lettura dati da tabella access
Date: Tue, 30 Mar 2004 11:00:37 +0200
Organization: Mailgate.ORG Server - http://www.Mailgate.ORG
Lines: 24
Sender: f.sorrentino@tin.it
Message-ID: <c4bd02$977$1@newsreader.mailgate.org>
References: <XDS9c.115989$z23.4938268@news3.tin.it>
NNTP-Posting-Host: host90-215.pool80205.interbusiness.it
X-Trace: newsreader.mailgate.org 1080637250 9447 80.205.215.90 (30 Mar 2004 09:00:50 GMT)
X-Complaints-To: abuse@mailgate.org
NNTP-Posting-Date: Tue, 30 Mar 2004 09:00:50 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165

Reply to Parent Message