I've seemed to have solve my problem.
I think what it was is that I was using a
table that was created from an earlyier
version of instantDB. I created a new
table and my prolem vanished.
>From: firstname.lastname@example.org <email@example.com>
>To: firstname.lastname@example.org <email@example.com>
>Date: 10 November 1999 17:13
>Subject: commsql and "select" statement
>> I'm having trouble viewing entries in the a table that I have.
>> Here's the url I use jdbc:idb:db.prp
>> db.prp is the correct prp file
>> note: My table file is db.tbl
>> The table is called db and when I try to retrieve all the rows from
>>it I get an error. The error is as follows:
>>> main select * from db
>>>main java.sql.SQLException: Table not found: db
>>>java.sql.SQLException: Table not found: db
>>> at java.lang.Throwable.fillInStackTrace(Native Method)
>>> at java.lang.Throwable.fillInStackTrace(Compiled Code)
>>> at java.lang.Throwable.<init>(Compiled Code)
>>> at java.lang.Exception.<init>(Compiled Code)
>>> at java.sql.SQLException.<init>(Compiled Code)
>>> at db.SQLProg.compile_select(Compiled Code)
>>> at db.SQLProg.execute(Compiled Code)
>>> at jdbc.idbStatement.execute(Compiled Code)
>>> at commsql.main(Compiled Code)
>> When I do select * from db$db$tables I got some data
>>back but Im not sure what it is.
>> I basically want to just return all the rows in the
>>table. How do I do that?
To unsubscribe from this list, please an send
email to 'firstname.lastname@example.org' with the text
'unsubscribe instantdb' in the message body.