Path: csiph.com!eternal-september.org!feeder.eternal-september.org!weretis.net!feeder6.news.weretis.net!feeder5.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From: Greg <greg@alicie.com>
Newsgroups: it.comp.lang.visual-basic
Subject: Re: vb6 -Dao differenza tra xp e successivi
Date: Thu, 21 Nov 2019 21:35:03 +0100
Organization: solani.org
Lines: 11
Message-ID: <qr6sdq$b94$1@solani.org>
References: <qnf8qp$1p1c$1@gioia.aioe.org> <qnslli$12lp$1@gioia.aioe.org> <qr6hbs$sjp$1@gioia.aioe.org>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: solani.org 1574368506 11556 127.0.0.43 (21 Nov 2019 20:35:06 GMT)
X-Complaints-To: abuse@news.solani.org
NNTP-Posting-Date: Thu, 21 Nov 2019 20:35:06 +0000 (UTC)
Cancel-Lock: sha1:+81+gwogo0WpOHirRb4dmamZtZ8=
X-User-ID: eJwNysERwDAIA7CVQo3NMU5C6/1HSPUWodBUikqaTmj1QMNNG0/jD+Wg5gWOYifjW4Cbq+pcApQQDw==
X-Newsreader: MesNews/1.08.06.00-it
Xref: csiph.com it.comp.lang.visual-basic:19671

Il 21/11/19 18:26:22 Sauro ha scritto:

> Set xRS = PublicDB.OpenRecordset("SELECT TOP 1 DATAEFF FROM RILEV WHERE DIP = '" & v_DIP & "'" & _
>         " AND DATAEFF >=#1/1/2000# ORDER BY DATAEFF DESC")


Anche se non è una risposta, ma se lo scopo è trovare l'ultimo giorno di lavoro di UN SOLO dipendente, non basterebbe 
un semplice MAX DATAEFF?

-- 
Greg