Well, you don't say what tool(s) you're using to create, insert, and then
view the data, but it sounds like, that after to insertion of the data,
before you quit the database, you're not committing the transaction.. When
you "quit" the database, you're getting an automatic rollback of the
transaction.


Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>



-----Original Message-----
From: raxyshah [mailto:raxyshah@...]
Sent: Thursday, May 01, 2003 1:55 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] insert statement problem


hi guys,

i am stuck up in a strange problem.
i am creating a database/table...i than try to insert about 10 lines
into that table...i just check it out with the select staement to
find whether my rows have been inserted....i than quit the
database....

i try to again logon to the database...i query the database with
select statement......and to my surprise i find that that all my
tables are empty...!!!

am i missing any parameters while creating the database...
i just created it using create database name user username password
password;

plz reply,
thanks

Raxit



Yahoo! Groups Sponsor




<http://us.adserver.yahoo.com/l?M=247865.3003379.4507215.1261774/D=egroupmai
l/S=:HM/A=1482387/rand=842081898>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]