Hello,

I have added "ExtractText" custom function to SQL and declarated this function in DBISAM engine.
Everything worked fine till today, now DBISAMEngineCustomFunction event is never fired when
DBISAM sql parser execute my ExtractText custom function, instead I get sql error below.


...raised exception class EDBISAMEngineError with message 'Engine Error # 11949 SQL parsing error - Expected ) but instead found ( in INSERT SQL statement at line 63, column 62'.
Process stopped. Use Step or Run to continue.

My full sql is

INSERT INTO "document" (ArticleID,SearchText,Binary,Description,Extension,Default,Link)
select ArticleID,ExtractText(Binary,Extension,Link),Binary,Description,Extension,false,Link from Attachment;



Regards,
Mike

Mike,

<< I have added "ExtractText" custom function to SQL and declarated this
function in DBISAM engine. Everything worked fine till today, now
DBISAMEngineCustomFunction event is never fired when DBISAM sql parser
execute my ExtractText custom function, instead I get sql error below. >>

Did you double-check the TDBISAMEngine component and make sure that your
custom function is still declared properly with the correct number of
parameters ?  Also, do you have column name called "ExtractText" anywhere ?

--
Tim Young
Elevate Software
www.elevatesoft.com

<<Did you double-check the TDBISAMEngine component and make sure that your
custom function is still declared properly with the correct number of
parameters ?  >>

Yes, declaration is correct.

<<Also, do you have column name called "ExtractText" anywhere ?>>

ExtractText is a custom function which I want to call from SQL and pass it to
OnCustomFunction event.

Is something wrong with declaration?

Mike


I think Tim was concerned that if you have a field called ExtractText and a function called ExtractText the engine would ge confused.

Roy Lambert

Roy,

<< I think Tim was concerned that if you have a field called ExtractText and
a function called ExtractText the engine would ge confused. >>

Yes, that was it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mike,

<< ExtractText is a custom function which I want to call from SQL and pass
it to OnCustomFunction event. >>

As Roy indicated, I was asking whether you might have *both* a column and a
function named ExtractText.  My apologies for not being more clear.  As for
the issue, I double-checked and DBISAM will use the custom function before a
column with the same name anyways, so that wouldn't account for the problem,
which leaves the definition of the function parameters in the TDBISAMEngine
component as the culprit.  Did you double-check the parameters to ensure
that the count was correct ?

--
Tim Young
Elevate Software
www.elevatesoft.com

I have changed custom function name and re-entrered it into DBISAM engine after
that problem is gone. Thanks for help!

Mike,

<< I have changed custom function name and re-entrered it into DBISAM engine
after that problem is gone. Thanks for help! >>

Good, I'm glad that you solved the problem.

--
Tim Young
Elevate Software
www.elevatesoft.com