• Search Forums
    Advanced Search
Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Lawson ADODB - Update a form field defined as VS Problem

 1 Replies
 0 Subscribed to this topic
 2 Subscribed to this forum
Sort:
Author
Messages
RayB
New Member
Posts: 2
New Member
8/27/2010 3:04 PM
I am attempting to set the value of the AMD-ORIG-AMT defined as a VS (17 length, 2 decimals) field type on form AR21.3. What would the format string for updating this field? I assumed "0.00;0.00-" but this failed!

BTW I am attempting to upload data from an excel worksheet using vba/adodb.

Thanks,
Ray
RayB
New Member
Posts: 2
New Member
8/27/2010 6:58 PM
Problem is with Lawson ADO Schema that defines AMD-ORIG-AMT as ADO_LONGPTR type which only allows for Long data type i.e., signed integers only?!?!?!

Ray