How to Use BIGTEXT datatype in forms

sadynamics

Hi Experts,

i want to store more than 1000 characters in one variable. it should be of text data type. i have put text but only 1000 characters are allowed. How to input more than 1000 char in one variable. Please let me know the data type for the same.

Thank you...

vikram7_dabas

The maximum length of text variable is 1024.

sadynamics

Yes i know that is there any work around is there...

garak

variable -> Type BigText

To add values in the variable use BigText.ADDTEXT(Variable [,Position])

But this variable cannot be used in visual components.
For visialisation, you need an table or x Text variables or you go throug the value by using an loop

The Functions are (when u use F5):

1. LENGTH
Use this function to retrieve the length of a BigText variable.
Length (data type - Integer) := BigText.LENGTH

2. ADDTEXT
Use this function to add a text string to a BigText variable. The string can be inserted anywhere in the Variable or added at the end of the variable.
BigText.ADDTEXT(Variable [,Position])
The datatype of the variable should be Text or BigText.
If this 'Position' parameter is omitted, the string is added at the end of the BigText variable.

3. GETSUBTEXT
Use this function to retrieve part of a BigText variable.
[RetLength] := BigText.GETSUBTEXT(Variable, Position [,Length])
The RetLength is an Integer variable that gives you the Length of the Retrieved BigText.

4. TEXTPOS
Use this function to retrieve the position at which a specific string first occurs in a BigText.
Position := BigText.TEXTPOS(String)

5. WRITE
Use this function to stream a BigText to a BLOB field in a table.
The table you are writing to must contain a field of data type - BLOB.
You will have to declare an OutStream to write the data.

6. READ
Use this function to stream a BigText that is stored as a BLOB in a table to a BigText variable.
You will have to declare an InStream to read the data from the datatbase into the BigText variable.


7. To delete the content in a BigText variable use the CLEAR function:
CLEAR(BigText)

For more details, use Navision "C/SIDE Reference Guide".

BigText was primary introduced for to handle BLOB in XMLports.
The BLOBs will be converted with the BASE64 encoding so that there will be a very long string as result which can be exported by the XMLports.
BASE64 is one of the standards for E-Mail Attachments, so there should be many many tools for decoding the very very long text back into a BLOB.

hope its helpful.

Regards

sadynamics

Hi garak,

thank you for the reply. can this be used in 3.7 version ? i believe there is no big text datatype in 3.7

tinoruijs

sadynamics wrote:

Hi garak,

thank you for the reply. can this be used in 3.7 version ? i believe there is no big text datatype in 3.7

3.7 does not have bigtext. It was released in 4.0...