Kalde en procedure fra en query

Lav styringen i VBA og kør SQL. Så for du et resultat, hvor den ene forelspørgsel fodre den anden.
VH Henrik

henrik13> Ja, men det ville jo være for nemt, ikke? ;-)
Ideen er at styre det med SQL

Why do you need to use a stored procedure?

What is it you want to do and I will se if I can give you some ideas?

I want to use the results from several stored procedures (or one procedure but several times) in one query from where they are all called (It's a matter of not having to write the same SQL over and over again).

Maybe I am going about it the wrong way? I'm looking into Macros now, maybe that is more lige it?

FROM A QUERY YOU CAN CALL A FUCNTION IN A MODULE

Function tst() As String

    tst = "Hej!"
   
End Function

then a query would look like this

SELECT YourTable.*, tst() AS tst
FROM YourTable

You could also have a function where you send one of the fields

SELECT YourTable.*, tst([field1]) AS tst
FROM YourTable

and a funciotn could look like this!

FROM A QUERY YOU CAN CALL A FUCNTION IN A MODULE

Function tst(someField as String) As String

'Do something with someField
    tst = "This would contain result"
   
End Function

Jeg har lavet en klient til SQLserver med 104 tabeller jeg forespørger i.
Løsningen på alle mine laaaaaange SQL sætninger, der lignede hinanden, var at lave en temptabel.
Denne temptabel bruger jeg så i andre forespørgsler, hvor jeg slipper for at referer til textfelter i formularer osv, netop fordi søgningen begrænses af temptabellen.
Hvis du har adgang til serveren kan det også være ide at gøre brug af views, der forenkler dine SQL på klienten.

Niels

carstensm>hows it going?

Thanks for your suggestions, but none of them really worked in my case. All I learned was that what I wanted to do is probably not possible.

BTW I only meant to give you 10 points each, but the system tricked me :-)

WHAT is it you want to do? Perhaps we can make some suggestions if you tell us!

Execute a stored procedure inside another query. And I mean a real stored procedure so that it works via ODBC. The homemade functions in Access don't work when calling the stored procedure from Java, via ODBC.

carstensm>what is wrong with this?

SELECT * FROM Kunde
WHERE KundeName = (SELECT KundeName from Kunde WHERE KundeID = 123)

No need for a stored procedure here and as far as I can see gives you what you want!

True, but as I said: that was just a thought-up SMALL example. In real life it would have saved me a lot of work.

Are you saying that you MUST use a stored procedure?

No, but it would be easier for me to reuse code. Anyway, I've found a way around it by making some more tables and views.

OK :o)

jeg har et probem der ligner det meget.

jeg har brug for følgende (konceptuelt)
select
      field1,
      field2,
      returværdifrastoredprocedure('param1'),
      returværdifrastoredprocedure('param2')
from
table

ken det lade sig gøre og giver det fornuft?