CTI Client structures

Database queries

Configuration of the return type

Data from TAPIMaster®'s database interface can either be formatted as text or as XML. The format can be set on the "Database interface“ page of the server control panel.

XML-Format

Here is an example of a query sent to the example database contained in the "Database” folder of the programmer’s package. The query is:

SQLBegin(„SELECT * FROM Members",2)

The answer is:

<?xml version="1.0" standalone="yes"?>

<DATAPACKET Version="2.0">

<METADATA>

<FIELDS>

<FIELD tagname="MemberNumber" fieldtype="i4" />

<FIELD tagname="GivenName" fieldtype="string" WIDTH="40" />

<FIELD tagname="Surname" fieldtype="string" WIDTH="32" />

<FIELD tagname="DayOfBirth" fieldtype="datetime" WIDTH="19" />

<FIELD tagname="Tax" fieldtype="numeric" WIDTH="19" />

<FIELD tagname="VoteRights" fieldtype="i1" WIDTH="3" />

<FIELD tagname="DrivingLicense" fieldtype="boolean" />

<FIELD tagname="ThrowWidth" fieldtype="r8" WIDTH="53" />

</FIELDS>

</METADATA>

<ROWDATA>

<ROW>

<MemberNumber>1</MemberNumber>

<GivenName>Walter</GivenName>

<Surname>Miller</Surname>

<DayOfBirth>1962-11-14 00:00:00</DayOfBirth>

<Tax>15.5000</Tax>

<VoteRights>20</VoteRights>

<DrivingLicense>1</DrivingLicense>

<ThrowWidth>12.5</ThrowWidth>

</ROW>

<ROW>

<MemberNumber>2</MemberNumber>

<GivenName>Paul</GivenName>

<Surname>Smith</Surname>

<DayOfBirth>1959-12-26 00:00:00</DayOfBirth>

<Tax>12.0000</Tax>

<VoteRights>10</VoteRights>

<DrivingLicense>1</DrivingLicense>

<ThrowWidth>11.99</ThrowWidth>

</ROW>

</ROWDATA>

</DATAPACKET>

Text format

The data presented above take the following form in plain text:

{HEADER ColCount=8}

{COLUMNS (Type=4 Text=MemberNumber);(Type=12 Text=GivenName);(Type=12 Text=Surname);(Type=93 Text=DayOfBirth);(Type=2 Text=Tax);(Type=-6 Text=VoteRights);(Type=-7 Text=DrivingLicense);(Type=8 Text=ThrowWidth);}

{(Value0=1);(Value1=Walter);(Value2=Miller);(Value3=1962-11-14 00:00:00);(Value4=15.5000);(Value5=20);(Value6=1);(Value7=12.5);}

{(Value0=2);(Value1=Klaus);(Value2=Smith);(Value3=1959-12-26 00:00:00);(Value4=12.0000);(Value5=10);(Value6=1);(Value7=11.99);}

SQL data types

The table lists the types supported by the TAPIMaster® interface:

See also

Structures overview

Send feedback to TAPIMaster®

© 2020 Tino Kasubke. All rights reserved.