Rank: Newbie
Groups: Registered
Joined: 18/05/2021(UTC) Posts: 4 Location: TN
|
Dear Team, I have updated the software today after I am getting this error. When I insert a file and try to retrieve the data from it shows result - not defined. I am using the syntax for few years and I havent faced this error. Kindly someone help to solve it. I have attached the working files also. _database.sm (9kb) downloaded 15 time(s). Loading.sm (9kb) downloaded 14 time(s).
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
The error happens because no match is found (result is not defined before the loop in vlookup).
Probably something wrong about encoding in include() due to recent API changes.
You can check it displaying on the canvas the imported data. If it contains a bunch of \xyzk\ stuff, this is the cause (I can't check it directly currently) |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Newbie
Groups: Registered
Joined: 18/05/2021(UTC) Posts: 4 Location: TN
|
Originally Posted by: Davide Carpi The error happens because no match is found (result is not defined before the loop in vlookup).
Probably something wrong about encoding in include() due to recent API changes.
You can check it displaying on the canvas the imported data. If it contains a bunch of \xyzk\ stuff, this is the cause (I can't check it directly currently) Kindly find the below image,
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
You have to display the data imported by include().
I'm from mobile, so I can actually open the worksheets but I cannot reproduce anything related to plug-ins. |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 28/08/2014(UTC) Posts: 1,356 Was thanked: 815 time(s) in 516 post(s)
|
Hi. Issue is because the new ASCII encoding. I say that not because I understand it, but because this workaround solve the problem. But it's that, just a temporal solution. I don't know which could be the best procedure for "know" what are the values in the strings variables, and reproduce it with the keyboard. Best regards. Alvaro.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 18/05/2021(UTC) Posts: 4 Location: TN
|
Originally Posted by: Davide Carpi You have to display the data imported by include().
I'm from mobile, so I can actually open the worksheets but I cannot reproduce anything related to plug-ins. Please find the screenshots from two different files. database sheet Loading sheet
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 18/05/2021(UTC) Posts: 4 Location: TN
|
Originally Posted by: Razonar Hi. Issue is because the new ASCII encoding. I say that not because I understand it, but because this workaround solve the problem. But it's that, just a temporal solution. I don't know which could be the best procedure for "know" what are the values in the strings variables, and reproduce it with the keyboard. Best regards. Alvaro. Hi, I did the same, but still I get this error.
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.