Unable to retriew the data beteen oracle and vb by using ADODC control i.e if a table

[pramodrepaka]

Hello Guys Plz Help me
Here is my problem .
Unable to retriew the data beteen oracle and vb by using ADODC control i.e if a table consists of Nll values.
i am created table and i got successful connection between oracle and VB6.0 .So i want to add some fields at vb and it should update in oracle(But not all fields) by using Addnew.
But it is not able to add some fileld.
But it is accepting all fields
In a table some fields may be null,when we retrieving that data in VB it is unable to retriew the data because of null values in table.
please help me if u can

[debasisdas]

When selecting the source instead of a table use the sql query to select the particular field by specifying the field names.

To retrive records check for ISNULL()

Try these two

Happy programming