Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Parameters in EDBQuery |
Fri, Mar 19 2010 9:05 PM | Permanent Link |
Jan Ferguson Data Software Solutions, Inc. Team Elevate | 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 |
Fri, Mar 19 2010 10:16 PM | Permanent Link |
Jan Ferguson Data Software Solutions, Inc. Team Elevate | 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 |
Fri, Mar 19 2010 11:42 PM | Permanent Link |
Charles Tyson | 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? |
Sat, Mar 20 2010 12:20 AM | Permanent Link |
Jan Ferguson Data Software Solutions, Inc. Team Elevate | 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. |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |