OK. Now I'm getting a error (392) LocalizationManager shared variable has not yet been created.
--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> I think this will help.
>
> You can update a column in a table using the UpdateTableBuffer
>
> And from help:
>
>
> Update Table Buffer
>
>
>
>
> Use the Update Table Buffer program to assign a value to a table field from
> outside of a particular window. This program is useful when you want to
> connect the entries in one field to the entry in another field,
> automatically.
>
> For example, you may want a Product Configurator input to update another,
> existing value as part of an OnLeave expression for a field. Use this
> program to perform such an update.
>
>
> Syntax
>
>
> Use the following syntax for this program:
>
> Run lib\UpdateTableBuffer.p(input BUFFER <Table>:HANDLE, '<Field>',<Value>)
>
> The entire statement should fit on one line.
>
>
> Description of Parameters
>
>
> Replace the terms in caret marks <> as follows:
>
>
> <Parameter>
>
> Meaning
>
>
> Table
>
> The table that has the field to be updated
>
>
> Field
>
> The field to be updated
>
>
> Value
>
> The value that the field should hold.
>
>
>
> The value could be a literal term (for example, 123) or it could be a named
> input from Product Configurator or a custom program.
>
>
> Example
>
>
> An order line should specify OurConfiguredPart as the part number. An input
> on the configuration screen should specify the quantity. The goal is to have
> the Quantity field on the configuration screen update the Quantity field on
> Sales Order Line Entry (which is OrderDtl.OrderQty).
>
> Specify the Quantity input as usual on the Detail tab in Product
> Configurator Inputs. Then, on the OnLeave tab, enter the following logic:
>
> Some of the words in the code are bracketed. Do not enter them yourself.
> They are in this help topic only as comment.
>
> [These first four lines declare and assign the current order and line
> numbers to variables]
> def var OrderNum as integer.
> def var OrderLine as integer.
>
> OrderNum = GetCurrentOrderNum().
> OrderLine = GetCurrentOrderLine().
>
> [This if statement validates that the update instruction is done for the
> company, order number and line with this input]
>
> If OrderNum > 0 and OrderLine > 0 then do:
> Find OrderDtl where OrderDtl.Company = "VN10T" and Orderdtl.OrderNum =
> OrderNum and OrderDtl.OrderLine = OrderLine no-lock no-error.
>
> [And then perform the update with the value entered in the input]
> Run lib\UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE, 'OrderQty',
> Quantity).
>
> End.
>
> The buffer handle statement passes the instance of the table name to the
> table record that was retrieved from the Find statement in the previous
> statement.
>
> The result of this example is that when OurConfiguredPart is entered on an
> order line, and the part is Configured, the Quantity input will accept a
> number (for example, 100). When that screen is closed, and the user returns
> to the Sales Order Line Entry window, the standard Quantity field also will
> show 100.
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> sanfranc415
> Sent: Tuesday, March 16, 2010 12:45 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Procedure Editor
>
>
>
>
>
> It doesn't look like my version allows me to make changes to the database?
>
> Can somebody confirm if this is true with Vantage? Or, I'm I missing
> something?
>
> --tj
>
>
>
>
>
> [Non-text portions of this message have been removed]
>