arnojansen1

Execute SQL function problem

Discussion created by arnojansen1 on May 14, 2016
Latest reply on May 30, 2016 by beverly

I am trying to get this to work but only get a ? mark as result so I know something is wrong.

 

This is what I use in a calculation field in Filemaker 14 pro advanced for MAC

calculation result is as text of number but it just doesn't work.

 

I am looking for a NettPrice in a table named ToursPricesTable where the primary key matches: TourPrice0441, the primary key has a number and is defined as a number field.

 

This query is in a table called itinerary

 

ExecuteSQL (

"SELECT NettPrice

FROM ToursPricesTable

where (_kp_ToursPricesTable)   =   TourPrice0441

"; ",";""; ToursPricesTable::NettPrice;ToursPricesTable::_kp_ToursPricesTable)

 

later I will make this more flexible with a selection on dates etc but first I need this to work.

 

Your help is appreciated as always

Cheers

Arno

Outcomes