On 31/01/02 19:16, Mr. Weasel Willits said:
create table Im_A_Dork
(
id integer,
who varchar,
why varchar,
butmom varchar,
primary key (id)
)
curs = db.SQLSelect("select * from Im_A_Dork")
for
who = curs.field("who")
...
..
It's actually SQL syntax to create a database.
Sorry, I'm still lost. So how do you use "create table" to get a database
cursor?
REALbasic's database documentation sucks because it assumes you
already know about databases and SQL so they don't teach anything to
you. I hope to remedy this in the future when my schedule opens up
(ha!).
First create a database using NewREALdatabase
You use database.ExecuteSQL to execute an sql statement (like the one
above). Then you use another SQL "select" statement to get certain
columns (Fields) of certain records into a cursor. (like the code
above).
I can't go into more detail now because I have HW to do but if you
read through the developer documentation, find examples on the ftp
site, and download Norman's tutorial (http://www.kirais.com/) (i
think that's the link) then you can start to figure it out.
--
------------------Seth Willits---------------
I'm gettin' there; Just very slowly.
_____ http://freaksoftware.tripod.com/ ______
|