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]
