Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread Gotchas
Mon, Mar 17 2008 4:08 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 AMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 Smiley

>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 Smiley

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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 Smiley

Roy Lambert
Wed, Mar 19 2008 9:08 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< I didn't even know I could do that in a query Smiley>>

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

Image