Re: Disappearing records in VB/Oracle

Problem solved

Regards
Arne Rasmussen

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:98qqjo$4ps$1_at_soap.pipex.net...
> 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
> >
> >
>
>
Received on Fri Mar 16 2001 - 01:45:18 CST