Le 29 août 07 à 18:48, yohan at chez-basile dot com a écrit :
Euh pourquoi? ben parce que je débute en SQL ;-)
J'obtiens donc une requete:
SELECT * FROM Selector LEFT JOIN Netia ON Selector.No_SELECTOR =
Netia.Numero_Selector WHERE Netia.Numero_Selector IS NULL
et un erreur 7 keyword expected à la sortie...
Je pense que Stéphane a raison, mon Mac est hanté par des anguilles
cachées sous des roches ;-)
Si ta base n'est pas secrète et n'est pas trop grosse, envoie-la moi
(mail perso), je testerai ça demain.
--
Thierry NAUZE Saint-Denis de la Réunion
From Wed 29 Aug 2007 23:40: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 F02023F63CF2; Wed, 29 Aug 2007 14:40:13 -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 8C01E3F63CE7;
Wed, 29 Aug 2007 14:40:09 -0700 (PDT)
Received: from real-software-mini.local (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP id 250AA5E04AC;
Wed, 29 Aug 2007 16:39: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 B45285E049F
for <realbasic-nug dot fr at lists dot realsoftware dot com>;
Wed, 29 Aug 2007 16:39:54 -0500 (CDT)
Received: by Basile.chez-basile.com (Postfix, from userid 0)
id A99A627CCA0; Wed, 29 Aug 2007 23:40: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 23:40:04 +0200 (CEST)
Message-Id: <1188423604 dot 17436 at Basile dot chez-basile dot com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="bound1188423604"
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.
--bound1188423604
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
Ne cherchez plus, je crois que j'ai trouvé=
Le problème vient de la façon dont je crée ma base (entièrement avec du code). Quand je fais
créer la base dans l'Ide avec le menu Add puis New Realdatabase, tout se passe bien et les requetes que vous
m'avez suggérées marchent impec.
Merci pour votre aide!
Yoh
--bound1188423604--
|