I have a Problem with Insert in Lotus Notes from C #
Good Morning:
A few days ago I did a favor to help me with a C # to insert data into a Lotus Notes application. This application worked well, but the following problem arose in combobox Lotus Notes uses a validation that does not create new fields in the catalog of the combobox.
This validation does not allow passing the new data but should be allowed to pass the data that are equal in both catalogs.
sqlCadena = "Insert Into Application (estado) values ('" rowLotus ["ESTADO"]. ToString () "')";
Cmd = new OdbcCommand (sqlCadena, Conn);
Cmd.ExecuteNonQuery ();
I mark the following error:
System.Data.Odbc.OdbcException detected
Message="ERROR [HY000] [Lotus][ODBC Lotus Notes][Lotus Notes Server]Notes API driver error: Value does not exist in keyword list for field Estado"
Source="NSQLV32.DLL"
ErrorCode=-2146232009
StackTrace:
en System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
en System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
en System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
en System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
en LOTUS.Form1.button4_Click(Object sender, EventArgs e) en C:\Documents and Settings\mphinder\Escritorio\lotus3\LOTUS\Form1.cs:línea 196
InnerException:
I have searched this error but nobody shares a solution. Do any of you could help me?
Re: I have a Problem with Insert in Lotus Notes from C #
Hello,
I have to make a script that insert data in lotus notes through php.
Please someone help me out.. how should I do this.. very urgent.
Thanks,
Ashutosh
Q3 technology, India