IBCScript and Comments

[SeaCay]

Hi

When I generate an InterBase script internally in Delphi code, I like to comment the script with critical info such as Date and time, program version info, function of the script and reason for creation. eg at top of script

• /**************************************/
  /* Date: 23rd June 2007 */
  /* Time: 11:53 */
  /* Program: MyProg V1.2.3.4 */
  /* Script rebuilds xyz table */
  /* User requested initialization */
  /**************************************/

at the end of the script I add three lines

• /* End of Script - Create table xyz */

Running the script through IBCScript i get an error message relating to the comments at the end of the script

The error message is

• Dynamic SQL Error
  SQL Error code = 104
  Unexpected end of command - line 0, column -11423

I have removed the comments at the end of script prior to execution and the script runs cleanly.

can you confirm my findings please and if so, correct the problem. Also, can you add IBCScript property to specify what constitutes comments including singular comments eg // and comment wrappers such as /* */

regards

SeaCay

[Alex]

We will support commentary statements in the IBCScript component in the next IBDAC build.
As to the // commentary definition is not supported by InterBase/Firebird server, so IBCScript will not support it either.