MS Query and Table-value functions

[ChrisLane]

Hi All

Is it possible to call a TBF in MS Query?

I tried

select *
from dbo.Report_ImportCartageAndDelivery

but received the error "Parameters were not supplied for the function ...... Statements count not be prepared"

I then tried adding parameters like the following, but received the error "Could not add the table 'dbo.Report_ImportCartageAndDelivery(<company'."

select *
from dbo.Report_ImportCartageAndDelivery(<company country="" code="">, <companypk>, <delivery status="">, <include job="" types="">, 'Other', <discharge port="">,<eta.fromdate>,<eta.tonextdate>,<vessel journey.code="">,<flight voyage="">, <shipment transport="">, <declaration transport="">, <shipment cont="">, <declaration cont="">)<company country="" code=""><companypk><delivery status=""><include job="" types=""><discharge port=""><eta.fromdate><eta.tonextdate><vessel journey.code=""><flight voyage=""><shipment transport=""><declaration transport=""><shipment cont=""><declaration cont="">

I would appreciate any advice on this issue?
Many thanks


</declaration></shipment></declaration></shipment></flight></vessel></eta.tonextdate></eta.fromdate></discharge></include></delivery></companypk></company></declaration></shipment></declaration></shipment></flight></vessel></eta.tonextdate></eta.fromdate></discharge></include></delivery></companypk></company></company'."

 

[Kyle123]

Are the params correct?

 

[ChrisLane]

Hi Kyle
Sorry for delay in responding. I have checked them and they seem correct. Is MS Query able to run/call TBF's?