Hi Travis,
I know this is not what you're asking for, and I
imagine you have already thought of this, but just
in case . . .
You could add an extra column to each of your
tables. These columns would be populated by a
procedure that runs through the existing recordset
and assigns sequential numb
Hi Mihai,
Microsoft products store false as (0) and true as
(-1) (Why? I don't know!). Apparently storing a
(-1) requires more than bool provides. So, you
can either edit all of your Access code so that it
interprets (1) as true (practically, I don't
recommend this), or you can migrate your yes
www.postgresql.org
select Info Central
select Documentation
select Integrated Document
select I - 19 ALTER TABLE
ALTER TABLE
ADD COLUMN
-Original Message-
From: Steven <[EMAIL PROTECTED]>
To: Postgres-Gen List
<[EMAIL PROTECTED]>
Date: Monday, July 17, 2000 1:28 PM
Subject: [GENERAL] Addi
Hi Jeffrey,
If you open a form that is bound to a table (or bound to a query that is
bound to a table) that is one database connection. If you then script
database updates from the form
(e.g.:
Dim dbs As Database
Set dbs=CurrentDB
dbs.Execute("UPDATE tbl_blah SET szBlah = 'blah' WHERE nBlahID =
I think the problem is that nobody wants to say "Oh yeah, solid as a rock!"
and then have someone die as a result of a database error. However, I have
personally witnessed unrepeatable database errors in both MSSQL and Oracle.
Those databases both have marketing departments widely touting them as
By asking about missing something fundamental, you have invited
less-than-expert feedback (i.e. feedback from me).
'adding a record doubles the retrieval time' makes it sound as though
somewhere in your query to populate the grid control you are requiring a
combinatorial operation (that is, "comp
I forgot the punch line:
If you are requiring some sort of combinatorial operation, you might
consider restructuring your query or doing some of the query's work
programmatically.
David Boerwinkle
-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: Robert Wagner <[EMAIL PR
Occasionally a question is posted to this list
that is not a question about postgres, but to which I know the answer.
When this happens, I usually reply only to the person who posted the question,
rather than to the whole list. I do this to minimize non-postgres traffic
on the list. Howe
The advantage of (3) is that it would be extremely easy to write an
application around. However, the inflexibility of it makes my stomach
tighten. I agree with kaiq, I think you're making a mistake.
David Boerwinkle
-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: Barn
I didn't say you could write a good application.
David Boerwinkle
-Original Message-
From: Ed Loehr <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; Barnes <[EMAIL PROTECTED]>;
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, Febr
Hi Lincoln,
I'm not sure I'm understanding your question, but it seems like this is
something that
ought to be handled programmatically. That is, query the table to see if
the row exists,
then decide what you are going to do (insert or update) based on the results
of your
query.
Am I completely
Richard,
For constraints see:
http://www.postgresql.org/doxlist.html
then select Documentation
then select Integrated Document
then select Alter Table
For Column definitions:
I believe some other implementations of SQL allow you to alter
columns as long as you are keeping the same basic datatype
12 matches
Mail list logo
