Solved

Logic in IDC&HTX

Posted on 1997-03-13
1
177 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
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
The viewer will learn how to count occurrences of each item in an array.

831 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