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>
