Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL

Status
Not open for further replies.

stallion

Programmer
Feb 22, 2000
14
GB
hi<br>
i have been asked to produce a telephone using VB6, i have only one problem, i have an address book facility where the name, number and address is entered into 3 separate text boxes and enterd into an Access 97 table via a recordset. I need to produce an SQL statement which will search the address book for the name belonging to the number that has just been dialed. This is a project i have been set and the reason this question sounds confusing is because the Examination Board that set this question are absolute idiots, who don't seem to know a thing about computing.<br>
thanks
 
if you just want the string<br>
&quot;select * from Table where Name = '&quot;& TheNameToSearch &&quot;'&quot;<br>
<p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML, ASP(somewhat), QBasic(least i didnt start with COBOL)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top