Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crashing VFP from error handler
Message
From
17/12/2021 14:53:17
 
 
To
17/12/2021 06:34:45
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01682978
Message ID:
01682995
Views:
57
Some more ideas:

1. Could a stored procedure or something else be triggered by the INSERT into the ErrorLog table - and might there be a problem in that?

2. As a guess you may be mapping a drive letter to a local folder so you can match the folder structure (or maybe even a hard-coded drive letter) at your client or their customers. There are two ways to do that:

a) Set up a share, and map a drive letter to that share with NET USE or in the File Explorer GUI
b) Use the old SUBST command in a CMD window (works fine when I've used it for this purpose)

A share plus NET USE involves the networking stack (even for local shares). This can make the mapping subject to various "optimizations" such as soft disconnects. SUBST is much simpler and doesn't involve the networking stack.

Whichever method you're currently using, you could try the other one instead.

3. Further to Christian's idea:
- Can you confirm that what you're trying to INSERT doesn't contain anything nasty like CHR( 0 )?
- Could there be an issue with bytes per index key exceeding 240, and/or COLLATION set to something other than MACHINE?
- Is the column Char or VarChar?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform