developerWorks

AIX and UNIX
Information Mgmt
Lotus
	New to Lotus
	Products
	How to buy
	Downloads
	Live demos
	Technical library
	Training
	Support
	Forums & community
	Events
Rational
Tivoli
WebSphere

Java™ technology
Linux
Open source
SOA and Web services
Web development
XML

My developerWorks
About dW
Submit content
Feedback

developerWorks > Lotus > Forums & community > Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum

Notes SQL Insert Appointment

Notes SQL Insert Appointment
Posted by Carl Richey on 1.Mar.12 at 11:33 PM using a Web browser
Category: Applications Development

Release: All Releases

Platform: All Platforms

What is the simplest way to add a new appointment via Notes SQL? The following SQL Statement returns the error listed afterwards:

INSERT INTO Appointment
(AppointmentType, StartDate, StartTime, EndDate, EndTime, Subject)
VALUES
('3', '2012-03-02', '08:00:00', '2012-03-02', '09:00:00', 'Hello World');

Error in ODBC SQL statement: Statement: [SQLSTATE=S1000][NATIVE=23502][Lotus][ODBC Lotus Notes][Lotus Notes Server]Notes API driver error: Value does not exist in keyword list for field AppointmentType

Return to top

Notes SQL Insert Appointment (Carl Richey 1.Mar.12)

. . RE: Notes SQL Insert Appointment (Brian Martin 2.Mar.12)

. . . . RE: Notes SQL Insert Appointment (Carl Richey 2.Mar.12)

. . . . . . RE: Notes SQL Insert Appointment (Brian Martin 8.Mar.12)

Document options

Print this page

Search this forum

Forum views and search

	Date (threaded)
	Date (flat)
	With excerpt
	Author
	Category
	Platform
	Release
	Advanced search

	Sign in
	Forgot your password?
	Forgot your user name?
	Create new registration

RSS feeds

	All forum posts RSS
	All main topics RSS
	More Lotus RSS feeds

Resources

	Forum use and etiquette
	Native Notes Access
	Web site Feedback

Lotus Support

	IBM Support Portal - Lotus software
	Lotus Support documents
	Lotus support by product
	Lotus support downloads
	Lotus support RSS feeds

Wikis

	IBM Composite Applications
	IBM Mashup Center
	IBM Connections
	IBM Docs
	IBM Forms
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud for Social Business
	IBM Web Experience Factory
	Lotus Domino
	Lotus Domino Designer
	Lotus Expeditor
	Lotus Foundations
	Lotus iNotes
	Lotus Instructor Community Courseware
	Lotus Notes
	Lotus Notes & Domino Application Development
	Lotus Notes Traveler
	Lotus Protector
	Lotus Quickr
	Lotus Symphony
	IBM Web Content Manager
	WebSphere Portal

Lotus Forums

	Notes/Domino 9.0
	Notes/Domino 8.5 + Traveler
	Notes/Domino XPages development forum
	Notes/Domino 8
	Notes/Domino 6 and 7
	Notes/Domino 4 and 5
	IBM Connections
	IBM Forms
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud Notes
	IBM SmartCloud Meetings
	IBM Web Content Manager
	Lotus Domino Document Manager
	Lotus e-learning
	Lotus Enterprise Integration
	Lotus Expeditor
	Lotus Protector
	Lotus Quickr
	Lotus SmartSuite
	Lotus Symphony
	Lotus Symphony Developer Toolkit Support
	Lotus Workflow