Re: Disappearing records in VB/Oracle

you don't post your code but the obvious place to start is to ask if you are committing in sql*plus?

i.e.

>insert into dept (deptno) values(1);
 

>1 row inserted

will not appear in VB because the insert has not been committed.

however ODBC autocommits so the same insert statement in vb actually becomes

insert into dept (deptno) values(1);
commit;

regards (and sorry if i'm teaching my proverbial grandparent.

--
Niall Litchfield
Oracle DBA
Audit Commission UK


"Arne Rasmussen" <arr_at_wanadoo.dk> wrote in message
news:98qnag$4er$1_at_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

>

>