13 databases on one control

[Ali Rizwan]

Hi
I want to fetch databases according to class no using one control.
I have done it but sometimes an error has occured. I have used this code in change property of txtbox

adodc1.commandstring=Jet Provider + database name ...

is there anyone better
Thanx

[QVeen72]

Hi,

Write the Code in txtClass_Validate or txtClass_LostFocus Event of the Text Box. If u write in Change Event, It keeps on Opening the DB for every key press.. better Give a ListBox of All the available Classes, and write code in LostFocus of ListBox

Regards
Veena

[Ali Rizwan]

Hi,

Write the Code in txtClass_Validate or txtClass_LostFocus Event of the Text Box. If u write in Change Event, It keeps on Opening the DB for every key press.. better Give a ListBox of All the available Classes, and write code in LostFocus of ListBox

Regards
Veena

Thanx for reply.
I m using combo box also but the problem is in updating data. It occurs an error of
"Multiple steps occurs errors" some thing like this.
otherwise databses are opening properly.

[QVeen72]

Hi,

"Multiple Step Generation Error" is usually due to the Change in Datatypes in DB and front end, It can occur in such Conditions:

IN DB Text Length is 10 and u r trying to save string Length >10
In DB, Field is a Date Field, u r trysing to save a Non-date Field
OR it is of Integer and u r trying to store value>32k
Or else, there is a Violation of Foreign/Primary Key

Regards
Veena

[Ali Rizwan]

Hi,

"Multiple Step Generation Error" is usually due to the Change in Datatypes in DB and front end, It can occur in such Conditions:

IN DB Text Length is 10 and u r trying to save string Length >10
In DB, Field is a Date Field, u r trysing to save a Non-date Field
OR it is of Integer and u r trying to store value>32k
Or else, there is a Violation of Foreign/Primary Key

Regards
Veena

Thanks Veena
I checked and foun i am trying to enter string in integer format field.
Thanx again