I have already replied to this email, just an hour after your post.
Do you haven't received it?
I can see it on my NUG archive...
Anyway, this was my reply:
"
Well, I think they are just references not complete code ... anyway,
this is the issues I have just found:
- the CreateDB example, creates a "mydb" database
- the OpenDB example, opens a "Pubs" database
- the WriteDB example, writes into a "Employees" database
so, the first thing to do is to use always the same database not
three different databases.
The WriteDB example, assumes you already have a table Employees into
the database, so obviously with a simple cut/copy of the code a
"CREATE TABLE Employees ... " statement is missed.
And I think you get a "NilObjectException" in the WriteDB method
because an indispensable db.Connect method is missed here.
"
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
On Apr 14, 2006, at 6:05 PM, Emile Schwarz wrote:
Since no reaction, here I am again:
Emile
-------- Original Message --------
From: - Wed Apr 12 14:03:20 2006
X-Mozilla-Status: 0001
X-Mozilla-Status2: 00800000
Message-ID: <[EMAIL PROTECTED]>
Date: Wed, 12 Apr 2006 09:55:15 +0200
From: Emile Schwarz <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US;
rv:1.7.2) Gecko/20040804 Netscape/7.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: REALbasic Network Users Group <realbasic-
[EMAIL PROTECTED]>
Subject: REALSQLdatabase example in the Embeded Language Reference
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
<Later update: you do not need to use three MenuItems...>
Hi,
REALbasic 2005r4
Mac OS X 10.4.6
Macintosh PowerBook G4 15" Alu (08-2004)
Power on the Macintosh,
Run REALbasic 2005r4,
Open the Menu Editor,
Create a Menu: REAL SQL
Create three MenuItems:
Create (Command-Shift-N)
Open (Command-Shift-O)
Write (Command-Shift-W)
[REALSQLdatabase: NOW!]
Open the Embedded Language Reference,
Go to the REALSQLdatabase Class entry,
Open Window1,
create three Menu Handlers:
REALSQLCreate
REALSQLOpen
REALSQLWrite
create three Methods
CreateDB
OpenDB
WriteDB
place in each MenuHandler a call to the three Methods
In REALSQLCreate, put CreateDB; in REALSQLOpen, put OpenDB
and in REALSQLWrite, put WriteDB.
In the REALSQLdatabase Class, copy / paste the three code examples
in the three
related Methods... [code to create a DB in CreateDB, code to open
an existing DB
in OpenDB, code to add a record in a db in WriteDB]
Save using a name the project,
Run and get:
<b>Internal Error</b>
An unhandled NilObjectException has occured. ETC
<Continue> <Quit>
--
No, this message is complete :(
and yes, I am angry :(
_______________________________________________
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>
_______________________________________________
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>