CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Threaded View

  1. #1
    Join Date
    Sep 2010
    Posts
    7

    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?
    Last edited by LoganFenix; October 14th, 2010 at 12:14 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured