This tutorial will guide you, step-by-step, through the process of creating and debugging an Advantage Extended Procedure using Visual Basic .NET.
Visual Basic 6 (as opposed to VB .NET) all ActiveX DLLs run in a single-threaded apartment. This means all global variables are safe because only one Advantage thread can be calling a stored procedure at any instance. While this makes writing an AEP simple (no need to protect global variables from other threads), it can cause major performance problems in a multi-user environment. It is recommended you use VB .NET to write all Advantage Extended Procedures. While the code examples in this tutorial are written for VB .NET users, VB6 users will still find the tutorial itself informational.
Task 1: Copy Test Data and Application
Task 2: Create Your AEP Project
Task 3: Define Your AEP Function
Task 4: Add Startup and Shutdown Functions
Task 5: Implement Your Procedure Logic
Task 6: Build and Register Your Procedure for COM Usage
Task 7: Register Your Procedure in the Data Dictionary
Task 8: Test Your Procedure