GetFieldTableType()

Summary

Gets the data type of a field in tables and joined views.

 

Changes

In Version 2013 added field types "Date", "Time", and "DateTime."

 

Syntax

field_type = GetFieldTableType(string field_spec)

 

Argument	Contents
field_spec	A field spec

 

Returns

A string denoting the data type of the field:

 

String	Description
Short	Short (1- or 2-byte) integer
Integer	Long (4-byte) integer
Float	4-byte real
Real	8-byte real
String	Character field
Date	4-byte date
Time	4-byte time
DateTime	8-byte date and time

 

Notes

• The data type of a field cannot be changed in any way, unless the underlying data file is changed using ModifyTable().

• GetFieldTableType() can be used for joined views.

Example

typ = GetFieldTableType("States.Name")     // typ = "String"

 

Error Codes

Error Type	Meaning
Error	The input field specification is ambiguous
NotFound	The input field does not exist

 

See Also

Function	Summary
GetFieldInfo()	Returns the data type, display width, decimals, and index flag for a field
GetFieldType()	Gets the data type of a field
GetTableStructure()	Gets a list and description of the fields in a table