Anonymous
Log on
Help
Lotus Notes and Domino wiki
All Wikis
Home
Community Articles
Product Documentation
Learning Center
Search Scope
All Content
Community Articles
Product Documentation
Learning Center
Lotus Notes 8.5.3 Documentation
Lotus Notes Traveler 8.5.3 Administration Documentation
Lotus Notes Traveler 8.5.3 Usage Documentation
--------------
Custom search scope...
Search for...
Search
Advanced Search
Categories
Tag Cloud
6.0
6.5
6.5.4
6.x
7.0
7.0.2
7.5
7.x
8.0
8.0.1
8.0.2
8.5
8.5.1
8.5.2
8.5.3
8.5.x
8.x
address
admin
administering
administration
administrator
attachment
best practice
Blackberry
cache
calendar
Client deployment
contacts
DAOS
database
database properties
db2
DCT
demo
deployment
deployment Notes
directory
document
documents
Domino
Domino Server
Domino Web Access
dwa
email
getting started
http
IMAP
inotes
install
iPhone
LDAP
logging
Lotus iNotes
Lotus Notes
Lotus Notes Traveler
Lotus Traveler
mail
mail file
max
media_notes
memory
message
messaging
MIME
moving_advanced
moving_cal
moving_mail
ND6
notes
Notes ID Vault
notes.ini
NotesBench
performance
plug-ins
Policies
preferences
R5
reference card
replication
router
Sametime
search
Security
server
smtp
table
text
tips
to do
Traveler
troubleshooting
upgrade
user
using
video
videofest
web
Widgets and Live Text
Windows
Information
You are currently viewing machine translated content. IBM translation might be available. Click
IBM Translated Product Documentation
to see what is available.
X
Edit Article
Add an Article
Share
Email
Facebook
Twitter
LinkedIn
Delicious
Digg
StumbleUpon
Print
Print article only
Print article and comments
Subscribe
Recent Edits to this Article
Recent Added Comments to this Article
Home
>
Uncategorized >
LS:DO / lsxodbc Constants
LS:DO / lsxodbc Constants
Abstract
Abstract
LotusScript constants for LS:DO / lsxodbc are contained within the LSX and are not documented. This article is intended to be a reference to some known constant values.
SQL Data Types
Constant
Value
SQL_CHAR
1
SQL_NUMERIC
2
SQL_DECIMAL
3
SQL_INTEGER
4
SQL_SMALLINT
5
SQL_FLOAT
6
SQL_REAL
7
SQL_DOUBLE
8
SQL_DATE
9
SQL_TIME
10
SQL_TIMESTAMP
11
SQL_VARCHAR
12
SQL_BINARY
-2
SQL_SQL_VARBINARY
-3
SQL_LONGVARCHAR
-1
SQL_LONGVARBINARY
-4
SQL_BIGINT
-5
SQL_TINYINT
-6
SQL_BIT
-7
LS:DO Data Types
Constant
Value
DB_TYPE_UNDEFINED
0
DB_CHAR
1
DB_SHORT
2
DB_LONG
3
DB_DOUBLE
4
DB_BINARY
5
DB_BOOL
6
DB_DATE
7
DB_DATETIME
8
DB_TIME
9
FieldInfo Array Index Constants
Constant
Value
DB_INFO_COLUMNNAME
1
DB_INFO_TABLENAME
2
DB_INFO_COLUMNID
3
DB_INFO_COMPUTED
4
DB_INFO_NATIVE_DATATYPE
5
DB_INFO_EXPECTED_DATATYPE
6
DB_INFO_LENGTH
7
DB_INFO_DISPLAYSIZE
8
DB_INFO_PRECISION
9
DB_INFO_SCALE
10
DB_INFO_NULLABLE
11
DB_INFO_UNSIGNED
12
DB_INFO_MONEY
13
DB_INFO_AUTOINCREMENT
14
DB_INFO_CASESENSITIVE
15
DB_INFO_SEARCHABLE
16
DB_INFO_READONLY
17
DB_INFO_SETTABLE
18
DB_INFO_SQLDATATYPE
19
Article information
Article information
Category:
Uncategorized
Tags:
LS:DO
,
lsxodbc
,
Constants
,
LotusScript
This Version:
Version
13
February 17, 2012
2:18:36 PM
by
Rob Darwin
Edit Article
Attachments (0)
Attachments (0)
Versions (13)
Versions (13)
Version Comparison
Compare version
Current 13
12
11
10
9
8
7
6
5
4
3
2
1
with version
Current 13
12
11
10
9
8
7
6
5
4
3
2
1
Compare selected versions
Version
Date
Changed by
Summary of changes
This version (13)
Feb 17, 2012 2:18:36 PM
Rob Darwin
12
Feb 17, 2012 2:14:50 PM
Rob Darwin
11
Feb 17, 2012 2:14:19 PM
Rob Darwin
10
Feb 17, 2012 2:13:39 PM
Rob Darwin
9
Feb 17, 2012 2:12:13 PM
Rob Darwin
8
Feb 17, 2012 2:11:49 PM
Rob Darwin
7
Feb 17, 2012 2:10:46 PM
Rob Darwin
6
Feb 17, 2012 2:10:15 PM
Rob Darwin
5
Feb 17, 2012 2:09:00 PM
Rob Darwin
4
Feb 17, 2012 2:08:23 PM
Rob Darwin
3
Feb 17, 2012 2:07:11 PM
Rob Darwin
2
Feb 17, 2012 2:05:47 PM
Rob Darwin
1
Feb 17, 2012 1:55:08 PM
Rob Darwin
Comments (0)
Comments (0)
Add comment
Copy and paste this wiki markup to link to this article from another article in this wiki.
Link:
Close