Le 29 août 07 à 17:41, yohan at chez-basile dot com a écrit :
Oui oui je fais bien un rs = db.SQLSELECT (requete),
et même en rajoutant le WHERE 1=1 je n'ai pas plus de succès.
Montre toute ta ligne (copié- collé).
Peut-être que l'on trouvera un hic ?
--
Thierry NAUZE Saint-Denis de la Réunion
From Wed 29 Aug 2007 16:05:56 +0200 (CEST)
Return-Path: <realbasic-nug dot fr-bounces at lists dot realsoftware dot com>
X-Original-To: listarchive at realsoftware dot com
Delivered-To: listarchive at realsoftware dot com
Received: by xmail.realsoftware.com (Postfix, from userid 1037)
id 164E43F4AE98; Wed, 29 Aug 2007 07:06:06 -0700 (PDT)
X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on
www.realsoftware.com
X-Spam-Level:
X-Spam-Status: No, score=-1.5 required=4.5 tests=AWL,BAYES_00,
FORGED_RCVD_HELO,NO_REAL_NAME autolearn=no version=3.1.1
Received: from lists.realsoftware.com (m.realsoftware.com [66.116.103.65])
by xmail.realsoftware.com (Postfix) with ESMTP id C3D4D3F4AE8C;
Wed, 29 Aug 2007 07:06:02 -0700 (PDT)
Received: from real-software-mini.local (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP id 00E165DD6CD;
Wed, 29 Aug 2007 09:05:51 -0500 (CDT)
X-Original-To: realbasic-nug dot fr at lists dot realsoftware dot com
Delivered-To: realbasic-nug dot fr at lists dot realsoftware dot com
Received: from Basile.chez-basile.com (vac26-1-82-242-179-18.fbx.proxad.net
[82.242.179.18])
by lists.realsoftware.com (Postfix) with ESMTP id C72985DD6C2
for <realbasic-nug dot fr at lists dot realsoftware dot com>;
Wed, 29 Aug 2007 09:05:46 -0500 (CDT)
Received: by Basile.chez-basile.com (Postfix, from userid 0)
id A1ED427CCA2; Wed, 29 Aug 2007 16:05:56 +0200 (CEST)
From: yohan at chez-basile dot com
Subject: Re: RealDatabase et SQL?
To: REALbasic NUG French <realbasic-nug dot fr at lists dot realsoftware dot
com>
Cc:
X-Originating-IP: 192.168.0.241
X-Mailer: Webmin 1.320
Date: Wed, 29 Aug 2007 16:05:56 +0200 (CEST)
Message-Id: <1188396356 dot 11155 at Basile dot chez-basile dot com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="bound1188396356"
X-BeenThere: realbasic-nug dot fr at lists dot realsoftware dot com
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: REALbasic NUG French <realbasic-nug dot fr at lists dot realsoftware dot
com>
Sender: realbasic-nug dot fr-bounces at lists dot realsoftware dot com
Errors-To: realbasic-nug dot fr-bounces at lists dot realsoftware dot com
This is a multi-part message in MIME format.
--bound1188396356
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
Thierry Nauze wrote ..
Le 29 août 07 à 17:41, yohan at chez-basile dot com a écrit :
> Oui oui je fais bien un rs = db.SQLSELECT (requete),
> et même en rajoutant le WHERE 1=1 je n'ai pas plus de succès.
Montre toute ta ligne (copié- collé).
Peut-être que l'on trouvera un hic ?
--
Thierry NAUZE Saint-Denis de la Réunion
Hum, ça va pas être très lisible, parce que la requette est constitué par des
éléments texte du popupmenu.
Mais ceci dit quand je mete un point d'arret dans le débugger pour voir si ma
requete est bien formée, tout me parait ok
requete3 = "SELECT * FROM Selector WHERE Selector."+ CompareW.ChampsTable2(0).Text + " NOT IN
(SELECT Netia."+ CompareW.ChampsTable1(0).Text + " FROM Netia WHERE 1=1)"
rs = Cartable.SQLSelect (requete3)
If Cartable.Error Then
MainW.AddText (Cartable.ErrorMessage + " error Nr "+
Str(Cartable.ErrorCode)+cr)
End if
--bound1188396356--
From Wed 29 Aug 2007 16:17:04 +0200 (CEST)
Return-Path: <realbasic-nug dot fr-bounces at lists dot realsoftware dot com>
X-Original-To: listarchive at realsoftware dot com
Delivered-To: listarchive at realsoftware dot com
Received: by xmail.realsoftware.com (Postfix, from userid 1037)
id 190B23F4BA3A; Wed, 29 Aug 2007 07:17:14 -0700 (PDT)
X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on
www.realsoftware.com
X-Spam-Level:
X-Spam-Status: No, score=-1.5 required=4.5 testsºYES_00,FORGED_RCVD_HELO,
NO_REAL_NAME autolearn=no version=3.1.1
Received: from lists.realsoftware.com (m.realsoftware.com [66.116.103.65])
by xmail.realsoftware.com (Postfix) with ESMTP id F36433F4BA30;
Wed, 29 Aug 2007 07:17:09 -0700 (PDT)
Received: from real-software-mini.local (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP id 64F185DD79F;
Wed, 29 Aug 2007 09:16:58 -0500 (CDT)
X-Original-To: realbasic-nug dot fr at lists dot realsoftware dot com
Delivered-To: realbasic-nug dot fr at lists dot realsoftware dot com
Received: from Basile.chez-basile.com (vac26-1-82-242-179-18.fbx.proxad.net
[82.242.179.18])
by lists.realsoftware.com (Postfix) with ESMTP id 6A6D15DD794
for <realbasic-nug dot fr at lists dot realsoftware dot com>;
Wed, 29 Aug 2007 09:16:54 -0500 (CDT)
Received: by Basile.chez-basile.com (Postfix, from userid 0)
id 8953D27CCA2; Wed, 29 Aug 2007 16:17:04 +0200 (CEST)
From: yohan at chez-basile dot com
Subject: Re: RealDatabase et SQL?
To: REALbasic NUG French <realbasic-nug dot fr at lists dot realsoftware dot
com>
Cc:
X-Originating-IP: 192.168.0.241
X-Mailer: Webmin 1.320
Date: Wed, 29 Aug 2007 16:17:04 +0200 (CEST)
Message-Id: <1188397024 dot 11372 at Basile dot chez-basile dot com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="bound1188397024"
X-BeenThere: realbasic-nug dot fr at lists dot realsoftware dot com
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: REALbasic NUG French <realbasic-nug dot fr at lists dot realsoftware dot
com>
Sender: realbasic-nug dot fr-bounces at lists dot realsoftware dot com
Errors-To: realbasic-nug dot fr-bounces at lists dot realsoftware dot com
This is a multi-part message in MIME format.
--bound1188397024
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
La requete telle que je le lis dans le débugger:
SELECT * FROM Selector WHERE Selector.No_SELECTOR NOT IN (SELECT
Netia.Numero_Selector FROM Netia WHERE 1=1)
--bound1188397024--
|