PxPlus User Forum
Main Board => Discussions => Language => Topic started by: michaelgreer on October 25, 2021, 10:50:18 AM
-
I am trying to create a file with record size >32K. I am using this:
keyed "myfile",[1:1:16:"+"],0,-50000,opt="X"
This throws an error 41. What am I mssing?
-
Set the record size to -30000 and use the OPT="X" (as you have specified).
The -30000 indicates that internally the system will split the records into 30000 byte chunks each linked together due to the OPT="X".
-
Thanks Mike. Not sure I would ever have figure *that* out. :P Now, I just did keyed "myfile",[1:1:16:"+"],0,-30000,opt="X". I dimmed a$(35000). When I write to a channel with myfile opened - write(lfo)*,a$ - I get an error 1.
-
What version PxPlus are you using? I just tried this here and it worked on all supported release (PxPlus 2018 v15 -> PxPlus 2021 v18).
PxPlus-2018 Web (Ver:15.10/MS-WINDOWS) Serno:1510-001-xxxxxxx
(c) Copyright 2005-2018 PVX Plus Technologies Ltd. (All rights reserved)
Website: http://www.pvxplus.com
->keyed "myfile",[1:1:16:"+"],0,-30000,opt="X"
->dim a$(35000)
->open (1) "myfile"
->write (1) *,a$
->
-
Well now, that may be the issue. I am on 10.20. Not supported there?
-
The combination of Extended record size and auto-increment (the "+" in the key definition) is not available on that version.
-
If I nix the autoincrement can I get the extended record size?
-
That should allow it to work although we would STRONGLY recommend you use a newer version of PxPlus as version 10.20 is over 9 years old and there have been many changes, fixes and enhancement since that time.
-
I have successfully created this file. Now, when inserting large records via ODBC (v 5.10.0002)a 3rd party is running into this error:
“<eb1>Expected lexical element not found: <identifier>
State: 37000; Native: 1015; Origin: [PxPlus][ODBC Driver]</eb1>”.
Is this a limitation of the ODBC in play here?
-
Why are you using version 5.10 of the ODBC?
It from 2012 and has not been supported for a number of years.
The current ODBC driver is version 7.
-
No particular reason other than it has been in place all these years.