How to get around String Literal length limit

[yert33]

I'm using Visual FoxPro to read/write to a Notes database via the NotesSQL ODBC driver. Works great for the most part. But when I try to pass a string literal over 254 bytes long I get an error: "[Lotus][ODBC Lotus Notes]String literal limit is 254 bytes."
Lotus Developer Domain forum says: "the max limit of a string literal (the characters between the open and close quotes) when used in a sql statement cannot exceed 254 characters. If you need more characters, then you must use bound parameters instead of a string literal."

What are bound parameters? How do you use them?

TIA,
Trey

 

[inteleserve]

I was / will be running into this problem in a short while on a page I have been working on. I want to have a comment box but can't write more than 254 char into the VFP database character filed. I was thinking about Just have some vbscript break up the text into chucks and putting it into multiple fileds. What do you think?