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.
WHERE kollad = "J"
I just cant make it work with the scriptwindow?
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