TSQLTable get fields name

array81 · 2012-01-06 20:20:09

I cannot find on TSQLTable object a mothod to get fields name, something like TSQLTable.GetFieldName(id: Integer);

Is there it?

ab · 2012-01-06 20:36:10

First row of the TSQLTable always contains the field names.

array81 · 2012-01-06 22:59:29

OK thanks

Leander007 · 2012-01-06 23:20:24

Small example:
First one (Get*) returns name of column (fetching first 0 indexed row, data is from 1 on).
Second one first un-camels name and potentially gets localized version of that text, if you use SQLite3i18n unit.

  var 
   table: TSQLTable;
   i: integer;

   (...)
   for i := 0 to table.FieldCount - 1 do
   begin
       writeln('col '+IntToStr(i)+' has name '+string(table.GetS(0,i))); 
       writeln('col '+IntToStr(i)+' has caption '+table.GetCaption(0,i)); 
   end;
   (...)

Last edited by Leander007 (2012-01-06 23:21:28)

mORMot Open Source

#1 2012-01-06 20:20:09

TSQLTable get fields name

#2 2012-01-06 20:36:10

Re: TSQLTable get fields name

#3 2012-01-06 22:59:29

Re: TSQLTable get fields name

#4 2012-01-06 23:20:24

Re: TSQLTable get fields name

Board footer