General information
Category:
Forms & Form designer
You know I never really noticed that properties button before. I suppose during my first exploration of remote views I somehow got the idea that this was one of those areas were things were better left alone. Do you use the view properties quite a lot and what might you suggest for dos and don’ts?
…tim
>Are you using remote views?
>
>If so, you can set the data type to the fields in the view to DATE and the time portion will be dropped.
>
>>>>We have upsized our tables to a SQL server and the DATE columns have been converted to DATETIME data type. This change has annoyed our secretaries and we are looking for a simple solution. I have experimented with FORMAT and INPUTMASK but have not been able to get rid of the time portion of the data.
>>>>
>>>>How is everyone dealing with this change?
>>>>
>>>>…tim
>>>
>>>You can use TTOD() to display only the date portion of a datetime var. This is on the VFP client right?
>>>
>>>When sending to SQL Server, you can send only the date portion if you don't care about the time.
>>
>>Yes, VFP 6.0 and how are you binding the form control to the data?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only