I have WAMP server installed and running on my development PC.
Using PHPMYADMIN, I create a MYSQL table.
I am trying to create a web page like this one that comes from a youtube example of the previous version that was called RADPHP.
I have asked for help in the Embacadero forum and I will update this when I resolve it
https://forums.embarcadero.com/thread.jspa?threadID=76785&stqc=true
13-SEP-2012 Update:
It appears that the above example used a thing called DBGrid and that this is no longer a part of the suit.
The DBGrid is not currently available in HTML5 Builder, see this thread for additional information.
meanwhile, you can use the DBRepeater instead to achieve similar results. While it is harder to configure —you must create a control for each field a row is expected to have—, it also gives you more flexibility.
The problem I have is that I can not find an example of HOW to use DBRepeater. The help system tells me WHAT it can do but not HOW I use it.
----------------------------------------------------------------------------------------------
This is what I see when I first start the program
Over on the bottom right of the screen, right click on Mysql and choose Add New Connection
Right click on the connection that was made.
Then click "Modify Connection"
Server Name = Local Host
Database Name = Test in this case
User Name = Root
Password = ahah:)
BTW, WAMP as installed has no root password for mysql. HTML5 builder seemed unwilling to connect to root with no password.
See TBD on giving WAMP MYSQL a password.
Click Test Connection.
Note the little "h5b" This seems to be a remenant of the beta version
Now we seem to have a problem.
When compared to this example:
http://www.youtube.com/watch?feature=player_embedded&v=A4H1zVo5qIQ
The Datasets drop down should have more entries in it.
However I note that the example video is for the previous version caleld RadPHP
Grrrr ....... I am stuck!
There is something I am missing and that is a HTML5 tutorial!
Hi. Thanks for starting this blog. I have been using RadPHP XE2 for about 5 months, now doing eval of the HTML5 Builder. It seems to be missing some of the things from RadPHP... have you gotten the DBRepeater to work?
ReplyDeleteGet your connection to your mysql DB working on the data explore in lower right. Then expand your DB till you see your table. Pickup and drag that table onto a blank page. It puts the db, table and dataset objects, as well as dbrepeater on the page. Then you can drag a field from that same table on the lower right, and drop it into your dbrepeater. Look up in upper right - IF your label didn't go into the right object (the DBRepeater) then move it in the tree in the uppper left. Anyway, you can put whatever you want into the dbrepeater, expand its size, etc.
When you run the page, you should see it repeated for every record in the table. use limit to limit the number dumped.
My issue is I don't see DBPaginator, which used to allow one to step tru the DBRepeater list, past the limit!!!!!
Let me know if you find anything on this.
onmountain at gmail dot com
Jamie
PS Are you doing a web app or mobile app? I am trying to do both
PPS. For RadPHP I bought jomitech.com components - Jon there is teriffic - his forums are the best.
Hi Jamie,
ReplyDeleteI have not gotten it to work.
I think it relies on PDO & have a problem with PDO and WAMP.
I have not used PDO before. Always connected directly to mysql.
I am finding the embarcadero documentation lacking in "how to" information. Quite frustrated actually. I had expected better from a commercial program.
One of the attractions of embaradero was the apparent integration of web and mobile applications as I would like to do both.
I will go check out jonitech.
Thanks,
Frank
Hi Frank,
ReplyDeleteYou have to add fields to the dbrepeater. Simple drag and drop field from the data explorer onto dbrepeater. Just be sure that field is listed UNDER dbrepeater in the structure tree in the upper left corner of the screen. If red dot appears grab the field name and drop it on the dbrepeater name in the structure tree.
Cheers!
You probably already know about this, but Embarcadero just posted a DBGrid for HTML5 Builder:
ReplyDeletehttp://cc.embarcadero.com/ProdCat.aspx?prodid=15&catid=2
Thank you for taking the time out to post your notes.
With dbrepeater you can design almost a dbgrid. First put a wide rectangle dbrepeater to the form. then select labels or edits from the standart componens and drop them inside the repeater. After this step configure the datasource of each label or edit box. That's it. But the main problem is ; with dbrepeater I couldn't find a way to scroll horizontaly
ReplyDeleteHello - What about edit/update fields using dbrepeater?
ReplyDeleteI can only browse any table but it seems it is not possible to edit any row. Am I wrong?
I would like to be able to get fields from the pointed row into dbrepetear. Is it possible to do that?
Thanks - Eric.
Hi Eric,
ReplyDeleteI have given up on it for now. Decided to learn Jquery and dust.js client side templating and use a PHP back end.
The embarcadero people are in my experience very helpful so I would get onto the forums and ask HOW to edit ad update via dbrepeater.
Frank
My component for HTML5 Builder here http://www.h5b.ru
ReplyDeleteDBGrid,DBTreeGrid with master-detail and subgrid mode
Ajax pager, Tabs,Accordion,Dialog,DatePicker and MonthCalendar
thanks for sharing ...
ReplyDeletehtml5