Hallo in die vorweihnachtliche runde....
Ich möchte gerne in einer kleinen rb-datenbank den jeweils zuletzt
angelegten datensatz updaten, aber irgendwie komme ich nicht an ihn
ran. Wer weiß rat, bzw. kann mir armen unwissenden erklären, wie ich
die zeile
datenbank. sqlexecute "update tabelle set feldname='wert'"
ergänzen muss, _where row_id=last_rowid_ tut es jedenfalls nicht.
danke
enno
--
os 10.3.9 rb 5.5.5us
From Sat 24 Dec 2005 15:35:04 +0100
Return-Path: <realbasic-nug dot de-bounces at lists dot realsoftware dot com>
Received: from lists.realsoftware.com (209.198.132.125) by realsoftware.com
with ESMTP (Eudora Internet Mail Server 3.1.3);
Sat, 24 Dec 2005 08:35:27 -0600
Received: from lists.realsoftware.com (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP
id 07DB6F86588; Sat, 24 Dec 2005 08:35:25 -0600 (CST)
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 mailout11.sul.t-online.com (mailout11.sul.t-online.com
[194.25.134.85])
by lists.realsoftware.com (Postfix) with ESMTP id E49BBF8657C
for <realbasic-nug dot de at lists dot realsoftware dot com>;
Sat, 24 Dec 2005 08:35:21 -0600 (CST)
Received: from fwd32.aul.t-online.de by mailout11.sul.t-online.com with smtp
id 1EqAUT-0004nL-02; Sat, 24 Dec 2005 15:35:21 +0100
Received: from [84.137.218.253]
(XHfSh0ZJYeCK0zMScRRPLynn7SraJt7mHiTTHhDDgT7ZtdwNnMYLsn at [84 dot 137
dot 218 dot 253])
by fwd32.sul.t-online.de
with esmtp id 1EqAUE-197LEG0; Sat, 24 Dec 2005 15:35:06 +0100
Mime-Version: 1.0 (Apple Message framework v746.2)
In-Reply-To: <4e89bac14c014c251a699b94a17b0ff7 at t-online dot de>
References: <4e89bac14c014c251a699b94a17b0ff7 at t-online dot de>
Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed
Message-Id: <D055EEB0-8CD2-4F2A-B5C8-C0697BE1F40D at t-online dot de>
Content-Transfer-Encoding: quoted-printable
From: michaelkoop at t-online dot de
Date: Sat, 24 Dec 2005 15:35:04 +0100
To: REALbasic NUG German <realbasic-nug dot de at lists dot realsoftware dot
com>
X-Mailer: Apple Mail (2.746.2)
X-ID: XHfSh0ZJYeCK0zMScRRPLynn7SraJt7mHiTTHhDDgT7ZtdwNnMYLsn
X-TOI-MSGID: aa0617e2-0fad-4424-85c3-775d5cc319fd
Subject: Re: Aktuellen RB-datensatz updaten?
X-BeenThere: realbasic-nug dot de at lists dot realsoftware dot com
X-Mailman-Version: 2.1.2
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
Hallo Enno,
datenbank.SQLExecute("UPDATE Personen SET Gruppe='19' where
Gruppe='10'")
if Not datenbank.error then datenbank.Commit
funktioniert beispielweise bei mir.
Gruß u. Frohe Weihnachten
Michael
Am 24.12.2005 um 15:23 schrieb Enno Bussmann:
Hallo in die vorweihnachtliche runde....
Ich möchte gerne in einer kleinen rb-datenbank den jeweils zuletzt
angelegten datensatz updaten, aber irgendwie komme ich nicht an ihn
ran. Wer weiß rat, bzw. kann mir armen unwissenden erklären, wie
ich die zeile
datenbank. sqlexecute "update tabelle set feldname='wert'"
ergänzen muss, _where row_id=last_rowid_ tut es jedenfalls nicht.
danke
enno
--
os 10.3.9 rb 5.5.5us
From 24 Dec 2005 18:29 GMT
Return-Path: <realbasic-nug dot de-bounces at lists dot realsoftware dot com>
Received: from lists.realsoftware.com (209.198.132.125) by realsoftware.com
with ESMTP (Eudora Internet Mail Server 3.1.3);
Sat, 24 Dec 2005 12:24:05 -0600
Received: from lists.realsoftware.com (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP
id 371DDF87252; Sat, 24 Dec 2005 12:24:03 -0600 (CST)
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 mailout05.sul.t-online.com (mailout05.sul.t-online.com
[194.25.134.82])
by lists.realsoftware.com (Postfix) with ESMTP id D2790F87245
for <realbasic-nug dot de at lists dot realsoftware dot com>;
Sat, 24 Dec 2005 12:24:00 -0600 (CST)
Received: from fwd31.aul.t-online.de by mailout05.sul.t-online.com with smtp
id 1EqE3k-0005eH-00; Sat, 24 Dec 2005 19:24:00 +0100
Received: from 192.168.2.14
(r22ih0ZroejkE2grjwEpL4igMhTcDk5PVoI6ddnp3WLitkgvsjBCsi at [80 dot 139
dot 210 dot 115])
by fwd31.sul.t-online.de
with smtp id 1EqE3i-1gDXE00; Sat, 24 Dec 2005 19:23:58 +0100
MIME-Version: 1.0
From: mm-systems at t-online dot de
References: <4e89bac14c014c251a699b94a17b0ff7 at t-online dot de>
<D055EEB0-8CD2-4F2A-B5C8-C0697BE1F40D at t-online dot de>
In-Reply-To: <D055EEB0-8CD2-4F2A-B5C8-C0697BE1F40D at t-online dot de>
To: "REALbasic NUG German" <realbasic-nug dot de at lists dot realsoftware dot
com>
X-Mailer: T-Online eMail 5.00.0035
Content-Type: Text/Plain;
Charset="ISO-8859-1"
Content-Transfer-Encoding: Quoted-Printable
Date: 24 Dec 2005 18:29 GMT
Message-ID: <1EqE3i-1gDXE00 at fwd31 dot sul dot t-online dot de>
X-ID: r22ih0ZroejkE2grjwEpL4igMhTcDk5PVoI6ddnp3WLitkgvsjBCsi
X-TOI-MSGID: 60919e42-3632-472f-8d34-894c5a075062
Subject: Re: Aktuellen RB-datensatz updaten?
X-BeenThere: realbasic-nug dot de at lists dot realsoftware dot com
X-Mailman-Version: 2.1.2
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
geht nicht auch erst mal
SELECT ID from 'datenbank' ORDER BY ID DESC LIMIT 1;
Dann diese ID mit idxfield(1) ...einer Variablen zuordnen....
dann update bla bla where ID = Variable
geht bei mit immer!
Schöne Weihnachten!
|