Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 1 to 9 of 9 total |
Gotchas |
Mon, Mar 17 2008 4:08 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I think I've seen posts about this before. I don't know where the problem lies but I had a parameterised query that wasn't working - permanently returned 215 records regardless of the parameter. Cut'n'Paste into EDBManager and it worked properly. After going round and round for an hour or so the eventual cure was to retype the parameter inside the query changing it from :ContactID to :ContactID Why this worked I have no idea but it got me thinking - as part of your website redesign can we have a gotcha's page with weirdo's like this on? Roy Lambert |
Mon, Mar 17 2008 5:43 AM | Permanent Link |
"Rita" | "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:4FA066BF-8442-48E7-A382-BF6AF105EA60@news.elevatesoft.com... > >After going round and round for an hour or so the eventual cure was to >retype the parameter inside the query >changing it from :ContactID to >:ContactID > > Why this worked I have no idea. OCR stuff sometimes behaves like that and I think its down to the OS holding our hands incase we parse in a command M$ will not answer me on that tho, I have more chance getting a days work outa HRH Prince Philip. Copy n paste is just a pretty pic really and nothing has been entered as a command so you change part of that pretty pic to a command then the OS comes to life and reads to address everything you have entered. I think somebody will be along in a mo to give the real answer ;-( Rita |
Tue, Mar 18 2008 11:17 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I think I've seen posts about this before. I don't know where the problem lies but I had a parameterised query that wasn't working - permanently returned 215 records regardless of the parameter. Cut'n'Paste into EDBManager and it worked properly. After going round and round for an hour or so the eventual cure was to retype the parameter inside the query changing it from :ContactID to :ContactID Why this worked I have no idea but it got me thinking - as part of your website redesign can we have a gotcha's page with weirdo's like this on? >> Are you sure that you were assigning a value to the parameter at runtime? AFAIK, there are no such issues with the parameters in 1.08 if they are properly assigned a value at runtime. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Mar 18 2008 11:33 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Are you sure that you were assigning a value to the parameter at runtime? >AFAIK, there are no such issues with the parameters in 1.08 if they are >properly assigned a value at runtime. Utterly, absolutely, definitely and any other absolutes you can think of. I don't even say it was ElevateDB just that retyping the parameter name in the sql sorted it. Roy Lambert |
Tue, Mar 18 2008 11:43 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Utterly, absolutely, definitely and any other absolutes you can think of. I don't even say it was ElevateDB just that retyping the parameter name in the sql sorted it. >> Yes, but that shouldn't have any bearing on the runtime operation, and if it did, then something is wrong, either with EDB or your code. If you see this again, could you forward me the applicable code ? Thanks, -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Mar 18 2008 12:18 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Yes, but that shouldn't have any bearing on the runtime operation, You know that, and I know that but has anyone told my computer >If you see this again, could you forward me the applicable code ? I'll try, but with something like this just cut'n'paste the code for you will probably cure it It was really weird. The query selects contacts working for the current company so they can be displayed and I noticed the display wasn't changing as I scrolled. First test add a breakpoint to make sure its going through it - fine. Next check that the company code was changing - fine. Next make sure I'd prepared the query before trying to assign the parameter - yes. Scratch head a lot. Cut'n'Paste query into EDBManager, overwrite parameter with specific company code - it works Try running in app several more times. Scratch head some more. Alter parameter in query to company code used in EDBManager, comment out parameter assignment - run in app - fine. Put parameter back in query, uncomment assignment - the damn thing works. Roy Lambert |
Tue, Mar 18 2008 4:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< It was really weird. The query selects contacts working for the current company so they can be displayed and I noticed the display wasn't changing as I scrolled. >> Did you perhaps change the parameter type to something other than ptInput or ptInputOutput ? If so, then that could cause such a problem. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Mar 19 2008 4:20 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Did you perhaps change the parameter type to something other than ptInput or >ptInputOutput ? If so, then that could cause such a problem. I didn't even know I could do that in a query Roy Lambert |
Wed, Mar 19 2008 9:08 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I didn't even know I could do that in a query >> Sure you can. At some point we were planning on adding INTO support for dumping the results of a query into an output parameter. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |