Parameter in list fails to set in field

[mozmtnman]

Using 13 values as parameters, all transfer except the 12th one. It is text of customer's middle name. What am I missing here?

[mozmtnman]

Thanks for the reply. Here are the details: A clerk types Service Order information about a new customer into the fields of a FM layout. First, middle, and last name are separate entry fields (text). When the data entry form is complete, a button click starts the script which fills out relevant fields in a separate FM db. The parameter values:

Service Order::Acct

& ¶ & Service Order::DepositReceiptNr

& ¶ & Service Order::DateDeposit

& ¶ & Service Order::DepositAmt

& ¶ & Service Order::DepositAction

& ¶ & Service Order::DepositCertificateNr

& ¶ & Service Order::DepositCkNr

& ¶ & Service Order::DepositPaymode

& ¶ & Service Order::NameonCk

& ¶ & Service Order::Sequence

& ¶ & Service Order::FN

& ¶ & Service Order::MN

& ¶ & Service Order::LN

Here are the script lines which place the name fields in the separate db:

Set Field [ MVDeposit::FN; MiddleValues ( Get ( ScriptParameter ); 11 ; 1 ) ]

Set Field [ MVDeposit::LN; RightValues ( Get ( ScriptParameter ); 1 ) ]

Set Field [ MVDeposit::MN; MiddleValues ( Get ( ScriptParameter ) ; 12 ; 1 ) ]

Only the middle name field fails to have the text appear in the separated db record.

[Raybaudi]

Hi

what about using the GetValue( ) function ?

Set Field [ MVDeposit::FN ; GetValue ( Get ( ScriptParameter ) ; 11 ) ]

Set Field [ MVDeposit::MN ; GetValue ( Get ( ScriptParameter ) ; 12 ) ]

Set Field [ MVDeposit::LN ; GetValue ( Get ( ScriptParameter ) ; 13 ) ]

[color:gray]BTW: to check for errors, try to insert a

Show Custom Dialog [ Get( ScriptParameter ) ]

[color:gray]at the top of the script

[mozmtnman]

Thanks for your suggestions and LaRetta's replies. I have been diverted from the problem for a few days. I suspect that a lookup has been broken when moving the file from my FM9 Adv to the customer site.