On Mar 31, 5:01 pm, [EMAIL PROTECTED] (Derrick Betts) wrote:
(...)
> I'm not an expert, however, your SQL query may need the double quotes
> around the field names and table name. Your table definition created
> the field names and table names with double quotes, therefore your SQL
> query must ca
Jeanie Schwenk wrote:
Derrick,
Thank you for your input. I tried that, however, ir made no difference.
What I did try though was drop the database, close the application,
restart and then start from scratch following the same steps I did the
first time (setting everything up via the interfa
Derrick,
Thank you for your input. I tried that, however, ir made no difference.
What I did try though was drop the database, close the application, restart
and then start from scratch following the same steps I did the first time
(setting everything up via the interface). The problem is gone
Jeanie Schwenk wrote:
Thank you for your post Dave. To answer your questions, the encoding
is SQL_ASCII. Here are the database and table definitions as well as
the table's contents:
CREATE DATABASE "Scrip"
WITH OWNER = postgres
ENCODING = 'SQL_ASCII'
TABLESPACE = pg_default;
Thank you for your post Dave. To answer your questions, the encoding is
SQL_ASCII. Here are the database and table definitions as well as the
table's contents:
CREATE DATABASE "Scrip"
WITH OWNER = postgres
ENCODING = 'SQL_ASCII'
TABLESPACE = pg_default;
CREATE TABLE "organization"
[EMAIL PROTECTED] wrote:
Here's what I have done:
Installed postgresql 8.2 on XP Home (SP2)
Created a database
Created a table
Added two columns to the table (combined to make the key)
I then tried to add one row of data. I entered the text into both
columns. When I hit return, it crashed. T
Here's what I have done:
Installed postgresql 8.2 on XP Home (SP2)
Created a database
Created a table
Added two columns to the table (combined to make the key)
I then tried to add one row of data. I entered the text into both
columns. When I hit return, it crashed. The data is there when I
bri
