Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error in stored proc
Message
 
 
To
23/10/2009 07:53:21
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01430571
Message ID:
01430924
Views:
28
>>>Yes, I remember Message#1412669
>>>
>>>I've tested this below and it gives an error - without textmerge
>>>
>>>If I use a cursor instead of a table - no error
>>>
>>>I'm running vfp9 sp2 without hotfixes
>>>
>>>
>>>CREATE DATABASE mooh
>>>CREATE TABLE test (ix I DEFAULT new_ix())
>>>
>>>
>>>USE test
>>>
>>>assert .f.
>>>
>>>
>>>
>>>
>>>*raises error
>>>APPEND BLANK
>>>
>>>
>>>FUNCTION new_ix
>>> return new_ix2()
>>>ENDFUNC &&New_IX
>>>
>>>function new_ix2
>>> TRY
>>>   ERROR 1
>>>  CATCH TO loException
>>>  FINALLY
>>> ENDTRY
>>>
>>> RETURN 1
>>>
>>
>>I ran this couple of time manually - didn't get an error. VFP SP2 Vista 64.
>
>What means manually? Just modi command - mark all - execute? Thats what I do.
>
>This all sounds a bit strange.
>
>The code where the error is tested is dead old. Normaly I would not run into it shouldn't be a problem. I also think I have tested it on his time so I feel puzzled.
>
>Agnes

Yes, I copied this code into a program, ran it by hignlighting all. The next try I only highlighted lines starting from Append blank and ran few times. Never got an error.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform