• (p) - Indicates that if Allow Precision Loss is not enabled, then an error will be generated on the type match. Allowing precision loss is the default.
• (o) - Indicates that overflow checking will be performed when data is being transferred. If an overflow occurs and Truncate Data When Necessary is enabled, then the data is truncated; if not, an error is generated.

Execute

Microsoft Access	Lotus Connector API (used by LEI and DECS)
BIT, YES/NO	Int
NUMBER BYTE	Int
NUMBER INTEGER	Int
NUMBER LONG INTEGER, COUNTER, AUTONUMBER (AutoNumber is set by FieldSize to 4, or 16 if FieldSize is set to Replication ID)	Int
NUMBER SINGLE	Float
NUMBER DOUBLE	Float
CURRENCY	Currency
DATE/TIME	Datetime
TEXT, VARCHAR	Text (variable length, bound <= 255)
LONGTEXT, MEMO, Hyperlink	Text (variable length, unbounded)
VARBINARY, BINARY	Binary (variable length, bound <= 510)
LONGBINARY, OLE OBJECT	Binary (variable length, unbounded)

Fetch

Microsoft Access	Lotus Connector API (used by LEI and DECS)
BIT, YES/NO	Int
NUMBER BYTE	Int
NUMBER INTEGER	Int
NUMBER LONG INTEGER, COUNTER, AUTONUMBER (AutoNumber is set by FieldSize to 4, or 16 if FieldSize is set to Replication ID)	Int
NUMBER SINGLE	Float
NUMBER DOUBLE	Float
CURRENCY	Currency
DATE/TIME	Datetime
TEXT, VARCHAR	Text (variable length, bound <= 255)
LONGTEXT, MEMO, Hyperlink	Text (variable length, unbounded)
VARBINARY, BINARY	Binary (variable length, bound <= 510)
LONGBINARY, OLE OBJECT	Binary (variable length, unbounded)

Insert/Update

Lotus Connector API (used by LEI and DECS)	Microsoft Access
Int	BIT, YESNO, NUMBER BYTE(o), NUMBER INTEGER(o), COUNTER, NUMBER LONG INTEGER, AUTONUMBER
Float	NUMBER SINGLE (p, o), NUMBER DOUBLE
Currency	CURRENCY
Datetime	DATETIME, DATE, TIME,
Text (variable length, bound <= 255)	TEXT (o), VARCHAR (o)
Text (variable length, unbounded)	LONGTEXT, MEMO, Hyperlink
Binary (variable length, bound <= 510)	BINARY (o), VARBINARY (o)
Binary (variable length, unbounded)	LONGBINARY, OLE OBJECT

Create

Lotus Connector API (used by LEI and DECS)	Microsoft Access
Int	BIT, YESNO, NUMBER BYTE(o), NUMBER INTEGER(o), COUNTER, NUMBER LONG INTEGER, AUTONUMBER
Float	NUMBER SINGLE (p, o), NUMBER DOUBLE
Currency	CURRENCY
Datetime	DATETIME
Text (variable length, bound <= 255)	TEXT (o), VARCHAR (o)
Text (variable length, unbounded)	LONGTEXT, MEMO, Hyperlink
Binary (variable length, bound <= 510)	BINARY (o), VARBINARY (o)
Binary (variable length, unbounded)	LONGBINARY, OLE OBJECT

Glossary

Help on Help

All Help Contents

Glossary

Help on Help