General information
Category:
Coding, syntax & commands
Oh no, no, no, no. 255 character limit? There's a 255 character limit to my SQL statement? If I count from the first double quote to the last double qoute, I've got a total of 303 characters! Oh no. Ugh! I've spent countless hours trying to figure this out, only to be bitten by a character limit bug, er I mean feature?
Well if I remove unnessary spaces, semi-colons, etc., maybe I can get it down to 255 characters. Gee, why couldn't the VFP error message be something like "You have too many characters" instead of "Command contains unrecoginized phrase/keyword." I guess that would make programming too easy!
Boy, am I embarassed. Now that I think of it, I remember encountering this 255 limit before. I must have lossed too many brain cells trying to figure that one out (but I did find the problem on my own).
Even more embarrassing: I did a search of the Microsoft Knowledge Base looking for SQLEXEC, hoping to find an answer to my problem. One of the headers the search returned was entitled "HOWTO: Create an SQL Command with > 255 Characters" but I didn't even bother reading it!
Oh well, the important thing is getting it to work. I'd better go read that KB article!
jeff
>Jeff,
>
>Might you be getting bitten by the ol 255 character limit?
>
>good luck,
>Jim N.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only