Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC, Referential Integrity, and Errors
Message
From
06/03/1997 17:26:07
Michael Knelsen
Technology Management Corporation
Regina, Saskatchewan, Canada
 
 
To
06/03/1997 17:10:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00023205
Message ID:
00023209
Views:
28
>>I have set up Referential Integrity(RI) in between my databases(Update, Delete, and Insert are all Restrict). Now, when I get an error, it goes to my error handler like it suppost to, but, I now have and array called GAERRORS that exists. This one-dimensional array contains 10 rows, of which half I know what they represent. I am assuming that the RI code creates this array, but I can not find anywhere that say's what the values in the array stand for. If anyone knows what the information in this array stands for, please let me know. Thanks in advance.
>
>I have no idea what is gaerrors, but basically you could use (within error trap) AERROR() to retrieve error information into array.

Maybe I didn't explain it well enough....gaerrors is being created out of thin air and showing up when I look at the Locals variable through debug window. I have not created this array anywhere. What follows is an example of what is contained in the array

gaerror[1,1] = -1
gaerror[1,2] = "Delete Restict Rule Violated"
gaerror[1,3] = ""
gaerror[1,4] = "temain"
gaerror[1,5] = "c:\data\vss\t&ev2\code\data\table2.dbf"
gaerror[1,6] = 1
gaerror[1,7] = 1
gaerror[1,8] = "forkey"
gaerror[1,9] = "c:\data\vss\t&ev2\code\data\tables3.dbf"
gaerror[1,10] = 1
gaerror[1,11] = 1
gaerror[1,12] = "initkey"

Of these, I know what rows 2,4,5,8,9,12 stand for, but the others I am just wondering what they stand for, and if they are important for me to record.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform