By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

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

P: 21
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
Mar 26 '07 #1
Share this Question
Share on Google+
1 Reply


debasisdas
Expert 5K+
P: 8,127
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
Mar 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.