Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 06-11-2009
Member
 
Join Date: Nov 2009
Posts: 610
Possibility to filter the records in a Database

Hi,
How to study the possibility to filter the records in order to recover only those that meet predefined conditions in a database. I am looking for the appropriate solution for the same. I need some suggestion for exploring the possibilities to filter the records in order to recover only those that meet predefined conditions. Also what are the possibilities to combines records with identical values in the list of fields specified in a single record. Thanks of any suggestions.
Reply With Quote
  #2  
Old 06-11-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: Possibility to filter the records in a Database

Before the implementation of this paragraph must emphasize three vital details. The first is that every time you want to set a condition referred to a text field, the search condition must be enclosed in single quotes, the second is that it is possible to set search conditions and in memo fields, the third and last reference to the dates. To the date I have not been able to find a syntax that works on all systems, so it is necessary to particularize the database as:
Data Bank - Syntax
SQL-SERVER - Date = # mm-dd-yyyy #
ORACLE - Date = to_date ( 'YYYYDDMM', 'yyyymmdd',)
ACCESS - Date = # mm-dd-yyyy #
Reply With Quote
  #3  
Old 06-11-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: Possibility to filter the records in a Database

Logical operators are supported by SQL: AND, OR, XOR, Eqv, Imp, and Is Not. Except for the last two all possess the following syntax: <expresi?n1> operator <expresi?n2>. Where expression1 and expression2 are the conditions to assess the outcome of the operation varies according to the logical operator. To indicate that we want to retrieve the records according to the range of values in a field we use the Between operator whose syntax is: field [Not] Between value1 And value2 (Not condition is optional). In this case the query would return records containing the "field" value included in the interval value1, value2 (inclusive). Not provided by preceding return those values outside the range.
Reply With Quote
  #4  
Old 06-11-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: Possibility to filter the records in a Database

Logical operators are supported by SQL: AND, OR, XOR, Eqv, Imp, and Is Not. Except for the last two all possess the following syntax: <expression1> operator <expression3>. Where expression1 and expression2 are the conditions to assess the outcome of the operation varies according to the logical operator. To indicate that we want to retrieve the records according to the range of values in a field we use the Between operator whose syntax is: field [Not] Between value1 And value2 (Not condition is optional). In this case the query would return records containing the "field" value included in the interval value1, value2 (inclusive). Not provided by preceding return those values outside the range.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Possibility to filter the records in a Database"
Thread Thread Starter Forum Replies Last Post
How to fetch records from multiple tables in a database ? kALAMATHI Software Development 4 29-12-2010 07:56 AM
How to Extract records from Mysql database using JTable StudyBoy Software Development 3 08-04-2009 06:22 PM
RECORDS - Loss data and the possibility of recovery Baser-X Technology & Internet 5 03-03-2009 06:36 PM
Picollator filter : Automatic adult content filter monsitj Windows Software 1 29-01-2009 07:07 PM
How to Extract Particular Records from the Database? Sukhvinder Software Development 2 26-01-2009 06:28 PM


All times are GMT +5.5. The time now is 12:27 PM.