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.
Thanks
>From: montana@ccs.neu.edu <montana@ccs.neu.edu>
>To: instantdb@smartcard.co.uk <instantdb@smartcard.co.uk>
>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?
>>
>>Thanks
>>
>>
>>
>>
>>Tony Iosifidis
>>montana@ccs.neu.edu
>>http://www.ccs.neu.edu/home/montana
>
>
To unsubscribe from this list, please an send
email to 'majordomo@smartcard.co.uk' with the text
'unsubscribe instantdb' in the message body.
|