PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → HFSQL type codes
HFSQL type codes
Iniciado por guest, 26,ago. 2015 22:40 - 2 respuestas
Publicado el 26,agosto 2015 - 22:40
hListItem returns the following:

<Name of Item 1> + TAB + <Type> + TAB + <HFSQL Type> + TAB + <Size> + TAB + <Number of Subscripts> + TAB + <Caption> + CR +

Does anybody know where I can find all the "HFSQL Type" codes? Such as:

2 - string
5 - int
11 - time
12 - radio button
17 - currency
etc

Searched here and in Google, no joy.

Thanks, Art
Publicado el 26,agosto 2015 - 22:52
Hi Art,

It's in the help for hListItem under Remarks:
The possible HFSQL types are as follows:

0 unknown type 1 automatic 8-byte identifier
2 text item 3 signed 2-byte integer item
4 signed 1-byte integer item 5 signed 4-byte integer item
6 simple real item (on 4 bytes) 7 simple real item (on 8 bytes)
8 record number item (unsigned integer) 9 unsigned 2-byte integer item
10 6-digit date item 11 time item
12 unsigned 1-byte integer item 13 turbo real item
14 8-digit date item 15 text memo item
16 binary memo 4.0 item 17 currency item
18 binary memo, image memo item,
Sound memo, OLE memo or other binary memo 19 signed 8-byte integer item
20 unsigned 8-byte integer item 21 image item
22 unsigned 4-byte integer item 23 character string item
24 date+time item 25 duration item
26 character item 27 boolean item
28 automatic identifier item (4 bytes) 29 Unicode text item
30 Unicode text memo item 31 high-precision numeric item

Regards,
Piet
Publicado el 27,agosto 2015 - 01:17
Thanks Piet, I have no idea how I missed that... :eek:



(mumbles to self... "I must be getting senile...")