Perform Search

[sebell]

Hello,
I am trying to create a trouble shooting database where if someone types in a sentence, the database can pick up on key words and bring back all criteria with that or those key words.
In other words, I have a text box txtQuestion which the user types in the question. When the user clicks on the command button, how do I search based on every word used - in any order - and maybe put this into however many answers I get back.

Thank you in advance for you help and I hope this makes sense to you.

 

[fredericofonseca]

With COBOL files you read each record, and you search each individual field for the string you typed.

With a relational DATABASE (which COBOL files are not) you can do a "select * from tbl where fielx like "%abc%"" to return the records.

The second option can be done from most of the actual COBOL versions/vendors.

But you really need to give us more details about COBOL version, platform used, DB used if any, and other details you can think of.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[sebell]

I am using a Microsoft Access to create this.

 

[sebell]

I'm sorry, I thought I was posting this question in an Access form discussion forum. COBOl is way over my head. I'll post a this question again in the Access form discussion forum.
Thanks anyhow.

 

[MuadDubby]

Sorry - I just had to add this: I never thought I'd hear someone say that COBOL is above them. Don't get me wrong - I LOVE COBOL. I just don't think there's a simpler language out there ... (except perhaps Logo).

.DaviD.

 

[sebell]

Didn't see your last message, unfortunatley I only know VBA for Access and Excel which is why it is above my head. Maybe I should learn it instead.