Windows 7 Professional, EDB 2.03 Build 9 and D2007 (issue occurs in
D2010 as well)

I am having an issue and I know it is NOT a problem with EDB. I haven't
used queries very much in the past but am resolved to the fact that I
will be much more with EDB. Most queries I have ever used were SELECT
only queries.

The problem I am having is when I try to enter a parameter in the
"Params" property of the EDBQuery component. I am unable to
create/enter a new parameter as the entire dialog is disabled. The
reason I know it is NOT EDB is because the same thing happens if I try
to place any query component (i.e., BDE, UniDac, NexusDB) on my
DataModule.

I suspect it to be related to Win7 but don't know why. I have given
security permissions to the project folder and I can enter property
information into other components which open with an ellipses, just not
parameters in a query component.

Is there anyone using Windows 7 and either *not* had this ever
occur...or had it occur and figured out what caused it? Any push in the
right direction would be greatly appreciated.

--
Jan

I am now even more perplexed. I just tried to set up parameters on
another machine running WinXP, EDB 2.03 Build 7 and D2007 and the same
thing occurred. Am I missing something somewhere? I have used
parameters on the WinXP machine before using SQL Server and the BDE
TQuery component and did not have this occur.

As before, any assistance would be greatly appreciated.
--
Jan

On 3/19/2010 7:16 PM, J.B. Ferguson wrote:
> I am now even more perplexed. I just tried to set up parameters on
> another machine running WinXP, EDB 2.03 Build 7 and D2007 and the same
> thing occurred. Am I missing something somewhere? I have used
> parameters on the WinXP machine before using SQL Server and the BDE
> TQuery component and did not have this occur.
>
> As before, any assistance would be greatly appreciated.

Just to eliminate the obvious, what is your SQL text?  Does it include
any parameters?

My habit is to fill in the SQL text first, with the expectation that the
parameter will then show up in the Params list.  Am I correct in
thinking that you may be trying to set up a parameter before the SQL
text exists?

Charles,

Thanks very much. What is obvious to you wasn't to me. I did not have
the parameters listed yet in the SQL text.

I notice that the toolbar in the parameters dialog is still disabled
even when parameters are present. I assume that is WAD. I can "delete"
a parameter by removing it from my SQL text, etc. so it seems to work
as I need it to.

Once again...thanks for your assistamce.
--
Jan


Charles Tyson wrote:

> Just to eliminate the obvious, what is your SQL text?  Does it
> include any parameters?

Nope...That was the problem..

>  Am I correct in thinking that you may be trying to set up a
parameter before the SQL
> text exists?

You nailed it. That's what I was doing.