Member Avatar for smile4evr

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!

  • 2 Contributors
  • 4 Replies
  • 231 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by smile4evr
Member Avatar for AUGXIS

hi. you can left command

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
Member Avatar for smile4evr

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???

hi. you can left command

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!!!

Member Avatar for AUGXIS

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

rs.open"select emp_name, emp_address from tbl_emp"
text1=rs.fields("emp_name")
Member Avatar for smile4evr

hey thankx a lot... it worked great!.....
THANKX A LOOOTT!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.