Hi,
You can use pass-through queries with parameters. You have to edit the
pass-through querydef at run-time before opening it, and it works. That's fine
if you want to use this query as a datasource for a form or a report.
Sub search_store(query As String, p As String) On Erro
Many thanks to Philippe Lang and Hervé Inisan for
all these very interseting tips !
I've solved all my problems...
Best regards.
Luc
- Original Message -
From:
Ets ROLLAND
To: pgsql-general@postgresql.org
Sent: Thursday, May 12, 2005 5:28
PM
Subject: [GENERA
Hello !
I try the update to PG 8.0.3 win32, but the archive is corrupted !?
I obtain the same thing from all the mirrors where I connect...
How can I obtain the new Win32 release ?
Luc
- Original Message -
From: "Neil Conway" <[EMAIL PROTECTED]>
To: "Marc G. Fournier" <[EMAIL PROTECTED]>
C
Hi
Why not take a look at Rekall - http://www.totalrekall.co.uk. Rekall is a
RAD tool for building database applications. It is similar to both
FileMaker and MS Access but costs a faction of the price. Rekall supports
PostreSQL natively as well as several other database engines. An ODBC
interfa
Kurt Gibson wrote:
> One important solution I created in Filemaker Pro requires very
> detailed and exact replication of official court forms with database
> data entered on the forms. Imagine a form with small type, boxes and
> spacing that must be exactly as on the official form and data from
>
I have a table to store localization information:
CREATE TABLE Localization (
...
zipcode TEXT NOT NULL,
...
country INTEGER REFERENCES Countries (id) NOT NULL
The table Countries is like:
CREATE TABLE Countries (
id SERIAL UNIQUE,
name TEXT UNIQUE NOT NULL,
code CHAR(2) UNIQUE NOT NULL);
Ciao!
Is it possible to get the number of rows that would have been
returned if the LIMIT-clause weren't present in some way after the
query was run?
Reason for asking is that I have a really big chunk of SQL, which
takes time to execute, and whoose result is paginated using a LIMIT-
claus
Hi,
Our FC2 x86_64 bit FC2 packager (Joe Conway) is on a long trip; I'm not sure
that we will be able to prepare RPMs for that arch/distro right now :(
However, if someone can step up the plate for that, I can send the guidelines
about building the RPM from SRPM...
Regards,
--
Devrim GUNDUZ
Ciao again!
I just ran into a huge problem with the functions upper and lower…
It turns out, that when converting the case of foreign characters,
like åäö, they stay as they were from the beginning…
Example:
SQL = select 'test åÄöØ', upper('test åÄöØ'), lower('test åÄöØ')
Result:
?column?upp
On Fri, May 13, 2005 at 11:57:08AM +0200,
Stephane Bortzmeyer <[EMAIL PROTECTED]> wrote
a message of 49 lines which said:
> I have 240 countries in the database. Because of a programming error,
> contacts were entered with a country > 240. I thought that the
> "REFERENCES Countries (id)" should
I do the same thing with DAO and changing my querydef at run time, but I've
added a few 'enhancements'. First, I use a DSNLess connection - that way I
don't have to set up a DSN on each client's PC. Check out
http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-accessvba for
more in
Victor Spång Arthursson wrote:
Ciao!
Is it possible to get the number of rows that would have been returned
if the LIMIT-clause weren't present in some way after the query was run?
Reason for asking is that I have a really big chunk of SQL, which takes
time to execute, and whoose result is p
Is there a reason that the windows code page 1252 is not supported?
The encoding Latin1 would be the most appropriate, but 1252 is a
superset of ISO8859-1 and supports more characters, and when I want to
write them through odbc I get an error.
psqlodbc 8 converts everything to utf-8 and then send
Richard Huxton wrote:
Victor Spång Arthursson wrote:
Ciao!
Is it possible to get the number of rows that would have been
returned if the LIMIT-clause weren't present in some way after the
query was run?
Reason for asking is that I have a really big chunk of SQL, which
takes time to execute,
You could also open a transaction and
SELECT FOR UPDATE.
So a second transaction can't Select the same data for update. That
works fine. (You can try in with pgsql too).
Daniel
Philippe Lang schrieb:
Hi,
I've been testing Delphi 2005 with Postgresql 7.4.5, through ZEOS Lib 6.5.1,
and I have a qu
13 maj 2005 kl. 14.45 skrev Richard Huxton:
Richard Huxton wrote:
Victor Spång Arthursson wrote:
Ciao!
Is it possible to get the number of rows that would have been
returned if the LIMIT-clause weren't present in some way after
the query was run?
Reason for asking is that I have a really bi
Hi,
I just downloaded postgresql-8.0.3.zip from all US and
Canada mirror site and they all had corrupt archive
error. I ran the GPG to verify that the sig. was bad.
Is anybody know what going on?
Thanks,
sn
__
Do You Yahoo!?
Tired of spam? Yah
Hi,
I migrated my db from postgresql 7.4.6 to 8.0.2 but I'm not able to make plsh
functions working.
I installed plsh ver. 1.0-7.3 after having installed postgresql 8.0.2 rpms for
fedora core 2.
I used the same, succesfull, install procedure I used on postgresql 7.4.6.
Every time I try to run a pl
Hello Oleg Bartunov,
Oleg Bartunov schrieb:
> On Thu, 12 May 2005, Peter Schmelzer wrote:
>
>> Hi,
>>
>> this is an answer of thread
http://archives.postgresql.org/pgsql-general/2003-08/msg00694.php
>>
>> You say it exist a funktion to fin positions an frequency of lexems
for own calculate of an
Hi
I've downloaded the zip binaries of postgresql 8.0.3 from some of the
mirrors.
All of the dowmloaded files are corrupt.
With best regards.
--
Mario Günterberg
mattheis. werbeagentur
IT Engineer / Projektleiter
Zillestrasse 105a. D - 10585 Berlin
Tel#49-(0)30 . 34 80 633 - 0
Fax#49-(0)30 .
> Is there a reason that the windows code page 1252 is not supported?
> The encoding Latin1 would be the most appropriate, but 1252
> is a superset of ISO8859-1 and supports more characters, and
> when I want to write them through odbc I get an error.
> psqlodbc 8 converts everything to utf-8 and
""Philippe Lang"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> Yes, I'm sure this kind of feature is application-based. There is nothing
> in the driver itself. If I'm not wrong, MS Access uses a timestamp column
> to check if the record was updated meanwhile, or the col
On Fri, 13 May 2005, [ISO-8859-1] Victor Spång Arthursson wrote:
> Ciao again!
>
> I just ran into a huge problem with the functions upper and lower
>
> It turns out, that when converting the case of foreign characters,
> like åäö, they stay as they were from the beginning
To help people try to
""Zlatko Matic"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I was using ADO command object and both refresh method and method with
>creating parameter object while working with Access Project...but I didn't
>try to use it with PostgreSQL...
> I would rather like to have all que
Magnus Hagander wrote:
Is there a reason that the windows code page 1252 is not supported?
The encoding Latin1 would be the most appropriate, but 1252
is a superset of ISO8859-1 and supports more characters, and
when I want to write them through odbc I get an error.
psqlodbc 8 converts everythin
Hello everyone,
I guess I'm not typing in the right search string for my question
because I can't find any answer on the Internet. So I'm coming to all
of you for help.
I'm performing a cross-tab type query in PostgreSQL where the returned
data in rows become my column names. The problem I'm faci
Alex Turner wrote:
> No.1 Python does not scale well.
> map x=new map();
Whatever that may mean. Reminds me why I deliberately forgot all of C
right after the final test of that class at university.
> vs
> self.d={};
Beep.
Go back to my initial article and read what I wrote. And try to
underst
Yes I had that same experience last evening, I was going to write about that
today. But I second your thoughts !
Luc ROLLAND wrote:
Hello !
I try the update to PG 8.0.3 win32, but the archive is corrupted !?
I obtain the same thing from all the mirrors where I connect...
How can I obtain the new
On Fri, May 13, 2005 at 10:07:43AM -0600, Darren Houston wrote:
> Hello everyone,
>
> I guess I'm not typing in the right search string for my question
> because I can't find any answer on the Internet. So I'm coming to all
> of you for help.
>
> I'm performing a cross-tab type query in PostgreSQ
Darren Houston <[EMAIL PROTECTED]> writes:
> PostgreSQL is truncating the column names down to 63 characters, and
> some of my names need to be a little larger than that. Is a 63 column
> name length a limit in PostgreSQL, or is there a
> setting/function/compile time option I can enact to overcome
Hi,
I have an app that I released with a particular field
as varchar 255.
Can someone give me a script example I can use to make
an upgrade script to change it to text or at least to
larger varchar without losing existing data?
I support 3 different dbs in my app, Postgre is the
newest and least
Hello Tom and Alvaro,
The solution you guys provided is exactly the answer I needed.
Thank you for your help and saving me time,
Darren H.
On 5/13/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> On Fri, May 13, 2005 at 10:07:43AM -0600, Darren Houston wrote:
> > Hello everyone,
> >
> > I guess
Something like
BEGIN;
LOCK table_name;
ALTER TABLE table_name RENAME col_a to col_a_old;
ALTER TABLE table_name ADD COLUMN col_a text;
UPDATE table_name SET col_a=col_a_old;
ALTER TABLE table_name DROP COLUMN col_a_old;
COMMIT;
If you have any referential integrity on the column, you'll have to mes
Joe Audette wrote:
Hi,
I have an app that I released with a particular field
as varchar 255.
Can someone give me a script example I can use to make
an upgrade script to change it to text or at least to
larger varchar without losing existing data?
I support 3 different dbs in my app, Postgre is the
On Mon, May 09, 2005 at 12:58:06PM -0700, Dann Corbit wrote:
> Temp tables go away after the transaction completes.
Connection, actually, no?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greensp
Right. I should have said "session".
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Andrew Sullivan
> Sent: Friday, May 13, 2005 11:47 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] WHERE
>
> On Mon, May 09, 2005 at
On Fri, May 13, 2005 at 10:34:34AM -0700, Joe Audette wrote:
> Hi,
>
> I have an app that I released with a particular field
> as varchar 255.
If you're using PostgreSQL 8, there is an option to ALTER TABLE that
does this. The docs on ALTER TABLE including man alter_table have
examples :)
Cheer
On Fri, 13 May 2005 06:39 pm, [EMAIL PROTECTED] wrote:
> Hi,
> I migrated my db from postgresql 7.4.6 to 8.0.2 but I'm not able to make plsh
> functions working.
> I installed plsh ver. 1.0-7.3 after having installed postgresql 8.0.2 rpms for
> fedora core 2.
> I used the same, succesfull, install
38 matches
Mail list logo
