I've gotten my experiment database build as it should be. Does the
documentation explain technique(s)
to issue a select/where outside of the base environment, that is, a sql form
from the desktop?
On Mon, Apr 21, 2008 at 2:08 PM, Drew Jensen <
[EMAIL PROTECTED]> wrote:
> Evan Carlisle wrote:
>
> > All commands completed successfully as is; thanks.
> > I tried another list of commands for practice:
> > These each worked except for the select -- I couldn't find any output.
> > I also couldn't find 'basic_table2' listed in the database table window.
> >
> > ------------------------------------------------------------------------------------------------------------------------------------------------------
> > CREATE TABLE "basic_table2" (
> > "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL
> > PRIMARY
> > KEY,
> > "col" VARCHAR(30) NOT NULL,
> > "person" VARCHAR(30) NOT NULL,
> > "theme_park" VARCHAR(30) NOT
> > NULL,
> > );
> > INSERT INTO "basic_table2" ("col", "person", "theme_park" )
> > VALUES( 'disney', 'elmer j phud', 'epcot' );
> > select 'col' from 'basic_table2';
> >
> > ------------------------------------------------------------------------------------------------------------------------------------------------------
> >
> >
> >
> Hello Evan,
>
> The SQL window under Base is specifically designed not to display any
> results, beyond possible error statements.
>
> For executing SELECT statements you must use a Query definition. When you
> create or edit a query under Base you can choose from any of 3 modes.
> The GUI query designer
> Text based with escape processing enabled. ( most often used to have the
> application prompt for a value in a parameter. i.e. SELECT * from Table
> WHERE SomeField = ? )
> Text based with escape processing disabled. Referred to as SQL Direct in
> the UI. This allows you to create statements that the Base query analyzer
> can not deal with. ( a common use would be for example the use of a UNION
> between two select statement )
>
> HTH
>
> Drew
>
>
> --
> OpenOffice.org User Community Forum: http://user.services.openoffice.org
> United States PostgreSQL Association: http://www.postgresql.us/
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
