Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append Blank
Message
From
18/04/1997 10:28:20
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00028841
Message ID:
00028865
Views:
42
>>I made a Form in wick i use a relation to another table
>>I used a combo box, the result of the click of the mouse
>>in the combo box goes to a register in other table but when i push the new record botton an error occurs:
>>APPEND BLANK
>>violation in the register
>>why tha error?
>
>If you have a candidate or Primary (unique) Index then you may already have a blank field in that index. This is not allowed. Look for a blank field in your indexed field. You can also put trapping in to make sure this does not occur the first time.
>
>HTH,
>Tom

Also, if the child table does not already have a corresponding record to the parent, Fox will create a 'phantom' record in the child which WILL interfere with adding a blank record to that child. I got bit severely by that. My eventual fix was to INSERT into the child with at least the key field value.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform