One of the 2 wizards creates it
- I don't use the DB wizards, but here are the enumerated values in adovbs.inc from testing the wizards
'---- DataTypeEnum Values ----
Const adEmpty = 0
Const adTinyInt = 16
Const adSmallInt = 2
Const adInteger = 3
Const adBigInt = 20
Const adUnsignedTinyInt = 17
Const adUnsignedSmallInt = 18
Const adUnsignedInt = 19
Const adUnsignedBigInt = 21
Const adSingle = 4
Const adDouble = 5
Const adCurrency = 6
Const adDecimal = 14
Const adNumeric = 131
Const adBoolean = 11
Const adError = 10
Const adUserDefined = 132
Const adVariant = 12
Const adIDispatch = 9
Const adIUnknown = 13
Const adGUID = 72
Const adDate = 7
Const adDBDate = 133
Const adDBTime = 134
Const adDBTimeStamp = 135
Const adBSTR = 8
Const adChar = 129
Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203
Const adBinary = 128
Const adVarBinary = 204
Const adLongVarBinary = 205
--
| Stefan:
| There doesn't seem to be one in the web I created.
|
| --
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
|
http://www.spiderwebwoman.com/resources/
|
|
|
| > That covers the usual "default' types but not the variants of them
| > - see adovbs.inc
| >
| >
| > in message | >> Hi Ray:
| >> I created a database for testing purposes with every data type that
| >> Access offers, and found the following after I imported it into a FP
| >> web and created a DBRW page. If you find something different, or
| >> that I missed any, please let me know.
| >>
| >> Text = 202
| >> Memo = 203
| >> Number = 3
| >> Date/Time = 135
| >> Currency = 6
| >> AutoNumber = 3
| >> Yes/No = 11
| >> OLE Object = 205
| >> Hyperlink = 203
| >> Lookup Wizard = 202
| >>
| >> --
| >> ~ Kathleen Anderson
| >> Microsoft MVP - FrontPage
| >> Spider Web Woman Designs
| >>
http://www.spiderwebwoman.com/resources/
| >>
| >>
| >>
| >>> I've ascertained that there is a bug within DRW when it
| >>> writes the UPDATE query. It is to do with the s-
| >>> columntypes statement that it generates. I've discovered
| >>> that, for instance, if I have a text value in the UPDATE
| >>> SQL then I need to assign that field "202" in the s-
| >>> columntypes. But does anybody know where I can find the
| >>> values for all other field types, like Number, Memo and
| >>> Date, to name but a few.