Datagrid Problem ..please help its urgent!

[Whitebat]

hello, i'm working with vb6 on a windows nt machine.
i have to oracle databases which both have a table called miscfiles.
i'm using an adodc control and a datagrid. by clicking on a button you can change between the two databases and as a fact you can see then the miscfiles belonging to the database in the datagrid. My problem is if there's no record in either on or both miscfiles i then can add a record to one but when i click on the button to get to the other database and add their records too the datagrid says : the current row is not available .... %-(
Is there any way to fix it ?
thanx for your help
bye

 

[Morpheus1981]

Well I don't understand very well ur problem but maybe this can help:
Try to check if the record count on ur miscfiles is > 0 then if so
One: do not let the user to access the object or
Two: add it byurself.

If u explain me better ur problem like telling me which is the relation between the databases and the tables(miscfiles) why do they have to be related?, when? and which are the rules that must be apply, I will do my best to help you mail me fdalorzo@costarricen.com or dalorzo@hotmail.com

 

[Whitebat]

thanxs for your help.... i programmed it in an other way ....
ps. the problem has nothing to do with the database just with the functionality of a microsoft datagrid