AnsweredAssumed Answered

Script Parameter Function

Question asked by ttumbles on Nov 14, 2008
Latest reply on Nov 17, 2008 by Orlando

Title

Script Parameter Function

Post

I have a small script  (see bold text below) that finds any "blank" fields in a found set of records for an annual report.

I have around 30+ fields that I will run this script on looking for blanks but each one has to be done separately.   The ONLYdifference between the script for one field and another is the CONSTRAIN FOUND SET (line 3)

.

Is there a way to use the Get (Script Parameter) function or something else to do the CONSTRAIN FOUBND SETso that I can eliminagte all but one script?????  The script below looks for blanks in the field "Z08_DOB".

.

Set Error Capture (On)

 

Perform Script (Find all records for annual report)

 

Constrain Found Set[Specified Find Requests: Find Records: Criteria: CUBMAIN::Z08_DOBB; "="] [Restore]

 

If GFet (Last Error) = 401

 

Show Custom Dialog[Message:"G O O D !";  "OK";  "Cancel" ]

 

Exit Script

 

End If

 

Go to Layoiut ("Annual Report" (CUBMAIN)]

 

Show Custom Dialog[Message:"Field(s0 cannot be blank.!";  "OK";  "Cancel" ]

Exit Script

 

THANKS IN ADVANCE for all your help!

 

<!-- [if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif] --><!-- [if gte mso 9]><xml> <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:PunctuationKerning/>   <w:ValidateAgainstSchemas/>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:Compatibility>    <w:BreakWrappedTables/>    <w:SnapToGridInCell/>    <w:WrapTextWithPunct/>    <w:UseAsianBreakRules/>    <w:DontGrowAutofit/>   </w:Compatibility>   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif] --><!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:"";      margin:0in;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-fareast-font-family:"Times New Roman";} @page Section1      {size:8.5in 11.0in;      margin:1.0in 0in 1.0in 0in;      mso-header-margin:.5in;      mso-footer-margin:.5in;      mso-paper-source:0;} div.Section1      {page:Section1;} --><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable      {mso-style-name:"Table Normal";      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:"";      mso-padding-alt:0in 5.4pt 0in 5.4pt;      mso-para-margin:0in;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:10.0pt;      font-family:"Times New Roman";      mso-ansi-language:#0400;      mso-fareast-language:#0400;      mso-bidi-language:#0400;} </style> <![endif] -->

<!-- [if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"/> <v:formulas>   <v:f eqn="if lineDrawn pixelLineWidth 0"/>   <v:f eqn="sum @0 1 0"/>   <v:f eqn="sum 0 0 @1"/>   <v:f eqn="prod @2 1 2"/>   <v:f eqn="prod @3 21600 pixelWidth"/>   <v:f eqn="prod @3 21600 pixelHeight"/>   <v:f eqn="sum @0 0 1"/>   <v:f eqn="prod @6 1 2"/>   <v:f eqn="prod @7 21600 pixelWidth"/>   <v:f eqn="sum @8 21600 0"/>   <v:f eqn="prod @7 21600 pixelHeight"/>   <v:f eqn="sum @10 21600 0"/> </v:formulas> <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/> <o:lock v:ext="edit" aspectratio="t"/> </v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:657pt; height:621pt'> <v:imagedata src="file:///C:\DOCUME~1\adm-dba\LOCALS~1\Temp\msohtml1\01\clip_image001.png"   o:title=""/> </v:shape><![endif] --><!-- [if !vml] -->
<!-- [endif] -->
 

 

Outcomes