Please note, that this article belongs to EAP files only!
You won’t have a problem with the given SQL Statement, if you’re running the repository on SQL Server or Oracle or whatever database. Except EAP:
As you might know, EAP files are MS Access database files with just some other extension.
Therefore, SQL Statements in EA are limited the way they are in Access itself.
So you want to quote the text from a memo-field like t_objects.Note? Bad idea!
select Name, '"' + Note + '"' as QuotedNote from t_object
will result in incomplete data, if the note’s length of content exceeds 255 characters.
Why is this?
Adding quotes to the data from a memo makes the database convert the column into text. And text fields are limited to 255 characters.
The more, every additional character will be cut off without warning.
If you don’t try to add quotes (or any other character!) to a memo field, you will receive the whole text.
Sadly, there’s no convert-to-memo function available. Just CStr, CVar and stuff.
And it makes no difference, how you connect to the database, as it is: a limitation of the database itself.