Dna Po 25. Apr�l 2005 22:33 Wolfgang Schaible napisal:
> hi,
>
> Can't find a recipe,
> everybody seems to be proud to write about mySQL, dBase, ...
> and not about the internal DB.
>
I have something like that:
Dim DatabaseContext As Object
Dim DataSource As Object
Dim Connection As Object
Dim InteractionHandler as Object
Dim Statement As Object
Dim Resultset As Object
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
DataSource = DatabaseContext.getByName("NAME OF MY .ODB FILE")
Connection = DataSource.GetConnection("","")
Statement = Connection.createStatement()
Resultset = Statement.executeQuery("SELECT field FROM table")
Everything is OK but Statement.executeQuery does not work because of problems
with capitals. I get error message that table "TABLE" is not found. With
querry designer such select statemets work well.
I hope this bug will be soon solved because it is only about HSQLDB.
juraj
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
