Advantage Database Server store procedures

[unixkd]

Hi all

How can we invoke the Advantage Database Server store procedures in our applications

Thanks

Joseph

[rdonnay]

Stored procedures are only available for .ADT files in a Data-Dictionary.

They cannot be invoked in your Xbase++ code.
They are instead invoked at the server whenever an update occurs to a table that has a stored procedure.

[unixkd]

What I need is the invocation of sp_* of ASD like:

EXECUTE PROCEDURE sp_GetTables( catalog,Character,200;
schemaPattern, Character,200;
tableNamePattern, Character,255;
Types,memo; )

Thanks

[rdonnay]

This can be done in a SQL script.

Have you read my white paper on this?

http://donnay-software.com:8080/donnay/adssql.zip