[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

VB6/TDBGrid Problem---Answer wanted immediately!!

I am using a TDBGrid Control bound to an ORADC Control.Now, there is a problem when I try to update anything but the first record in the grid and VB simply crashes!(Invalid page fault).In order to verify this I used the VBDataForm Wizard and sure enough the error trapped read "Insufficient base table information for updating or refreshing".I have no idea why this happened as this problem has surfaced only recently!I do know ADO has a problem using adUseClient cursors but if I do it in my code and use a adUseServer cursor it works fine but then the Set ADO.Recordset=res
where res is my created recordset doesnt work! How do I get around this problem??? Anyone???
0
rurajase
Asked:
rurajase
1 Solution
 
majed100598Commented:
Dont worry , i face the same problem
The only way to solve this by adding new code which is blank
and set it to be the first item

for example
the code table is
create table code_tb (code1 number(2),
code2 number(3),
name varchar2(30));

insert into code_tb values (1,-1,'sex data');
insert into code_tb values (1,0,'');
insert into code_tb values (1,1,'male');
insert into code_tb values (1,2,'female');
create view code_view as select code2,name from code_tb where code2<>-1;

if you face any problem contact me

0
 
rurajaseAuthor Commented:
I am sorry but are u intending to say that I should modify the structure of the table in Oracle from which I read data into my ORADC data control??Well if that is the case then I'm sorry it's beyond the scope of my project!
Thanx anyways!
Anyone else???
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now