SQL::Connection::GetTemplateSyntaxScript()

Syntax

Sample_Script as C = SQL::Connection::GetTemplateSyntaxScript()

Argument

Description

Sample_Script

Reference material.

Description

The .GetTemplateSyntaxScript() method returns reference material useful when creating a custom syntax handler for AlphaDAO objects.

A user can implement a syntax script in its entirety by implementing all functions in the template and placing them in a text file in the Alpha Five binary folder called A5SQLSyntax<shortname>.ASQ .  Syntax scripts saved this way will show up in the SQL::Connection::ListSyntaxes() function.

Individual functions can be overridden by coding them in a string and calling SQL::Connection::SetSyntaxHandlerScript() on the connection to be affected.  Only one script is allowed at a time.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

Example

dim conn as SQL::Connection

conn.open("{A5API=Access,FileName='C:\Program Files\A5V8\MDBFiles\Alphasports.mdb',UserName='Admin'}")

? conn.GetTemplateSyntaxScript()

= ' Syntax Generation Script Template

'

'

' This script is provided without warranty for your use in creating a custom syntax handler for Alpha Five Data Access Objects

'...

See Also

SQL::Connection Object