Page 1 of 1
inserting a record in the table of a database on the server
Posted: Thu 15 Jan 2009 23:08
by alpha
Hi, I'm a newbie

but impressed by the ease with which I could reacht my database on my lamp server using de demo program
However there are no simple basic examples, in my case to insert a record.
Which components should I use besides Myconnection etc
Tnks
Posted: Fri 16 Jan 2009 13:20
by Dimon
To solve this problem you should use the TMyTable or TMyQuery component.
Also you can use the TDBGrid component to display and edit the records from a database table.
You can look at the example of using these components in MyDacDemo.
Posted: Fri 16 Jan 2009 14:03
by jkuiper
Hi, I'm a newbie Embarassed but impressed by the ease with which I could reacht my database on my lamp server using de demo program
Where is your L.A.M.P. server running. Be sure that you can reach your database on port 3306 or via SSH if available.
LAMP mydacdemo
Posted: Fri 16 Jan 2009 16:10
by alpha
Tnks for the replies, My LAMP server is indeed open as are the database with proper permissions.
Accessing the table and inserting a record works fine when using MYdacdemo/table, but when I use a connection, source and table component and try to update after an insert I get the message: cannot update, read only (while using Mydacdemo works!)
Probably doing something stupid as a newbie

Posted: Mon 19 Jan 2009 13:17
by Dimon
Please make sure that the TMyQuery.ReadOnly property is set to False.
Tnks
Posted: Mon 19 Jan 2009 20:58
by alpha
Tnks for helping me getting started, I can reach my LAMP server and database and update records.
Should/can I close this topic, or does the moderator do that, well I'll see
Bye