FieldType

[Claudius Sailer]

Hi,

with V4RB1 I read FieldType with following code

Dim FieldType as string

FieldType=tmpDB.Table(i).Field(j).Type


and have a function which tells me format

   select case type
   case 2
     return "Boolean"
   case 3
     return "Byte"
   case 4
     return "Short"
   case 5
     return "UShort"
   case 6
     return "Long"
   case 7
     return "ULong"
   case 8
     return "Float"
   case 9
     return "Double"
   case 10
     return "String"
   case 11
     return "Unknown"
   case 12
     return "Date"
   case 13
     return "Time"
   case 14
     return "DateTime"
   case 15
     return "ObjectPtr"
   case 16
     return "Unknown"
   case 17
     return "Text"
   case 18
     return "Unknown"
   case 19
     return "Picture"
   case 20
     return "Unknown"
   case 21
     return "BLOB"
   case 22
     return "Medium"
   case 23
     return "UMedium"
   case 24
     return "FixedBinary"
   case 25
     return "VarBinary"
   case 26
     return "VarChar"
   case 27
     return "LLong"
   case 28
     return "ULLong"
   end select

but with V4RB2 it seems this is not longer correct. My datefields are  
shown as unknown and my VarChars are shown as nothing. Where can I  
find new correct solution?

thanks


Claudius

-- 
G4/733 QS / MacOS X 10.4de / RB 2005r4/ Valentina 1.10.0 & 2.0.4
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]