Dňa So 27. Január 2007 21:10 Manolis Christodoulou napísal:
> I have a Base (HSQLDB) file with table MyTable(MyField1, MyField2).
> I have a form in that ODB file to display MyTable.
> The following code in the form will not work:
>
> Dim conn as Variant
> Dim stat as Variant
> Dim rs as Variant
> conn=ThisComponent.Parent.DataSource.GetConnenction("","")
> stat=conn.createStatement()
> rs=stat.executeQuery("SELECT MyField1 FROM MyTable"
>
Did you try something like
rs=stat.executeQuery("SELECT ""MyField1"" FROM ""MyTable"")
When I used OOo SQL builder (in main menu - Tools- SQL) with embedded HSQLDB
database I had to write "table" and "field" instead of table and field. With
other databases I did not have to use ". Maybe this is the same problem.
juraj
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
