conncetion string.
So, I should disable that option, but don't know which option is that ?
Where can I find description of these constants in connection string (A, B,
C)?
-
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Re-GENERAL-MS-Access-and-Stored-proce
ot;
Case Else
MsgBox "An error occured in the function 'TransferQueryToTable': "
& Err.Number & " " & Err.Description
End Select
End Function
++++++++++++++
Just thought I'd share in case it
all round coverage of Access development issues, including
client-server.
>
> Do you have form/subform/subform...based on stored procedures ? If so, how
> do you synchronize form with subform ?
>
>
> Greetings,
>
> Zlatko
>
>
> ----- Original Message -
&
;
Case Else
MsgBox "An error occured in the function 'TransferQueryToTable': " &
Err.Number & " " & Err.Description
End Select
End Function
++++++++++++++++++++++++++++++
Just thought I'd share in case it helps an
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
;, so using DAO is
not a problem, even if ADO is supposed to be the future... If you put logic on
the client, that's another problem maybe.
Philippe Lang
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Zlatko Matic
Envoyé : vendredi, 13. mai
--- Original Message -
From: "Hervé Inisan" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 12, 2005 11:06 PM
Subject: Re: [GENERAL] MS-Access and Stored procedures
Hello...This is very interesting. I have also asked myself
how to prepare and execute stored procedures on POstgre fro
> Hello...This is very interesting. I have also asked myself
> how to prepare and execute stored procedures on POstgre from
> MS Access.
> Could you, please, give some example of Postgre function with
> parameters that is executed as stored procedure from MS
> Access? How would you pass paramet
ADO Command object?
Greetings,
Zlatko
- Original Message -
From: "Hervé Inisan" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 12, 2005 6:15 PM
Subject: Re: [GENERAL] MS-Access and Stored procedures
How can I use stored procedures (functions) with MS-Access
2002 connect
> How can I use stored procedures (functions) with MS-Access
> 2002 connected to PostgreSQL 8.0 ?
An alternative to Philippe's solution is to use ADO.
Here is an sample function :
(assuming ActiveX Data Object lib is checked in the Tools/References menu)
Function ADO_PG()
Dim cnn As ADODB.Connec
Hi,
1) The simplest way to call a function from MS Access is to use a "pass-through
query", like:
SELECT * FROM public."search_article"();
2) If the parameter is/are dynamic, that's more complicated. You have to edit
the query at run-time, like with this kind of code:
Su
11 matches
Mail list logo
