| 12:17.42 | *** join/#mseide mde_novice (n=niyozov@91.188.141.184) |
| 12:50.36 | mde_novice | Hi, I learned how to connect MSE with FireBird, but can anybody tell how to add, edit and delete records |
| 12:52.11 | Manu | you need to ad ad tmsesqlquery |
| 12:52.14 | Manu | add* |
| 12:53.29 | Manu | now I'm leaving for lunch, I'll be back in a few minutes |
| 12:54.19 | mde_novice | I added it and set property SQL to string like "select * from tablename". should i set deleteSQL, editsql property also |
| 13:00.44 | Manu | no |
| 13:01.26 | Manu | you have to add a tmseibconnection and a tmsesqltransaction |
| 13:01.42 | Manu | then add a tmsesqlquery and assign it to the connection and transaction |
| 13:02.15 | Manu | set property SQl to "select * from yourtable" |
| 13:02.41 | Manu | add a tmsedatasource and link it to the tmsesqlquery |
| 13:02.58 | Manu | (DataSet property) |
| 13:03.24 | Manu | add some visual components to the form and link it to the datasource |
| 13:04.06 | Manu | remember to set tmseibconnection active and tmsesqlquery active too |
| 13:04.11 | Manu | add a tdbnavigator and link it to the datasource |
| 13:04.24 | Manu | run the program, you should be able to add, edit and delete records |
| 13:25.20 | Manu | o_O |
| 14:15.04 | *** join/#mseide mse_novice (n=niyozov@91.188.141.223) |
| 14:17.51 | mse_novice | i have tdbstringgrid connected to tmsedatasource which connected to tmsesqlquery. tmsesqlquery.SQL property is "select id, name from employee". What should i do to add new records via these controls |
| 14:19.49 | Manu | mse_novice: tell me what fields your table has? |
| 14:20.05 | Manu | for example: id, name... |
| 14:20.20 | mse_novice | 2: id, name |
| 14:20.51 | Manu | for editing, tmsestringgrid is not the best widget |
| 14:21.09 | Manu | better use tdbwidgetgrid |
| 14:21.32 | Manu | and just add a tdbintegeredit and a tdbstringedit |
| 14:22.08 | Manu | there are a few db examples for MSEide |
| 14:22.22 | Manu | you can pick the link in the Topic (msedocumenting) and download it |
| 14:22.27 | Manu | to see how it works |
| 14:22.47 | Manu | we also have a news system |
| 14:23.08 | Manu | you can join there, here I'm almost alone (for now) :) |
| 14:24.02 | Manu | mse_novice: the tdbwidgetgrid is in the DBe tab page |
| 14:33.26 | mse_novice | yes i found it. thanks for advice |
| 14:44.04 | mse_novice | connected stringedit and integeredit with fields but how to connect tdbwidgetgrid with them |
| 14:45.15 | Manu | you just att a tmsewidgetgrid to a form |
| 14:46.01 | Manu | then click in a tdbintegeredit and click in the tdbwidgetgrid |
| 14:46.13 | Manu | repeat for the tdbstringedit |
| 14:47.32 | Manu | in the widgets select datasource and datafield |
| 14:47.54 | Manu | first link the tdbwidgetgrid to the datasource |
| 14:50.51 | mse_novice | i linked widgetgrid to datasource, linked widgets to datasource and fields. program shows the first record contents in intedit and stringedit. tdbwidgetedit.datacol |
| 14:51.18 | Manu | run the program :) |
| 14:51.53 | mse_novice | program shows first record in intedit and stringedit, it works |
| 14:52.07 | mse_novice | but tdbwidgetgrid is empty |
| 14:52.39 | Manu | is tdbwidgetgrid.datasource assigned? |
| 14:53.17 | mse_novice | yes |
| 14:53.58 | Manu | to add a widget from tab pannels to tdbwidgetgrid you simply have to click the widget in the tab and then in the tdbwidgetgrid, did you it in this way? |
| 14:54.55 | Manu | there is nothing more to do I guess |
| 14:55.07 | Manu | you haven't to touch the datacols |
| 14:56.22 | mse_novice | oh now it works. how to add a record now |
| 14:56.52 | Manu | add a navigator, link it to the datasource, run the application and press the + button to add a record |
| 14:57.19 | Manu | tdbnavigator is in DB tab page |
| 15:24.16 | Manu | bye :/ |
| 21:00.34 | *** join/#mseide mdaems (i=Miranda@d51534EE6.access.telenet.be) |