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"
It gives a runtime error on the last line telling me eather that the
Field or the Table does not exist unless I had created the table and all
the fields inside using capital letters, like MYTABLE, MYFIELD1,
MYFIELD2, and of course if I also had capitalised the names in the
executeQuery call.
Can anyone reproduce this?
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST M$ ATTACHMENTS
/ \
Manolis Christodoulou MD.
http://mobi-doc.com
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
