Incomplete String

[shashank_hi]

Hi everyone,

I've got a problem that whenever a string variable is supposed to pick up a long string (about 4000 characters or more) it simply does not show the entire thing. SOme data from the end is lost.

How can I overcome this.

[mcibor]

Where do you take the data from? From db or form?

If from db, then make sure, that the data is there (for large chunks of data use blob, not char)
If from form, then there may be a quota set in the fields.

I need more info to make sure where the problem lies.

Best regards
Michal Cibor

[shashank_hi]

Thanks for replying Michal. I'm getting the data from a database. It's a MS Access File to which I'm connecting via a ODBC. The field from which I'm getting the data has "memo" as it's datatype.

Can I use "blob" here as well?

[shashank_hi]

BLOB is not being accepted as a valid entry. My memo size is getting fixed at around 4000 characters whereas the maximum possible is 65000+. Any suggestions on how to fix the memo size.

[mcibor]

When I tried searching for answer I came across this:

Memo is the largest but it still has a limit. I'd recommend storing the long data in .txt files, and store the path/name of the files in your access db.

Blob is a MySQL so it won't be of much use to you. Otherwise I don't know of any way to increase the field quota to 65k, sorry

Michal Cibor

[shashank_hi]

Thanks again,

Guess what I discovered. The data is getting into the database, but the problem is when i try to retrive it. So the problem is not really with entering the data in a memo, that's happening without problems, the problem is getting it out.

I'm using ODBC connection. I'm using odbc_result to get the data.

Wondering what the problem could be.

[shashank_hi]

Problem solved :)

Had to insert a function: odbc_longreadlen() to do the work.

Thanks for the input Michal Cibor.

[mcibor]

Glad you sorted it out!
I haven't used odbc yet, but in future may be.
Thanks for the working answer
Michal Cibor