views:

8

answers:

0

I have this query

    <udc:Query>select top 1
NTName, PreferredName, Email, Manager, 
dbo.custom_fn_GetPropertyValue(8, UserRecordID) as 'WorkPhone',
dbo.custom_fn_GetPropertyValue(13, UserRecordID) as 'Title',
dbo.custom_fn_GetPropertyValue(14, UserRecordID) as 'Department',
dbo.custom_fn_GetPropertyValue(10001, UserRecordID) as 'Personal TITle',
dbo.custom_fn_GetPropertyValue(11, UserRecordID) as 'Office',
dbo.custom_fn_GetPropertyValue(19, UserRecordID) as 'Cell Phone'
From 
custom_GetUserProfile_vw 
Where NTNAme = @AccountName
    </udc:Query>

but when I try to add this as a new data source in my InfoPath form it complains that the parameter @AccountName is not declared.

This is the first time I am working with InfoPath and a udcx file.

related questions