Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate() on remote views
Message
From
22/05/2002 02:09:25
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Tableupdate() on remote views
Miscellaneous
Thread ID:
00659740
Message ID:
00659740
Views:
50
Hi, I have a remote view that has 4 fields. All fields accepts .NULL. values.
3 of the fields are bound to the 3 textboxes in my form as control source.

I do the following command when adding a new record

&& Add event
>>THISFORM.ENABLECONTROLS()


&& Save event
>> INSERT INTO rv_EMPFILE(field1, field2, field3);
VALUES(alltrim(thisform.txtbox1),;
alltrim(thisform.txtbox2),;
alltrim(thisform.txtbox3))

=tableupdate(1,.T.,"rv_EMPFILE")

my question is, Do I still have to include the fourth field in the insert command even if it accepts .NULL. value?


Thanks in advance....
Music Rocks www.musicreserve.blogspot.com
Success is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.
Next
Reply
Map
View

Click here to load this message in the networking platform