selection criteria in Access query not working Post: 302301624

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Export Query not Working in Shell

I am exporting data using a shell program. I am getting all of the records instead of getting a subset based on my query. The export_problem.par lists all of my tables. I tried the query with the ' and without it. How do I get the export to use the query? Thanks! ...

2. UNIX for Dummies Questions & Answers

Remote Access to FTP server not working

I am trying to setup an FTP server in a Fedora Core 3 machine through the command line interface and not KDE. I think I am successful in getting the ftp service running, as when I do an ftp 127.0.0.1, I am able to log in using any one the user accounts I have created on this machine and browse...

3. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1...

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

5. UNIX and Linux Applications

MYSQL: Help understanding this working query

Hi there, I have a query that works just fine, but im having a little problem understanding how it works and have been struggling to find any docs that explain the techniques that are being used. If anybody out there could explain how this is put together then that would be great I have three...

6. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

7. Shell Programming and Scripting

If Selection statement

ok im kinda stuck i have a bash script with 4 options 1. Create Script 2. Show Script 3 . Delete script 4. Exithow would i use an if statement for this? im not sure what test command i would use. I know it would be like this (below) to display the script if then cat script1or for the...

8. Shell Programming and Scripting

awk not working for calculating no of lines with criteria

I have tar.gz file and i want to count the lines which are matching the criteria as well as which are not matching the criteria. Following is the code Output Requirement: Match the input from zcat with 26th filed having 02 value, in case it matches then print the output in a file & increase...

9. Red Hat

Root Access not working as FileSystem in ReadOnly Mode

Hi Experts I am facing a problem wherein Root Access not working as FileSystem in ReadOnly Mode. Due to a Disk failure, my Filesystem went into Read-Only mode: report@xx> grep root /proc/mounts /dev/root / ext3 ro,data=ordered 0 0 Now, I am not able to login using root user on the...

LEARN ABOUT BSD

selecttool

SelectTool(3U)						    InterViews Reference Manual 					    SelectTool(3U)

NAME

       SelectTool - tool for modifying an editor's current selection

SYNOPSIS

       #include <Unidraw/Tools/select.h>

DESCRIPTION

       SelectTool lets a user change the current selection by direct manipulation, thus affecting the enclosing editor's selection object.  A sin-
       gle click directly on a component view selects that view and unselects all others.  Clicking while holding the Shift key down adds the tar-
       get component to the selection if it was not already selected and removes it if it was selected.  The user can select all components within
       a rectangular area in the viewer by clicking somewhere outside the nearest component and dragging to specify  the  rectangular  area.   All
       components completely within the area will be selected.

PUBLIC OPERATIONS

       SelectTool(ControlInfo* = nil)
	      Create a new SelectTool.

       virtual Manipulator* CreateManipulator(
	  Viewer*, Event&, Transformer*
       )

       virtual void InterpretManipulator(Manipulator*)
	      If  the user did not click on a component, then CreateManipulator creates a DragManip with a RubberRect for dragging out a rectangu-
	      lar area.  Otherwise, CreateManipulator clears the editor's selection and selects the hit component.  If the user  holds	the  Shift
	      key down in either case, the components that would have otherwise been selected will be unselected, and vice versa.  InterpretManip-
	      ulator will only be called if CreateManipulator returned a non-nil manipulator; in this case InterpretManipulator will  examine  the
	      DragManipulator's RubberRect and select the component views falling completely within it.

PROTECTED OPERATIONS

       virtual void Localize(Selection*, Viewer*)
	      Localize	ensures  that the given selection object contains only those views displayed in the given viewer.  CreateManipulator calls
	      this function to avoid possibly shift-selecting views from different components.

SEE ALSO

       Editor(3U), Rubband(3I), Selection(3U), Tool(3U), Viewer(3U), manips(3U)

Unidraw 							  24 January 1991						    SelectTool(3U)