[VCOM] Question: How to get the Field-Type?

[Ruslan Zasukhin]

On 21/10/07 5:12 PM, "blackfin" <blackfin at elfenherz.de> wrote:

Hi Martin,

> How to determine the Field-Type in VCOM?
> 
> Example:
> 
> Cursor := DB.sqlselect('SELECT * FROM T1') ;
> Cursor.Firstrecord() ;
> 
> Then, when I do a...
> 
> FieldType := Cursor.Field(index).type_ ;
> 
> ...I get an access violation.
> 
> I tried Fieldtype for every numeric type (as Integer, TOleNum, Cardinal
> etc ...), but none works, always an access violation.

Try split it on 2 lines:

    fld := Cursor.Field(index)

    FieldType := fld.type_ ;

And see if fld is not nil before you call .type




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]