Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- SQL error

Home Register
Log In
By SQL error
ArlJim78
11/1/2009
8:15:38 PM
Been working on a SQL UDM and now I'm seeing an error message whenever I try to save any additional instructions to it.

Runtime error '6'
Overflow

anyone else see this?
Is this telling me I've exceeded the size limit for SQL code?


Reply
jeff
11/1/2009
11:39:03 PM
Jim,

Shoot me an email with the full SQL expression and I'll have a look.

-jp

.

Reply
ArlJim78
11/2/2009
1:33:53 PM
Jeff,
I was just experimenting with SQL instructions, and had written out a long expression when I got that message. It's not something that I'm going to waste time having you debug because like I said I was experimenting and didn't even save it. I was just curious what the error message meant.

What I had written was something along the lines of;

Where ((cond1 and cond2 and cond3 and cond4...cond20) or (cond21 and cond22 and cond23 and cond24...cond40))

I'm thinking it just maybe just got too long for a complex expression? not sure.

anyway, I love this SQL mode!! It's awesome.
instead of converting UDM's I'm mainly just making new ones, hopefully better ones.

thanks
Jim

Reply
Reply

Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com