Re: Disappearing records in VB/Oracle

Try doing a COMMIT......

Arne Rasmussen wrote:

> 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 Sat Mar 17 2001 - 12:47:59 CST