Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views vs. table itself?
Message
From
16/09/1999 16:04:49
 
 
To
16/09/1999 15:20:05
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00265613
Message ID:
00265645
Views:
16
>Is it always best to work with views instead of the tables themselves?
>(I'm very new to VFP) and am having a little trouble. If I change the value in one column of a grid, it correctly updates the table it came from, but if I delete the record it doesn't and if I try to insert a record it brings up an 'Add Record' dialog and forces an 'add record to child only'. Not sure what's going on. I think I have the Integrity of the tables in the DBC set correctly.


Do you have SET DELETED ON, as for adding records whats your "add" code look like? I usually do something like:
m.KeyField = PARENTTABLE.KeyField
INSERT INTO CHILDTABLE (CHILDTABLE.KeyField) VALUES (m.KeyField)
HTH
Thanks
Jon
Non-MVP Non-MCP Non-MCSE

Visual FoxPro, What else is there?
Previous
Reply
Map
View

Click here to load this message in the networking platform