PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Implementation
  • 1. Including the files of the Pascal interface of WINDEV
  • 2. Including the HFSQL declarations
  • Declaration and initialization
  • 1. Declaring the HFSQL context and the working contexts of each file
  • 2. Initializing HFSQL contexts
  • 3. Loading the WINDEV library (WDL)
  • Running WINDEV codes from the external language
  • 1. Calling a WLanguage code
  • 2. Retrieving the events triggered in the WINDEV windows
  • Ending the application
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
We are going to call the elements developed in WINDEV (project, windows, ... analysis) from the Pascal language. The WLanguage code used from the external language will be dynamically compiled and run during its call.
This mode is illustrated in City.PAS (in Pascal format) supplied in the "ExternalLanguages\Pascal" sub-directory of the setup directory of WINDEV.
Implementation

1. Including the files of the Pascal interface of WINDEV

If you are using a database in your application, the first step consists in generating your analysis. In the description of this analysis, specify the programming language used as well as the directory that will contain the source files.
Via the generation, a program skeleton (*.pas) is generated. This operation will also create the .h file (see below) required to use your data files.
The following files must be included in a Pascal project in order to call the Pascal interface of WINDEV:
  • Squelet.PAS (contains the description of the analysis)
  • <AnalysisName>.H
  • WDHF.PAS
  • WINDEV.PAS
The .h and .pas files that describe the structure of the data files will be automatically generated by WINDEV when generating the analysis.

2. Including the HFSQL declarations

The .h and .pas files corresponding to the description of the analysis files must be added to the Pascal project. The declarations of data files are included in the file whose extension is .h.
For example, in the City.pas code (supplied with WINDEV in the "ExternalLanguages\Pascal" directory), these files are "CityPas.H" and "Squelet.PAS".
Declaration and initialization

1. Declaring the HFSQL context and the working contexts of each file

If the application must manage data files, a HFSQL working context must be declared as well as a working context for each data file.
These declarations are performed in the City.pas project via the following lines:
{------------- include of the descriptions of the files used --------------}
{ write for each file $I .WDR }
{$I CityPas.h} (* record    *)
var DP:typeDP;
var VI:typeVI;
{$F+} { compilation directive  $F+ mandatory at the beginning }
procedure HDescribeRecord;
{Describes each file of the analysis}
VAR
lArrItmST:array[0..1] of longint;
sTypeST: String;
lArrItmCI:array[0..1] of longint;
sTypeCI: String;
begin
lArrItmDP[0]:= 31; lArrItmDP[1]:= 3;
sTypeDP:= '11';
EL_HDescribeRecord(gCtx, stringtoptr('STATE'), 34,
longint(@lArrItmST[0]), 2, stringtoptr(sTypeST), @ST);
lArrItmVI[0]:= 41; lArrItmVI[1]:= 6;
sTypeVI:= '11';
EL_HDescribeRecord(gCtx, stringtoptr('CITY'), 47,
longint(@lArrItmCI[0]), 2, stringtoptr(sTypeCI), @CI);
End;
procedure HInit;
VAR
{Creating the context}
sAnalysisName:String;
sPassword:String;
begin
gCtx:= EL_CreateHFContext(2);
sAnalysisName:= 'CITYPAS.WDD';
sPassword:= ' ';
{Describing each record}
HDescribeRecord;
{Initializing HF}
CALLWD('HFCTX');
If EL_Hinitshare(gCtx,WDLong) = 0 Then
begin
CALLWD('Error,Error initializing the HF context');
End
{opening the analysis}
else
begin
If HOpenAnalysis(gCtx, sAnalysisName, sPassword, ' ', ' ', ' ') = 0 Then
begin
CALLWD('Error,Error opening the analysis');
End;
End;
End;

2. Initializing HFSQL contexts

If your application is calling a database, the access to HFSQL must be prepared now. The test below is used to check whether this initialization is performed properly:
{Creating the context}
begin
HInit;
End;

3. Loading the WINDEV library (WDL)

The WINDEV library (.WDL extension) contains all the project elements (windows, reports, classes, queries, analysis, ...). Therefore, it must be loaded in memory in order for its components to be called.
The load operation is performed by CALLWD('LIBRA,disk ...') as follows:
Caution: If the library to load contains windows, the code of each one of these windows must be included in the corresponding ".WDW" file ("Include the compiled code" must be checked in the "Details" tab of the description of each window).
begin{ Opening the library }
{ if WDInt is not null, the library was not found! }
CALLWD('LIBRA,disk,city.wdl'); { Open the library. }
if WDInt0 then
begin
{ Library not found }
CALLWD('Error,The CITY.WDL library must be found in the parent directory.');
{ indicate to WINDEV that the program will be ended }
{ use HFDone only if a HFSQL database is used }
HFDone;
WDEnd;
Halt;
end;
...
end;
Running WINDEV codes from the external language

1. Calling a WLanguage code

All the WLanguage functions can be called from the external language. The behavior of these WLanguage functions as well as the returned values are identical whether they are called:
  • from WINDEV or
  • from the interface of external language
To find out the parameters and the return values of a WLanguage function, see the online help or the documentation about WLanguage.
The call to a WLanguage procedure from the external interface is done via CallWD. For example:
open the first window of the program that contains the menu }
CALLWD('OPEN,menu.wdw);
You will notice that the parameter expected by CallWD is a character string containing the WLanguage code to run.
Like the WLanguage coded in WINDEV, this string is not case sensitive (uppercase/lowercase characters). Therefore, the "Info" command can also be written as "INFO".

2. Retrieving the events triggered in the WINDEV windows

The input in the WINDEV windows requires to retrieve the events triggered in these windows.
To retrieve the user events (click on a menu, on a button, and so on), you must implement a system based on a loop in your Pascal program. This loop will remain active as long as the WINDEV window is opened and it will be used to intercept each user action.
To find out the type of action performed by the user, you have the ability to use a character string variable (in WLanguage) named 'WDKey'. This variable will be used in your WLanguage code to signal to the Pascal program which button has been pressed for example.
Example: Pascal code
{ open the first window of the program that contains the menu }
CALLWD('OPEN,menu.wdw);
{ the program loops until the File Exit option }
{ is selected }
while( WDKey<>'ESC' ) do
begin
{ perform the input of the menu }
CALLWD('SCREEN,input');
{------------------------------------------------}
{ Decode the selected option.  }
{ WDString contains the sequence of shortcut letters }
{ that are used to select the menu choice }
{------------------------------------------------}
if( WDKey='FQ' ) then WDKey:='ESC';{ Exit              }
if( WDKey='RN' ) then FindCity;      { Search by City }
if( WDKey='RD' ) then FindState;      { Search by State }
if( WDKey='DD' ) then LstState;      { Display the list.    }
if( WDKey='DI' ) then LstPrint;     { Print.         }
if( WDKey='DC' ) then LstConfig;      { Configure the printout   }
end;
Code of "File .. Exit" of the WINDEV "Menu" window (WLanguage):
if( WDKey='FQ' ) then WDKey:='ESC';{ Exit from the loop }
When the user clicks "File .. Exit", WDKey will be returned to the Pascal code to perform the next action.
Ending the application
To end the use of the external interface, all you have to do is call HFDoneShare and WDDone that expect no parameter. For example:
{ Done... }
{ use HFDoneShare only if a HFSQL database is used }
HFDoneShare;
WDEnd;
end.
Minimum required version
  • Version 9
Comments
Click [Add] to post a comment