realbasic-nug.de
[Top] [All Lists]

AW: REAL SQL Database rowid

To: "REALbasic NUG German" <realbasic-nug dot de at lists dot realsoftware dot com>
Subject: AW: REAL SQL Database rowid
From: "Christian Hahn" <christian dot hahn at snafu dot de>
Date: Sat, 6 Oct 2007 16:13:53 +0200
Delivered-to: listarchive at realsoftware dot com
Delivered-to: realbasic-nug dot de at lists dot realsoftware dot com
Importance: Normal
> ich glaub die musst du aber bei jedem Select auch mit angeben.
Sicherlich:
rs =DB_Inst.SQLSelect("SELECT * FROM Tabelle where rowid =3")
gibt mir genau einen Datensatz zurück, von dem ich allerdings nur annehmen
kann, dass er die interne ID 3 hat.
Aber dann?
Da rowid keine Eigenschaft ist, kann ich sie nicht einer Variablen zuordnen
oder z.B. in ein Editfield stecken etc.
bestens, Christian Hahn.



From  Sat 6 Oct 2007 16:54:54 +0200
Return-Path: <realbasic-nug dot de-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 A292B465A7EE; Sat,  6 Oct 2007 07:56:03 -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=-2.5 required=4.5 tests=AWL,BAYES_00 autolearn=ham 
        version=3.1.1
Received: from lists.realsoftware.com (m.realsoftware.com [66.116.103.65])
        by xmail.realsoftware.com (Postfix) with ESMTP id 09DEC465A7DA;
        Sat,  6 Oct 2007 07:55:59 -0700 (PDT)
Received: from real-software-mini.local (localhost [127.0.0.1])
        by lists.realsoftware.com (Postfix) with ESMTP id 8BEA4737BD3;
        Sat,  6 Oct 2007 09:55:42 -0500 (CDT)
X-Original-To: realbasic-nug dot de at lists dot realsoftware dot com
Delivered-To: realbasic-nug dot de at lists dot realsoftware dot com
Received: from smtprelay09.ispgateway.de (smtprelay09.ispgateway.de
        [80.67.29.23])
        by lists.realsoftware.com (Postfix) with ESMTP id 12220737BC8
        for <realbasic-nug dot de at lists dot realsoftware dot com>;
        Sat,  6 Oct 2007 09:55:37 -0500 (CDT)
Received: (qmail 18518 invoked from network); 6 Oct 2007 14:55:52 -0000
Received: from unknown (HELO [192.168.1.80]) (363246 at [84 dot 175 dot 96 dot 
243])
        (envelope-sender <support at monkeybreadsoftware dot de>)
        by smtprelay09.ispgateway.de (qmail-ldap-1.03) with SMTP
        for <realbasic-nug dot de at lists dot realsoftware dot com>; 6 Oct 
2007 14:55:52 -0000
To: realbasic-nug dot de at lists dot realsoftware dot com (REALbasic NUG 
German)
In-Reply-To: <CJEDJMADEBEGDPIKKGNLMELICMAA dot christian dot hahn at snafu dot 
de>
Subject: Re: AW: REAL SQL Database rowid
From: support at monkeybreadsoftware dot de (Christian Schmitz)
Date: Sat, 6 Oct 2007 16:54:54 +0200
Message-ID: <1i5kmy9 dot 1e3xn104cjxqhM%support at monkeybreadsoftware dot de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Organization: Monkeybread Software Germany
X-Face: nrf3>{WQ6c&r+7 at e)"]0G60`-6ND^)I2mI%>)QGYa=9"=7jhd-g2|b3!>Al0+
        Ccb%xGQshhi|g at QU2$
User-Agent: MacSOUP/D-2.8 (Mac OS X version 10.4.9 (PPC))
X-BeenThere: realbasic-nug dot de at lists dot realsoftware dot com
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: REALbasic NUG German <realbasic-nug dot de at lists dot realsoftware 
dot com>
Sender: realbasic-nug dot de-bounces at lists dot realsoftware dot com
Errors-To: realbasic-nug dot de-bounces at lists dot realsoftware dot com

Christian Hahn <christian dot hahn at snafu dot de> wrote:

> Da rowid keine Eigenschaft ist, kann ich sie nicht einer Variablen zuordn=
en
> oder z.B. in ein Editfield stecken etc.
> bestens, Christian Hahn.

editfield1.text=3Drs.field("ROWID").stringvalue

geht das nicht?

Bei Valentina musste man immer beim select "ROWID,*" schreiben, weil *
nicht ROWID beinhaltet.

Gru=DF
Christian

--=20
Over 900 classes with 17000 functions in one REALbasic plug-in.=20
The Monkeybread Software Realbasic Plugin v7.6.=20

<http://www.monkeybreadsoftware.de/realbasic/plugins.shtml>


<Prev in Thread] Current Thread [Next in Thread>
  • AW: REAL SQL Database rowid, Christian Hahn <=