Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View requery
Message
 
To
17/07/2007 12:08:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01241116
Message ID:
01241145
Views:
26
>>>I have created View with parent and child tables in it.
>>>
>>>When I insert new record into view and then do TableUpdate() it's ok except that some fields are blank. Those fields are from child table, unless I do requery() they are blank. How can show them without doing requery?
>>
>>What you have in these fields?
>>What ARE these fields?
>>Did you update them before TABLEUPDATE()?
>
>Simple view with parent and child fields.
>Problem is when I insert some new record child fields are blank.

OK, when you insert new record did you REPLACE these fields or set values for them in INSERT command?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform