AnsweredAssumed Answered

Script search that return no rows?

Question asked by ChristianNissen on Mar 29, 2016
Latest reply on Mar 29, 2016 by ChristianNissen

Hi again,

 

I am trying to learn to master FM, from manuals and examples. I am greatly helped by "FM14 - the missing manual" creds to the people that wrote that!

 

Now I run into problems understanding whats needed to write a script that makes a selection like this SQL statement.

 

SELECT *

FROM debitering

WHERE kollad = "J"

 

I just cant make it work with the scriptwindow?

 

Scriptsearch1.png

To further complicate matters I have no idea on how to deselect the use of local language (in this case swedish) from the scripting?? I have written a separate question on that in these forums.

 

The script I am using would be the first scriptcommand in the list of "Searchresult" in the english version.

 

I would expect a returning list of all the rows in the small table above where "Kollad = "J"  instead I get nothing and on top of that an errormessage saying "No recs found, do You want to continue?".

 

I havent got a clue on how to write a functioning script, anybody who knows, or even better if anybody knows how to use real SQL statements in scripts?

 

I expect all scriptsuggestions in english as probably few of You are locked into the swedish FM-version

 

scriptsearch2.png

 

Cheers now!

 

Christian

Outcomes