to learn field's data type

[cihatkarli]

i'm using ado to access. And my app will read a user created db. And will create custom textboxes for different data types.

for example, i will modify my text box for date entry if field is a DATETIME field.

Any help appreciated.

 

[PatrickIRL]

You could put the data type in the tag property ...

 

[Andrzejek]

What about;

rst.Fields(3).Type
[green]'or[/green]
rst.Fields("MyFieldName").Type

Have fun.

---- Andy

 

[cihatkarli]

Great! Thanks

 

[cihatkarli]

uh sorry but returning values are not correct.

"202" value returns for both string and date :/

 

[Andrzejek]

I try this:

recOne.Open "SELECT * From MyTable", Cn

For i = 0 To recOne.Fields.Count
    Debug.Print recOne.Fields(i).Type & " - " & recOne.Fields(i).Name
Next i

recOne.Close

And after some manipulation I could get something like;

200 - VARCHAR2
131 - NUMBER
129 - CHAR
135 - DATE

Are you sure that the Field that you keep the Date in is acctually formated as DATE, not just CHAR type that you just keep the date in?



Have fun.

---- Andy

 

[cihatkarli]

rs.Fields.Item(i).Type

it should ne this way.

 

[BobRodes]

Huh?