realbasic-nug
[Top] [All Lists]

Re: Trying to use a data base

To: "REALbasic NUG" <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: Trying to use a data base
From: "Peter Bozek" <peter dot bozek at gmail dot com>
Date: Sat, 30 Dec 2006 13:30:58 +0100
Delivered-to: listarchive at realsoftware dot com
Delivered-to: realbasic-nug at lists dot realsoftware dot com
Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=OYZYwYCT1HzJrGJZ4qENFL3yy8AfBdlE5xU2RHRH3iZezAKQkBixwdLI1i/r0xt8Hg/B3xr/P77rJPOeEL8YkT0J96+AlbWt8ICZfiOcXqq+HImRqcFdUJGZQBQVal9cjZZ59w/rl+PS2axJdjb+KU+CipFPFnDDa/EB4cZjM3E=
References: <p0623090dc1bbf037d246 at 192 dot 168 dot 0 dot 32>
On 12/30/06, Jacob Palme <jpalme at dsv dot su dot se> wrote:
    // SEcond test statement
    SelectedRecords = EnglishDictDB.SQLSelect("SELECT * FROM
OneEntryForEachWord WHERE TheWord='afraid'")
    EnglishDictDB.Commit

You do not need to commit after SQLSelect.

Does this mean that no data was found? How can I get the
contents of the record retrived with the SQLSelect

If there would be no data found, SelectedRecords wwould be nil. look
at the RecordCount property.

statement? The REALBasic User guide is rather vague about
how to get the contents of a retrieved record.

Look at LanguageReference, it contain many examples.

HTH,
--
Peter Bozek
_______________________________________________
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>


<Prev in Thread] Current Thread [Next in Thread>