Solved

Logic in IDC&HTX

Posted on 1997-03-13
1
181 Views
Last Modified: 2013-12-25
I want to use logic SQL (and,or,not)in my IDC file
ex. In the library,I want to search "microprocessor&computer"
or "Introduction NLP",but library'database has "Introduction  to NLP"
    my original source code is
    select *
    from book
    where call_no like '%%%call_no%%%'
   
    How can I do?
    Thank you...
     
   
0
Comment
Question by:Donald021997
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 4

Accepted Solution

by:
jshamlin earned 30 total points
ID: 1853875
The precise syntax depends on the server you're using (the examples below works on MS SQL Server, but may not work elsewhere)

For a simple if/else, it's ...
+if ([test_condition])
+[commands_to_perform]
+else
+[commands_to_perform]

if the logic depends on the content of the records, you need to

SELECT
+WHERE [condition]
+AND [condition]  --optional--

For a NOT, you can alter the syntax of the AND condition

To be honest, I've never found a need for an OR - but if OR doesn't work, you should be able to repeat the WHILE and add a different condition - the records should be used in addition to those selected by the first WHILE (which is, essentially, what an OR does)
0

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question