Tornado API Library - V12.30.08

GetData.Get_FieldMatrix Method 

Get all the fields properties of an SQL in a 2-Dim array.

Product Version

All
[Visual Basic]
Public Function Get_FieldMatrix( _
   ByVal Unit As String _
) As String(,)
[C#]
public string[,] Get_FieldMatrix(
   string Unit
);

Return Value

Dim ret(,) as string = GD.Get_FieldMatrix(unit)

Remarks

Dim r As Integer, c As Integer
Dim Carr(,) As String = GD.Get_FieldMatrix("1")
Response.Write("<P><Center><H3>Export Field Matrix</H3><table class=ts cellspacing='1'>")
For r = 0 To UBound(Carr, 2)
   Response.Write("<tr>")
   For c = 0 To UBound(Carr, 1)
      If Carr(c, r) = "" Then Carr(c, r) = "&nbsp;"
      Response.Write("<td class=nr align=center>" & Carr(c, r) & "</td>")
   Next c
   Response.Write("</tr>")
Next r
Response.Write("</table></center>")

Matrix columns = fields

Matrix rows = 0:name, 1:type, 2:GridNameMap, 3:GridHeaderTag, 4:formula 5:FormNameMap 6:FormHeaderTag 7:raw type (number) 8:Hide 9:Type_String

See Also

GetData Class | Tornado Namespace | dbDebug