Hallo,
ich hab' jetzt folgendes gemacht:
Das Datenbank-Feld "Datum" deklariert als Double, mit parsedate ermittle ich
aus dem DatumsString (21.10.2007) die TotalSeconds und speichere sie in die
DB,
der Rückweg entsprechend: die TotalSeconds aus der DB übergebe ich an ein
Date-Objekt und schreibe das ShortDate in meine Tabelle.
War es etwa so gemeint?
beste Grüße, Christian Hahn.
> -----Ursprüngliche Nachricht-----
> Von: realbasic-nug dot de-bounces at lists dot realsoftware dot com
> [mailto:realbasic-nug dot de-bounces at lists dot realsoftware dot com]Im
> Auftrag von
> Christian Schmitz
> Gesendet: Freitag, 19. Oktober 2007 23:54
> An: REALbasic NUG German
> Betreff: Re: Date in DB
>
>
> Christian Hahn <christian dot hahn at snafu dot de> wrote:
>
> > Hallo, ich hab's nicht gefunden: Wie speichert man
> Kalenderdaten in Real SQL
> > Database so, dass sie nach Datum sortiert auch wieder heraus kommen?
>
> nimm date Objekte.
>
> Gruß
> Christian
>
> --
> Over 900 classes with 17000 functions in one REALbasic plug-in.
> The Monkeybread Software Realbasic Plugin v7.6.
>
> <http://www.monkeybreadsoftware.de/realbasic/plugins.shtml>
From Sun 21 Oct 2007 23:13:22 +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 E2F3C48C5B38; Sun, 21 Oct 2007 14:13:33 -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 2F08B48C5B2C;
Sun, 21 Oct 2007 14:13:29 -0700 (PDT)
Received: from real-software-mini.local (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP id C88C57FB7B5;
Sun, 21 Oct 2007 16:13:09 -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 smtprelay02.ispgateway.de (smtprelay02.ispgateway.de
[80.67.18.14])
by lists.realsoftware.com (Postfix) with ESMTP id 5C7067FB7A7
for <realbasic-nug dot de at lists dot realsoftware dot com>;
Sun, 21 Oct 2007 16:13:05 -0500 (CDT)
Received: (qmail 23077 invoked from network); 21 Oct 2007 21:13:21 -0000
Received: from unknown (HELO [192.168.1.80]) (363246 at [84 dot 175 dot 125 dot
170])
(envelope-sender <support at monkeybreadsoftware dot de>)
by smtprelay02.ispgateway.de (qmail-ldap-1.03) with SMTP
for <realbasic-nug dot de at lists dot realsoftware dot com>;
21 Oct 2007 21:13:21 -0000
To: realbasic-nug dot de at lists dot realsoftware dot com (REALbasic NUG
German)
In-Reply-To: <CJEDJMADEBEGDPIKKGNLMEMNCMAA dot christian dot hahn at snafu dot
de>
Subject: Re: AW: Date in DB
From: support at monkeybreadsoftware dot de (Christian Schmitz)
Date: Sun, 21 Oct 2007 23:13:22 +0200
Message-ID: <1i6cwhe dot 1g9jrcwu06nf9M%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:
> War es etwa so gemeint?
n=F6.
Eine Spalte vom Date in the Datenbank kann direkt =FCber dateColumn den
Wert von einem Datum =FCbernehmen.
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>
|