If the long field is not enclosed within %TextIn, then the SQL will work with long field values up to 255 characters long. Anything over that will cause a "Fatal SQL error has occurred" message to pop up - so it's hard to pick up in testing.
INSERT INTO PS_SOME_RECORD(EMPLID
, LONG_FIELD1
, LONG_FIELD2)
VALUES (:1
,%TextIn(:2)
,%TextIn(:3))
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment