|
Groups should request their database layouts using the
following or similar sceme. Then mail the request as an attachment mailed to Stuart. Table #1: Name
| Field Name |
Type |
Size |
| TableID |
Number (Long) |
- |
| Field1 |
Text |
40 |
| Field2 |
Date/Time |
- |
etc... |
|
|
| FieldN |
Yes/No |
- |
Notes:
1) Repeat Pattern for evey table requested.
2) Fields names should not contain spaces, punctuation, or special characters and should
start with a letter.
3) Use the following Table of Data Types
Commonly used column types
| Constant |
Value |
Access |
VB |
| adBoolean |
11 |
Yes/No |
Boolean |
| adTinyInt |
16 |
Number/Byte |
Byte |
| adSmallInt |
2 |
Number/Integer |
Integer |
| adInteger |
3 |
Number/Long |
Long |
| adCurrency |
6 |
Currency |
Currency |
| adDBTimeStamp |
135 |
Date |
Date/Time |
| adSingle |
4 |
Number/Single |
Single |
| adVarChar |
200 |
Text |
String |
| adLongVarChar |
201 |
Memo |
String |
CSC 96B http://www.valtara.com/CSC96B/
Copyright 1999, Valtara Data Design
|
|