Topic: SQL query to find record throws error for expected ;
cbScene is a combobox which is linked to foreign key SceneCharacter.id_Scene, which points to Scene.id
txtNumber is an edit box
Here is my script: (inside the Closeup event for cbScene)
tablegrid1 := SELECT number FROM Scene WHERE Scene.ID = '{cbScene}';
When I run the program, I get the error: ';' exptect at 7:21.
This query works fine if it is placed as the action for a command button.