Product Home
DTM Data Generation SDK Online Documentation
Product Profile
SDK components
Functions map
Low level API
Short Random
Integer Random
Random Symbol
Double Random
Random String
Random Date
Random Time
C/C++ example
Fill Methods level API
From list
From file
From table
From Values Library
Incremental
By maks
By SQL statement
Rule level API
Rule properties
Rule items
One rule item
Project level API
Project operations
Project properties
Project rules
Object handles
Database connection
Error handling
SDK limitations
Build application with SDK
License agreement

By SQL Statement fill method

SQL Statement Initialization
C/C++
DG_HANDLE InitStatement(DG_HANDLE connection, char *SQL)

C#/VBA/scripts
int InitStatement(int connection, string SQL)
'connection' is valid handle generated by ConnectDB function.
'SQL' is SQL statement definition like 'select AuthorID from Authors order by Name'.

Generate value
C/C++
char* StatementValue(DG_HANDLE handle,int sequentially)

C#/VBA/scripts
string StatementValue(int handle,int sequentially)
Not 0 'sequentially' value means the function will return values from the query results sequentially, random otherwise.

Note: this fill method does not supported by core SDK edition.