Use this dialog to assign values to the selected fields or to add new fields to the list. The new value field may contain control properties.
Only the string data type is used here and the database provider automatically converts the value provided to the data type of the field referred to. The database provider considers the value a literal representation of the data and uses its way of type casting. Refer to the database provider documentation to find out the correct literal representation of the data you want to write in the target field. For most data types this works perfectly but special care should be taken for the date, time and datetime data types.
|
EXAMPLE |
Access Database accepts a DateTime literal provided in the following format: yyy-mm-dd hh:mm:ss. In order to update a datetime database field you need to provide this format. Create a Transfer property in your VBVFrame named MyDateTime and assign it with a properly formatted string: VBVFrame1.Transfer.MyDateTime(channel) = Format(Now, yyyy-mm-dd hh:mm:ss) Then your may use the formatted value (i.e.%VBVFrame1.Transfer.MyDateTime(channel)%) as the New Value in the DataChange Entry dialog. |