Error - The length of the string is 15 , but it must be less than or equal to 10

(0) Share

Report

Posted on by jsshivalik

3,099

I am getting the above error in below code

IF "Detailed GST Ledger Entry"."Gen. Bus. Posting Group" = '' THEN BEGIN
  IF recLocation.GET("Detailed GST Ledger Entry"."Buyer/Seller Reg. No.") THEN
   CName := recLocation.Code;
END;

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mohana Yadav 60,967 Super User 2025 Season 2 on at

Like (0)

Report

RE: Error - The length of the string is 15 , but it must be less than or equal to 10

What is the length of variable CName?

If it is 10 then increase to equal the length of location code.

Was this reply helpful? Yes No
Suggested answer

Marcellus 2,735 on at

Like (0)

Report

RE: Error - The length of the string is 15 , but it must be less than or equal to 10

Hi Jsshivalik,

I think your problem is with the recLocation.GET because the application is expecting a maximum 10 characters long Location Code and the Detailed GST Ledger Entry"."Buyer/Seller Reg. No." is 15 characters long.

Are you sure this code is going to get you a location?

Check this msdn article about GET: msdn.microsoft.com/.../dd301056(v=nav.90).aspx it's expecting values stored in the primary key fields.

Also you should turn on the debugger and execute your code, it will help you pinpoint the problem.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

RE: Error - The length of the string is 15 , but it must be less than or equal to 10

The recLocation.GET uses the Primary Key of the Location table, which is 10 characters in length. Your "Detailed GST Ledger Entry"."Buyer/Seller Reg. No." is more than 10 characters, so it's causing the error.

As mentioned by Marcell, do you think "Buyer/Seller Reg. No." stores the Location Code?

Was this reply helpful? Yes No
Verified answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Error - The length of the string is 15 , but it must be less than or equal to 10

You need to write following code for getting location name. You are passing the wrong field.

IF "Detailed GST Ledger Entry"."Gen. Bus. Posting Group" = '' THEN BEGIN

IF recLocation.GET("Detailed GST Ledger Entry"."Location Code") THEN

CName := recLocation.Code;

END;

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

RE: Error - The length of the string is 15 , but it must be less than or equal to 10

Has this query got any relation with your recent post of "Buyer Seller State Code in Detailed GST Ledger Entry"?

If so, please use the same thread, instead of multiple questions on the same.

Was this reply helpful? Yes No