FIX_LH and Size Lock with Universal Driver (OpenInsight 32-Bit)
At 17 SEP 2004 03:56:31PM Enrique Murphy wrote:
We have OpenInsight 7.0.1 with Universal Driver 3.0.0.2.
When we use LH Table Info from inside the Database Manager for change the size lock for one table, we receive the following message in the status bar (after clicking the Save Settings and then the Close buttons):
SSP271: The Header of the table TABLE_NAME is corrupted. FIX_LH cannot continue.
If we try to do the same operation using the fix_lh function inside an RBasic+ subroutine, we receive the same message.
How can we modify the size lock of one table ?
If an GFE appears, How could we fix it if the FIX_LH appears can´t do this ?
At 17 FEB 2005 05:49PM Matthew Crozier wrote:
I've just come across the same thing in OI 7.1.0. The error comes up and the sizelock is not changed. The header doesn't appear to be corrupted though. It doesn't appear to be related to the network driver - I get the same thing using UD 3.0.0.3 or AND 2.1.
Does an Rlist SELECT use FIX_LH to set the sizelock? If so, then this is a bit of a worry! Is it addressed in 7.1.1?
Cheers, M@
[img]http://www.vernonsystems.com/images/logo_main.gif[/img]
At 14 MAR 2005 08:47PM Matthew Crozier wrote:
Further to this issue - it does appear to be dependant on UTF8 mode. In ANSI mode, FIX_LH '5' works fine; but in UTF8 mode, FIX_LH '5' returns a false SSP271 error (header corrupt). Hmmm, I think I can see now where FIX_LH is getting confused…
Workaround could be to shell such FIX_LH calls with SetUTF8() to temporarily disable UTF8 mode (as long as you don't need it during the processing).
I'll log it when I can get back into the bug tracker, if it's not already there.
M@
[img]http://www.vernonsystems.com/images/logo_main.gif[/img]
At 14 MAR 2005 09:08PM Matthew Crozier wrote:
Further clarification! This problem is for existing files (probably created pre OI 7.0? - eg SYSLISTS). FIX_LH '5' seems to have no problems with new files created with All Networks Driver under any combination of UTF8 mode or current network driver. However, I can't get FIX_LH to work with files created with Universal Driver under any combination!
M@
[img]http://www.vernonsystems.com/images/logo_main.gif[/img]
At 24 JUN 2005 03:05PM Enrique Murphy wrote:
FIX_LH still not works with UD 3.X (up to OI 7.1.1).