4D v13.4
Get last field number
- 4D Language Reference
-
- Structure Access
-
- Structure Access Commands
- CREATE INDEX
- DELETE INDEX
- Field
- Field name
- Get external data pathNew
- GET FIELD ENTRY PROPERTIES
- GET FIELD PROPERTIES
- Get last field number
- Get last table number
- GET MISSING TABLE NAMES
- GET RELATION PROPERTIES
- GET TABLE PROPERTIES
- Is field number valid
- Is table number valid
- REGENERATE MISSING TABLE
- RELOAD EXTERNAL DATANew
- SET EXTERNAL DATA PATHNew
- SET INDEX
- Table
- Table name
Get last field number
| Get last field number ( tableNum | tablePtr ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| tableNum | tablePtr | Longint, Pointer |
|
Table number or Pointer to table | |||||
| Function result | Longint |
|
Highest field number in table | |||||
The Get last field number command returns the highest field number among the fields in the table whose number or pointer you pass in tableNum or tablePtr.
Fields are numbered in the order in which they are created. If no field has been deleted from the table, then this command returns the number of fields that the table contains. In the case of iterative loops on the field numbers of the table, you must use the Is field number valid command in order to check whether the field has been deleted.
The following project method builds the array asFields, consisting of the field names, for the table whose pointer is received as first parameter:
$vlTable:=Table($1)
ARRAY STRING(31;asFields;Get last field number($vlTable))
For($vlField;Size of array(asFields);1;-1)
If(Is field number valid($vlTable;$vlField))
asFields{$vlField}:=Field name($vlTable;$vlField)
Else
DELETE FROM ARRAY(asFields;$vlField)
End if
End for
Product: 4D
Theme: Structure Access
Number:
255
Modified: 4D v11 SQL
Field name
GET FIELD PROPERTIES
Get last table number
Is field number valid
