| Author |
 Topic  |
|
|
IrI
Germany
4 Posts |
 Posted - 07/29/2020 : 07:11:37 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): 9.0.0 SR2
Operating System: Win10 Pro
Hello everyone,
I would like to substitute a few LabTalk variables into my (relatively long) SQL query, but it won't work. Still, it works if my SQL query is shorter.
I did some trial-and-error tests and apparently, LabTalk substitution in Origin 9.0 needs the SQL query to be less than 3050 bytes. However, I need to get it to work with a 3583 byte long query.
Do I have any options?
Cheers
IrI
|
|
|
cpyang
USA
1406 Posts |
Posted - 07/29/2020 : 09:15:42 AM
|
Newer versions of Origin, that buffer has been expended.
CP
|
 |
|
|
IrI
Germany
4 Posts |
Posted - 07/29/2020 : 09:51:22 AM
|
According to this thread (https://my.originlab.com/forum/topic.asp?TOPIC_ID=46209), this problem persists even in Origin 2020b.
BTW right now, I am trying to shorten my SQL query using more LabTalk substitutions. Whenever I try to preview substituted string with only 14 substitutions, Origin crashes completely. Is this a known/normal behavior?
Cheers
IrI |
|
|
|
cpyang
USA
1406 Posts |
Posted - 07/29/2020 : 10:16:55 AM
|
Yes, 2020b the buffer was 8192, and we double it for 2021.
But for your 9.0, it was 3050 right? So your SQL will definitely work in 2020b.
CP
|
|
|
|
IrI
Germany
4 Posts |
Posted - 07/30/2020 : 05:46:55 AM
|
Thanks for the info.
Is a costly upgrade to 2020b the only solution?
Cheers
IrI |
|
|
|
IrI
Germany
4 Posts |
Posted - 08/03/2020 : 07:19:26 AM
|
| Up |
|
|
| |
Topic |
|
LabTalk substitution in a _long_ SQL query fails