I have an external function which should work

SELECT
_ID
FROM
"Contacts" AS "_DB_Contacts"
JOIN "ELN" AS "_DB_ELN" ON "_DB_ELN"."_fkContacts" = "_DB_Contacts"."_ID"
WHERE
AttachSearch(_aList, _Encoding, ' CONTAINS ', 'sepura', 'Y') <<<<<<<<<<<<<<<<<<<<<<<<

I'm pretty sure it isn't. Is there a way to debug this as part of a query, in the IDE, in EDBManager? Or is my only chance to hook up a testbed?


Roy Lambert

Tim

I decided to start off by adding a few ShowMessage()s into the code but I find that EDBManager simply eats them. They display in my app so I can do something but its considerably more awkward. Any reason why EDBManager isn't displaying the ShowMessage from within my dll?

Roy Lambert

I am now very confused. After stopping and starting EDBManager several times, and having started and stopped my app several times I finally spotted what I think is the problem so I removed the showmessage()s from my dll, dropped the new version back with EDBManager and now it SHOWING the debug message from about 4 iterations ago.


What can be going on? I know its Vista but this is just weird.

Roy Lambert

Roy,

<< I am now very confused. After stopping and starting EDBManager several
times, and having started and stopped my app several times I finally spotted
what I think is the problem so I removed the showmessage()s from my dll,
dropped the new version back with EDBManager and now it SHOWING the debug
message from about 4 iterations ago.

What can be going on? I know its Vista but this is just weird. >>

Is it possible that you're dealing with different configuration paths than
what you think you are ?   You shouldn't be able to replace a .DLL that EDB
has loaded, so I'm not sure what the issue is.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< I'm pretty sure it isn't. Is there a way to debug this as part of a
query, in the IDE, in EDBManager? Or is my only chance to hook up a testbed?
>>

Just do a quick conversion to a script and feed the results of the query
without the WHERE clause to the script.  Then you can debug it in the EDB
script debugger.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Even with a delphi based external function? Sorry I should have made that clear.

Roy Lambert

Tim

>Is it possible that you're dealing with different configuration paths than
>what you think you are ? You shouldn't be able to replace a .DLL that EDB
>has loaded, so I'm not sure what the issue is.

That took a while to penetrate. External function dlls need to be in the same directory as the config not the executable. I know you can't see this but I am kicking myself. I know this, I did it that way for my app but forgot that EDBManager is just another app. DUH

Roy Lambert