Possible for SQL update to Notes?

HCL Domino Domino Forum
1

Is it possible to use some functionality on SQL server to update a Notes database?

2

Subject: Possible for SQL update to Notes?

Yes, you can use the NotesSQL ODBC driver to do an insert to a Notes database.

3

Subject: RE: Possible for SQL update to Notes?

Yes, I’m aware I can write custom script to do updates to Notes. But I am more interested in using SQL Server’s stored procedures to doing to actual updates. Like how would I pass parameters the stored procedures.

4

Subject: RE: Possible for SQL update to Notes?

To execute a store procedure with parameters, you would do something like this:

'execute stored procudure

	qry.SQL = {GetConfirmedLoads ?DateToday?}

	Set res.Query = qry

	Call res.SetParameter(1, {'} & Format$(Today, "mm/dd/yyyy") & {'})

	res.Execute              'execute SQL statement

where qry is your ODBCQuery object and res is the ODBCResultSet. “GetConfirmedLoads” is the name of the stored procedure and it is being passed today’s date.

hope that helps.

5

Subject: RE: Possible for SQL update to Notes?

How do I get the field values retrieved from SQL stored procedure. I would like to create a new Notes document and assign SQL’s field values to Notes fields.

6

Subject: RE: Possible for SQL update to Notes?

The data returned from a stored procedure is just like that from a standard SELECT query. Cycle through the result set as you normally would and use the res.GetValue (or comparable) method to get the value into Notes.

Hope that helps.

7

Subject: RE: Possible for SQL update to Notes?

Thank you very much that works perfectly!