USP_DATAFORMTEMPLATE_VIEW_ADDRESSLOOKUPANDVALIDATION
The load procedure used by the view dataform template "AddressLookupAndValidationCountries View Data Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @VALIDATIONCOUNTRIES | xml | INOUT | VALIDATIONCOUNTRIES |
| @ZIPLOOKUPCOUNTRIES | xml | INOUT | ZIPLOOKUPCOUNTRIES |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ADDRESSLOOKUPANDVALIDATION
(
@DATALOADED bit = 0 output,
@VALIDATIONCOUNTRIES xml = null output,
@ZIPLOOKUPCOUNTRIES xml = null output
)
as
set nocount on;
set @DATALOADED = 1;
set @VALIDATIONCOUNTRIES = dbo.UFN_COUNTRY_GETVALIDATIONCOUNTRIES_TOITEMLISTXML();
set @ZIPLOOKUPCOUNTRIES = dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES_TOITEMLISTXML();
return 0;