Synergize Enhanced SQL

Unlock the full potential of SQL

£0.00

Category:

Description

The Synergize enhanced SQL command provides significant benefits over the standard FileMaker SQL command.

SQL Errors 

If there is an error in the SQL Query, FileMaker returns a ?. This isn’t a very helpful error message, and you can be spending a lot of time debugging a relatively simple SQL statement to try and find a simple typo,

With the Synergize_ExecuteSQL function, Synergize attempts to report a meaningful error, showing you an approximation of where in the SQL statement the error may lie.

Using the FileMaker executeSQL the following statement would cause the following  error (?)

ExecuteSQL ( “SELECT Plugin_Name FROM Plugin” ;¶;¶ )

For a more detailed and useful error message

Synergize_ExecuteSQL ( “SELECT Plugin_Name FROM Plugin” ;¶;¶ )

Because the Synergize_ExecuteSQL  function returns a more detailed error message, it is much easier to debug the SQL statements.

ERROR: FQL0002/(1:24): The table named “Plugin” does not exist.

The above error indicates that on character position 24, the table plugin does not exist.

 

SQL Write Functions

The Filemaker SQL command provides read only (data retrieval) functionality. With the Synergize enhanced SQL, data can be written and modified.

// Synergize_ExecuteSQL( sqlStatement {; columnSeparator ; rowSeparator ; file ; parameters… } )

Synergize_ExecuteSQL( “INSERT INTO Jobs (Job_Number) Values (123456)”; )

// Synergize_ExecuteSQL( sqlStatement {; columnSeparator ; rowSeparator ; file ; parameters… } )

Synergize_ExecuteSQL( “UPDATE Jobs SET Job_Number=999999 WHERE Job_Number=123456”; )

// Synergize_ExecuteSQL( sqlStatement {; columnSeparator ; rowSeparator ; file ; parameters… } )

Synergize_ExecuteSQL( “DELETE FROM Jobs WHERE Job_Number=999999”; )

Reviews

There are no reviews yet.

Be the first to review “Synergize Enhanced SQL”

Your email address will not be published. Required fields are marked *