Disappearing records in VB/Oracle

From: Arne Rasmussen <arr_at_wanadoo.dk>
Date: Thu, 15 Mar 2001 16:32:29 +0100
Message-ID: <98qnag$4er$1@news.inet.tele.dk>

Hello there
Im about to develop a C/S solution with Oracle 8.1.6 and VB, and i've experienced somthing - for me - extremely odd. I created 3 rows with Oracle sql*plus and they are quit visible in a select, then i tried to see them in VB's SQL-Builder with a select ...with no result....then created 2 rows in VB's SQL-builder, and these are visible in both Oracle SQL*Plus and in VB....but in VB i can only see the rows created with sql-builder not the one's created with SQL+.
The table only consist of 2 fields an ID (number wich is generated by a sequense and a trigger before insert), and a char(10)

I'm about to go nuts due to this problem ....somebody please help me

Kind regards

Arne Rasmusssen Received on Thu Mar 15 2001 - 09:32:29 CST