Is there a limit for string length used un IFiler

[Anonymous]

Hi,

In Joint Com, we need use IFiler to save and load Joint data from database. I need to use a few real large string as variable. say, 10,000 chars each. Is is possible to do so, or I have split them to shorter string? Is there a limit for string length in database (transfer IFiler)? Something like follow:

public void OutField(IFiler pFiler)

{

pFiler.writeVersion(1); //Set the current rule version

pFiler.writeItem(m_largeString, "LargeString"); // large string with thouands chars 

} 

public void InField(IFiler pFiler)

{

int version = pFiler.readVersion(); //Returns the current rule version.

m_largeString = (string)pFiler.readItem("LargeString");// large string with thouands chars 

}

Regards,

Luke

[Anonymous]

Hi,

In Joint Com, we need use IFiler to save and load Joint data from database. I need to use a few real large string as variable. say, 10,000 chars each. Is is possible to do so, or I have split them to shorter string? Is there a limit for string length in database (transfer IFiler)? Something like follow:

public void OutField(IFiler pFiler)

{

pFiler.writeVersion(1); //Set the current rule version

pFiler.writeItem(m_largeString, "LargeString"); // large string with thouands chars 

} 

public void InField(IFiler pFiler)

{

int version = pFiler.readVersion(); //Returns the current rule version.

m_largeString = (string)pFiler.readItem("LargeString");// large string with thouands chars 

}

Regards,

Luke

[turbatc · Accepted solution]

Hi,

IFiler can store strings up to 524.288 characters.
But when you save data in database each field type has a maximum limit.
Short Text: Up to 255 characters
Memo: Up to 63,999 characters
Long Text: Up to 63,999 characters

So if you want to save more than 10.000 chars use Long Text Field or Memo.

Regards,
Constantin

[turbatc · Accepted solution]

Hi,

IFiler can store strings up to 524.288 characters.
But when you save data in database each field type has a maximum limit.
Short Text: Up to 255 characters
Memo: Up to 63,999 characters
Long Text: Up to 63,999 characters

So if you want to save more than 10.000 chars use Long Text Field or Memo.

Regards,
Constantin

[Anonymous]

Constantin,

Thank you for the answer.

Do we need to define a table structure for Advance Steel joint to store data? I see there is a GetTableName() method. Where I should add/find a table for joint? Did not see it mentioned in API document.

I thought that Advance Steel will automatic take care this by definition in InField/OutField method. 

Regards,

Luke

[Anonymous]

Constantin,

Thank you for the answer.

Do we need to define a table structure for Advance Steel joint to store data? I see there is a GetTableName() method. Where I should add/find a table for joint? Did not see it mentioned in API document.

I thought that Advance Steel will automatic take care this by definition in InField/OutField method. 

Regards,

Luke

[turbatc · Accepted solution]

Hi Luke,

You will need to define a new table in AstorRules.mdb database.
Then in the GetTableName() method, return the joint table name.

Regards,
Constantin

[turbatc · Accepted solution]

Hi Luke,

You will need to define a new table in AstorRules.mdb database.
Then in the GetTableName() method, return the joint table name.

Regards,
Constantin

[Anonymous]

Constantin,

Thank you for your help!

I see some defined table in AstorRules, the first three fields are "Key", "Comment", & "Section", then followed by user fields with same order as in/outField method. Is it correct? Are first three fields mandatory or optional?

If it is mandatory, I guess "Comment" is used for search, but not sure what "Section" is used for.

Regards,

Luke

[Anonymous]

Constantin,

Thank you for your help!

I see some defined table in AstorRules, the first three fields are "Key", "Comment", & "Section", then followed by user fields with same order as in/outField method. Is it correct? Are first three fields mandatory or optional?

If it is mandatory, I guess "Comment" is used for search, but not sure what "Section" is used for.

Regards,

Luke

[turbatc · Accepted solution]

Hi Luke,

Only "Key" is mandatory the other fields are used for search and are optional.
"Section" is used for search, for example you configure a joint, then save the parameters in database.
Next time when you create the same joint, if the input object has the same section like one from the database
the joint will be created with the default values from that record.

Regards,
Constantin

[turbatc · Accepted solution]

Hi Luke,

Only "Key" is mandatory the other fields are used for search and are optional.
"Section" is used for search, for example you configure a joint, then save the parameters in database.
Next time when you create the same joint, if the input object has the same section like one from the database
the joint will be created with the default values from that record.

Regards,
Constantin

[Anonymous]

Thank you Constantin!

[Anonymous]

Thank you Constantin!