Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update field in table with default current date
Message
 
To
16/05/2002 17:17:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00657791
Message ID:
00658281
Views:
25
Hi,

Try setting the VALUE property of the myTextField to '=DATE()' or
'=myTable.submitDate'.

HTH,
Arriyel

>I'm using DSN-less connection, optimistic record buffering.
>On my form, I have a textfield called myTextField, that defaults to current/today's date.
>There is a field in myTable called myTable.submitdate that needs to be updated with that date.
>I have a command button to save all the fields on the form into the table. The click method to this command button only have 1 line: TABLEUPDATE(.T.).
>
>How do I set myTextField.controlsource?
>Do I set it: myTextField.controlsource=myTable.submitDate.
>How do I set it so that it defaults to today's date on the screen?
>
>Thank you all!
Speak using soft and sweet words in case you have to eat them later.
Previous
Reply
Map
View

Click here to load this message in the networking platform