Output parameter

christ> OUTPUT? a SELECT is INPUT

Can you be more specific in what it is you want?

Hvis du har en tabel A med felterne X og Y og gerne vil hente feltet X, skriver du

SELECT X FROM A

X bliver så returneret.

Det er i forbindelse med stored procedure (muligvis ASP spørgsmål).

christ>This is ACCESS not SQL Server and if we are talking about a WEB application where you have an Access database then you cant use STORED PROCEDURES. So we STILL need more information.

Try and explain WAHT it is you are trying to do, and taht we you have a chance of getting some help.

WAHT = WHAT

Stored Procedures i Access:
http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1
Det kan være at vi ikke taler om det samme så?

Jeg prøver at forklare nærmere.
Jeg vil have placeret en værdi, fra en tabel, i en output parameter.

Er det nok information?

christ>This is taken from the link you gave
Please notice that Stored Queries are equivalent to Stored Procedures in Microsoft SQL Server. The procedure of creating and running Stored Procedures in Microsoft SQL Server is different. In Access database, stored procedures are known as 'Queries'.

As its states, they are equivalent, but not the same. In SQL Server you could have a very complex piece of code, here its is JUST a query with parameters.

You STILL do not say what your trying to do though!

I'm JUST gessing now. Use the SELECT STORED QUERY as an example and change where necessary.

SELECT * FROM [Table] WHERE SomeName = [@EnterName];

Then you would use
' executing stored procedure
Set rs = con.Execute ("exec SelectProc, 'christ'")

Tak for svaret terry, jeg tror desværre det bliver for omfattende det her. Det kan måske slet ikke lade sig gøre, det jeg vil.
Jeg vil prøve at finde ud af det og vende tilbage.

Du fortjener dog point for din indsats!

Tak for hjælpen

Christ

christ>If you gave an example of what you are trying to do then perhaps we could make some suggestions!