Hi Jacob ,
Question 1: What did I do wrong so that the first test
statement did not return the contents of the record. I know
that there is a record where "TheWord" has the value
"$addiction".
••••
see previous email (and answer to Q4)
Question 2: Why did the program crash when I tried to
execute the second test statement?
••••
no idea, sorry
Question 3: I have entered into the data base more than one
record with "TheWord" = "$addiction". But there only seems
to be one such record in the data base.
••••
Sounds like TheWord is a primary key field? (He asks not knowing if
RBDB has this option). Most database engines have a unique index
option and it sounds like you have that set for TheWord.
Question 4: How does one debug SQL statements?
••••
Build the query as a string and then call the string variable as your
sql statment.
Dim s, myvariable as string
s = "Select * from foo where foo1 = '" + myvariable + "';"
rs = mydb.sqlselect(s)
set a breakpoint or msgbox if you want to check the sql prior to
executing it
Question 5: The subchapter "Editing Records" in the User
guide does not contain any examples. If there had been an
example, I might have learnt more how to do and maybe
myself understood what I did wrong. Is there any guide to
REALBasic data bases which does contain examples?
••••
there is an example I think, but from a forum message I just read it
appears to be broken. I'm sure there's others around if you google.
cheers
kim
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
From Sat 30 Dec 2006 11:45:17 +0000 (GMT)
Return-Path: <realbasic-nug-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 A046C1525223; Sat, 30 Dec 2006 03:45:41 -0800 (PST)
X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on
www.realsoftware.com
X-Spam-Level:
X-Spam-Status: No, score=-1.3 required=4.5 tests=AWL,BAYES_00,NO_REAL_NAME
autolearn=no version=3.1.1
Received: from lists.realsoftware.com (lists.realsoftware.com [209.198.132.125])
by xmail.realsoftware.com (Postfix) with ESMTP id 158CF152521C;
Sat, 30 Dec 2006 03:45:37 -0800 (PST)
Received: from lists.realsoftware.com (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP
id CDAE11797F0C; Sat, 30 Dec 2006 05:45:24 -0600 (CST)
X-Original-To: realbasic-nug at lists dot realsoftware dot com
Delivered-To: realbasic-nug at lists dot realsoftware dot com
Received: from web28008.mail.ukl.yahoo.com (web28008.mail.ukl.yahoo.com
[217.146.182.113])
by lists.realsoftware.com (Postfix) with SMTP id 22AB21797EFA
for <realbasic-nug at lists dot realsoftware dot com>;
Sat, 30 Dec 2006 05:45:18 -0600 (CST)
Received: (qmail 99402 invoked by uid 60001); 30 Dec 2006 11:45:17 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.de;
h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
b=WnKCltf0ATnbqqoyoYQtyeN+weEsXOGydlAsO4xwhdQc9x0nVoBOoWNKK1EYBEJcG7kyZubCZduicZkpAsCFOOTWcdu1FNoxRDUDuOXdUslVu3lCVQLc7Woom3Km+BOsV1IsdduQcfT69QYbO1vXgq4DVCyusTBW7n3l2x9qunM
;
Message-ID: <20061230114517 dot 99400 dot qmail at web28008 dot mail dot ukl dot
yahoo dot com>
Received: from [194.77.100.90] by web28008.mail.ukl.yahoo.com via HTTP;
Sat, 30 Dec 2006 11:45:17 GMT
Date: Sat, 30 Dec 2006 11:45:17 +0000 (GMT)
From: tobieichner77-rb at yahoo dot de
To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Subject: AW: AW: Website Hosting
X-BeenThere: realbasic-nug at lists dot realsoftware dot com
X-Mailman-Version: 2.1.2
Precedence: list
Reply-To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Sender: realbasic-nug-bounces at lists dot realsoftware dot com
Errors-To: realbasic-nug-bounces at lists dot realsoftware dot com
Lol well thats how I decited to have our own dedicated servers.
Yes, I absolutely agree. If you take some time to get familiar with server
management, do so and take over the responsibility in managing your server of
your own. You can just win.
We use a XServe and a dedicated line hosting our websites in-house. While I had
a hard run till getting the XServe working as it should, I consider it now as
one of the best decisions we ever made.
:)
-----Original Message-----
From: tobieichner77-rb at yahoo dot de
To: "REALbasic NUG" <realbasic-nug at lists dot realsoftware dot com>
Sent: 12/29/2006 3:05 PM
Subject: AW: Website Hosting
You just have to be careful and always have a plan B.
Or choose a premium hoster right >from beginning and focusing more to your
business than to plan B :-)
Tobias.
John Balestrieri wrote:
I've had mostly good luck with Dreamhost; they have great deals and
are my current hosting service, but I can't recommend them anymore
without the following caveat: The only problem I've had with them was
when they made an unannounced major upgrade to PHP
[truncated by sender]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
__________________________________________________
Do You Yahoo!?
Sie sind Spam leid? Yahoo! Mail verfügt über einen herausragenden Schutz gegen Massenmails.
http://mail.yahoo.com
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|