Search Postgresql Archives

Re: MS-Access and Stored procedures

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



""Zlatko Matic"" <zlatko.matic1@xxxxxxxxxxx> wrote in message 
news:003401c5573f$10f1b7c0$61841dc3@xxxxxxxxxxxxxxxxx
>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 queries on client side anyway. Therefore I 
> use pass-through queries. But it doesn't allow using parameters (execept 
> by concatenation). Also, you can't base subforms on pass-through queries, 
> so now I use strange combination of local tables, append queries with 
> parameters based on pass-through queries etc. It works but I'm aware that 
> it is not very clever:)...

I find it hard to imagine why you would want to do it that way.  Perhaps if 
you explain what you are trying to do, others can offer suggestions.

> I think that it would be great if pass-through queries could accept 
> parameters. That would be a powerfull way for executing queries on client, 
> while keeping all the code on front-end side...But I doubt that Microsoft 
> will work on further Access improving anymore. It seems that Access is 
> left behind while VS.NET is top technology. Too bad...
>
> IS there any good book covering MS Access usage as front-end for different 
> database servers except MSDE ?

I find the "Access XX Developer's Handbook" (where XX is the Access version) 
gives the best 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 ----- 
> From: "Hervé Inisan" <typo3@xxxxxxxxxxxxxxx>
> To: <pgsql-general@xxxxxxxxxxxxxx>
> Sent: Thursday, May 12, 2005 11:06 PM
> Subject: Re:  MS-Access and Stored procedures
>
>
>>> 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 parameters ? Using ADO Command object?
>>
>> AFAIK, there are 2 ways to send parameters from Access to a PG function,
>> using ADO:
>>
>> 1. Write the parameters as the CommandText string:
>> Set cmd = New ADODB.Command
>> cmd.ActiveConnection = cnn
>> cmd.CommandText = "mypgfunction('this is a parameter', 25)"
>> cmd.CommandType = adCmdStoredProc
>> cmd.Execute
>> Set cmd = Nothing
>>
>> The CommandText string can be the result of a concatenation:
>> Cmd.CommandText = "mypgfunction('" & strMyString & "', " & intMyValue & 
>> ")"
>>
>> 2. Another way is to use "true" ADO parameters:
>> Set cmd = New ADODB.Command
>> cmd.ActiveConnection = cnn
>> cmd.CommandText = "mypgfunction"
>> cmd.CommandType = adCmdStoredProc
>>
>> Dim prm1 As ADODB.Parameter
>> Set prm1 = New ADODB.Parameter
>> With prm1
>>    .Type = adVarChar
>>    .Direction = adParamInput
>>    .Value = "another string sent to PG"
>>    .Name = "param1"
>>    .Size = 30
>> End With
>>
>> Dim prm2 As ADODB.Parameter
>> Set prm2 = New ADODB.Parameter
>> With prm2
>>    .Type = adInteger
>>    .Direction = adParamInput
>>    .Value = 25
>>    .Name = "param2"
>>    .Size = 0
>> End With
>> cmd.Parameters.Append prm1
>> cmd.Parameters.Append prm2
>> cmd.Execute
>> Set cmd = Nothing
>>
>> Voilà!
>> -- Hervé Inisan, www.self-access.com
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>>               http://www.postgresql.org/docs/faq
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
> 



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux