Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error in stored proc
Message
From
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:
01430921
Views:
31
>>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform