Fetching data from database (using Mysql)

[uks]

[/b]

Hello everybody...i have got a doubt on fetching data from database to a calcsheet using Mysql Connection.

i am working on Calc sheet.i have created a database named "Newdb7" [ Mysql Connection using JDBC drivers]. i have got tables in "Newdb7" with data.

The Task is--

If i run a macro, it should fetch data from database from the given table like select statement



how to do insert , update, select statements through macro????

Written Code:

sub uday

dim DatabaseContext

DatabaseContext= createUnoService("com.sun.star.sdb.RowSet")

DatabaseContext.DataSourceName = "Newdb7"
DatabaseContext.User="3ev2"
DatabaseContext.Password="3ev2"

dim insertToDB
dim txtname
dim SQLStatement
dim Result


SQLQuery="insert into uday(newschannel,language) values ('etv7','tamil')"

InsertDBContext=createUnoService("com.sun.star.sdb.DatabaseContext")
DataSource=InsertDBContext.getByName("Newdb7")
ConnectToDB=DataSource.GetConnection ("3ev2","3ev2")
SQLStatement=ConnectToDB.createStatement
msgbox SQLQuery
Result= SQLStatement.executeQuery(SQLQuery)
ConnectToDB.close
ConnectToDB.dispose()

end sub



i don't know whats wrong with this?? can anybody please help me??

thanks in advance

[Villeroy]

This is exactly what database forms are made for.