DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

check initial charecters of a text...

Thread Solved

•

Join Date: Aug 2008

Posts: 53

Reputation: smile4evr is an unknown quantity at this point

Solved Threads: 2

smile4evr

Offline

Junior Poster in Training

check initial charecters of a text...

Nov 11th, 2008

hi... i have a small doubt in hw to check the initial charecters in text... like if the first two letters of my text is OS or TP... so based on that i should be able to select which database to select...
and one more doubt is dat suppose i want to check the status of a request then the corresponding details of that id only should open.. so do i need a multiple select statement... or is it possible to have select statement for more than one field???

please reply!

thanking in advance!

•

Join Date: Dec 2007

Posts: 45

Reputation: AUGXIS is an unknown quantity at this point

Solved Threads: 11

AUGXIS

Offline

Light Poster

Re: check initial charecters of a text...

Nov 12th, 2008

hi. you can left command

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
If Left(Text1.Text, 2) = "OS" Then
    rs.open"select * from table"
Elseif Left(Text1.Text, 2) = "TP" Then
    rs1.open"select * from table1"
else
    rs2.open"select * from table2"
end if
If Left(Text1.Text, 2) = "OS" Then
    rs.open"select * from table"
Elseif Left(Text1.Text, 2) = "TP" Then
    rs1.open"select * from table1"
else
    rs2.open"select * from table2"
end if

•

Join Date: Aug 2008

Posts: 53

Reputation: smile4evr is an unknown quantity at this point

Solved Threads: 2

smile4evr

Offline

Junior Poster in Training

Re: check initial charecters of a text...

Nov 12th, 2008

hi the left command worked perfect.... can you please clarify my other doubt also... that is if we can select multiple fields from a dabase and show it at the VB front end???

•

Originally Posted by AUGXIS

hi. you can left command
Help with Code Tags

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
If Left(Text1.Text, 2) = "OS" Then
    rs.open"select * from table"
Elseif Left(Text1.Text, 2) = "TP" Then
    rs1.open"select * from table1"
else
    rs2.open"select * from table2"
end if
If Left(Text1.Text, 2) = "OS" Then rs.open"select * from table" Elseif Left(Text1.Text, 2) = "TP" Then rs1.open"select * from table1" else rs2.open"select * from table2" end if

thanx a lot for the help!!!

•

Join Date: Dec 2007

Posts: 45

Reputation: AUGXIS is an unknown quantity at this point

Solved Threads: 11

AUGXIS

Offline

Light Poster

Re: check initial charecters of a text...

Nov 12th, 2008

hi. just select the field you're gonna use.

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
rs.open"select emp_name, emp_address from tbl_emp"
text1=rs.fields("emp_name")
rs.open"select emp_name, emp_address from tbl_emp"
text1=rs.fields("emp_name")