Here's a video tutorial that will walk you through View, Insert, Update, and Delete records in REALbasic using the RealSQL database:
REALbasic Database Video Tutorial
I put this together because the docs about DB use in RB seem to be a little laching -- at least for me.
Jay Jennings
Subscribe to:
Post Comments (Atom)
14 comments:
Thanks for the tutorial videos.
I`m just starting out in RB and found them very useful.
Very good tutorial, I have only just started to get into RB and programming in general and I found this far better than any book.
The only issue I seem to have is that when I try and run the prog, it "highlights" "rs.edit" or "rs.DeleteRecord". Under the window to the right it states "rs" at vakue "Nil". Any ideas what I have done wrong?
Same problem, I think the tutorial needs a little update
Your UpdateRow() sql statement should be as follows:
sql = "select name,homepage,country from people where name = '" + lstPeople.Cell(lstPeople.ListIndex,0) + "' and homepage = '" + lstPeople.Cell(lstPeople.ListIndex,1) + "' and country = '" + lstPeople.Cell(lstPeople.ListIndex,2) + "'"
hello there...
i m quite new with this but managed to create my first database with your tutorial... the only thing i couldnt do was to actually have the words
"name" "homepage" and "Country" show up in the listbox (i put the column count to 3 and the checked the hasheading option but it came with fixed numbering "0" "1" "2").
what am i doing wrong???
thanks!
Hi,
I use Paradox programming. I 'll use RealBasic but is programm translate possible from paradox to realBasic? Where can I find realbasic examples for working with multiple tables by RealBasic.
B.Reg.
Emin
I use Paradox 9.0. I 've interest RealBasic. Can I Translate my programs from paradox to real basic?! I work with multiple tables by paradox. Is it possible by RB?
B.Reg.
Emin Ozdemir
I really need a help. How to create records to a multiple table? Just say, I have four table: People, Animal, Building and School. All the tables have the same fields or if there is possibility to create different field but of the same number. Please help me.
Thanks.
I want to thank the tutotrial, I was any help
make up my mind to purchase REALbasic.
I hope that my approach is positive.
I want to thank the tutotrial, I was any help
make up my mind to purchase REALbasic.
I hope that my approach is positive.
Thank you, Thank you, Thank you. This was just what I was looking for.
Can you suggest the Best REPORT WRITER for Real Basic, and needs to be cross platform.
Thank u
Hi!!, Its a great Real Basic Tutorial!!.
Unfortunately I have a code trouble, I'm a totally newbie, I'm a Visual Basic 6.0 and Visual .NET programmer, I'm understanding RB. So here is the problem.
When I wanna insert the record to the "Tutor" table.
I can't do it :( , (NOTE: The "Tutor table exists with its columns: Name,homepage and country").
I Run the program, Fill the name, country and homepage fields and then press the OK button.
and program stops!.
It shows me the "NILObjectException" message, a bug picture, and a Variables panel.
The Variables panel shows this table:
Name | Value
Globals
me PushButton
rec DataBaseRecord
self Window1.Window1
What Can I do??, Regards
Thanks
I loved your tutorial.. very helpful! I was wondering.. is the RDB available so we could play with it? Everything went kind of quickly..
I am trying to import a text file into sqlite,, and am struggling ..
Thanks!
Post a Comment