Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key Problem
Message
 
 
To
24/11/1999 09:04:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00294634
Message ID:
00294963
Views:
27
Is this failing when you run the APP? Are the tables included in your project? If so, exclude them. Tables included in a compiled app can not be modified at runtime.

>It's not read only. I can append blank. this is what I did to find out. Went to project mgr, chose a table, chose browse, chose view | edit, went to the command window, typed append blank and pressed enter. What happened was that it appended a record, but when I entered a value in the record, it didn't add another record. all my tables are doing that.
>
>
>>Check file attributes to see that they are not read-only. Can you Append blank to the tables? Do you have proper rights to the directory where the tables are located.
>>
>>
>>>they all have the same name, all are integers, all have input masks of 9999.
>>>the only differences are that 1 is primary, and 2 and 3 are regular; and that the default of the primary calls a getkey().
>>>
>>>
>>>>The number of fields does not matter. What does matter is that you match field names and types. Compare the structures between the tables you are trying to append from and to.
>>>>
>>>>>actually now that I look at it, None of the tables will append. no errors either. the 1st table has quite a few more fields than the other two. what do you need to see as far as table structure?
>>>>>
>>>>>
>>>>>>>I have 3 tables - table 1 has a primary key that i linked in my data environment to regular keys of the same name in the other tables. the problem is that the third table will not append new records and i don't understand why.
>>>>>>>
>>>>>>>HELLPPP!!!!
>>>>>>>JD
>>>>>>
>>>>>>Do you get an error message? If so, what is it? If not, are you getting just blank records appended? Providing partial table structures for the 1st and 3rd tables would probably be helpful as well.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform