Tim

If you have more than one instance of a parameter in a piece of SQL you screen asks you to input it however many times you have it in the sql.

Roy Lambert

Roy,

<< If you have more than one instance of a parameter in a piece of SQL you
screen asks you to input it however many times you have it in the sql. >>

I'll look into this before 1.07 B2 goes out.  There should be only one
parameter in the list.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< If you have more than one instance of a parameter in a piece of SQL you
screen asks you to input it however many times you have it in the sql. >>

I checked this out, and it's normal per the way the TParams work with
Delphi.  If you set one value, the other one will get set also when the
parameter is assigned.  However, to keep things straight in the EDB Manager,
I would recommend using different parameter names.

I'll see about updating the dialog to reflect the parameter assignment among
same-named parameters.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>I checked this out, and it's normal per the way the TParams work with
>Delphi. If you set one value, the other one will get set also when the
>parameter is assigned.

I noticed that when I ran the same query in EDBManager for the 2nd+ time the parameters were all populated with the same value.

>However, to keep things straight in the EDB Manager,
>I would recommend using different parameter names.

For the same input parameter? Either I don't understand what you're saying, you don't understand what you're saying, or one of us has been eating magic mushrooms! The reason its the same parameter name is that its the same parameter. I notice I didn't give an example, and I can't remember which piece of sql I was beating my head against at the time (it was wrong anyway I remember that much) but was probably similar to

SELECT
_fkProjects,
_LastAccess,
(IF(_LastAccess IS NOT NULL THEN CAST((CURRENT_TIMESTAMP - _LastAccess)DAY AS INTEGER) ELSE 99999))  AS _LongAgo,
(SELECT _Name FROM "NLH-Live".Projects P WHERE P._ID = :Schedule) AS _Name,
(SELECT _Type FROM "NLH-Live".Projects P WHERE P._ID = :Schedule) AS _Type,
(SELECT _fkOrderBook FROM "NLH-Live".Projects P WHERE P._ID = :Schedule) AS _fkOrderBook,
(SELECT
IF(_Status = 'L' THEN 'Live'
ELSE IF(_Status = 'D' THEN 'Dead'
ELSE IF(_Status = 'H' THEN 'Hold' ELSE '')))FROM "NLH-Live".Projects P  WHERE P._ID = :Schedule) AS _Status,

(SELECT _fkUsers FROM "NLH-Live".Projects P WHERE P._ID = :Schedule) AS _fkUsers

FROM
mruProjects
WHERE
_fkProjects <> :Schedule
ORDER BY
_LongAgo


Roy Lambert

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in
news:E96F9062-78B7-4F4A-BA9E-D92A196CA937@news.elevatesoft.com:

> However, to keep things straight in the EDB Manager,
> I would recommend using different parameter names.
>

A little tricky if the parameter comes from a Master-Detail link

--
Chris
(XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3)

Chris,

<< A little tricky if the parameter comes from a Master-Detail link >>

It's only an issue with the EDB Manager.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< For the same input parameter? >>

Yes, and just populate each with the same value.  It was just a suggestion
until this occurred:

"I'll see about updating the dialog to reflect the parameter assignment
among same-named parameters."

And it already occurred for the next build, so no need to worry.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>Yes, and just populate each with the same value. It was just a suggestion
>until this occurred:

OH I see just so I knew what was going on. My initial impression was I might suddenly need to set the parameter value several times like those daft ? parameters

Roy Lambert

Roy,

<< OH I see just so I knew what was going on. My initial impression was I
might suddenly need to set the parameter value several times like those daft
? parameters >>

That's essentially how SQL parameters work (?) - by position.  Delphi (and
other front-ends) simply hides this from you and allows you to use names
instead.

--
Tim Young
Elevate Software
www.elevatesoft.com