replacing the ? with prefixed parameter names

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Madhusudhan (gurumum_at_email.uc.edu)
Date: 12/01/04 

Date: 1 Dec 2004 13:43:33 -0800

Hi,

i am using win 2000 client and sqlserver 2000

I have 3 questions:

1. i am using global variables to pass data to a query in an exec sql.
It works fine when i use the "?" placeholder for the parameters.
The problem is that when i am using like 20 parameters, it is a pain
to map global variables to parameter1,parameter2.......parameter20.

So i right clicked the question mark in the build query box and tried
to specify names for teh paramters using prefixes and suffixes for the
names. e.g @paramname@, @paramage@ adn so on

But this doesnt seem to work - I get an error that says "deferred
prepare....."

Am i getting something wrong? Is it possible in teh first place to
replace the ? marks with those names and to have those names display
in the right hand side column while mapping parameters instead of
Parameter1, Parameter2 etc ?

2. Stepping through

Is it possible to step through execution in a package? or at least in
an activex script?

i have enable JIT debugging but am not able to debug like I used to be
able to in the VB editor.

3. workflow activex scripts
are these always executed before execution of the task they are
attached to?

Thanks,
Madhusudhan

Relevant Pages

  • Re: Finally which ORM tool?
    ... Also, if you pass a variable to the query, the value the ... you have a linq query and by changing the variable's value, ... q is affected if I change foo AFTER this query and BEFORE execution. ... And it is a declaration, but one which captures the variables. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Finally which ORM tool?
    ... the session' method. ... able to execute the query by itself. ... has at EXECUTION time is used, ... That SHOULDN'T be important, simply because q LOOKS like a declaration, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Finally which ORM tool?
    ... the session' method. ... they use the same mechanism as Linq to Sql does: ... Also, if you pass a variable to the query, the value the variable ... q is affected if I change foo AFTER this query and BEFORE execution. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: One Insert statement, no looping, creates 2 records?
    ... Is there any chance a distributed query is involved? ... you can see this when the first execution generates the ... >REALLY odd, tho, is that the debug display only shows once, even tho it's ... and the debug display ...
    (microsoft.public.sqlserver.programming)
  • Re: As a generale rule - Query or VBA?
    ... I agree with you Rick, I was recently working on a database that had ... the query is saved, then JET will save the fastest execution path. ...
    (comp.databases.ms-access)