c# - Retrieving error codes from SQLite when using ExecuteNonQuery() -

-

in c# project, i'm using system.data.sqlite.dll downloaded codeproject.

my problem per title - how error codes after calling sqlitecommand.executenonquery() function?

error codes such sqlite_constraint, sqlite_busy, sqlite_locked shown here.

use exception.stacktrace or sqliteexception.errorcode

try {  } catch(sqliteexception ex) {     string code = ex.errorcode; }

Comments

Post a Comment

Popular posts from this blog

Glib GIOChannel -

-
i'm trying tutorial on glib uses giochannel. i'm using ubuntu 11.04 (natty narwhal) glib-2.30.2 (gtk+-3.2.3) , c code. the code here: http://library.developer.nokia.com/index.jsp?topic=/guid-e35887bb-7e58-438c-aa27-97b2cde7e069/guid-817c43e8-9169-4750-818b-b431d138d71a.html the program runs contents of source test file not copied destination file. i'm not receiving error or warning messages. program nothing. what's wrong here? works now, changed line: g_print("usage:<cp source> <destination>\n"); to: g_print("usage: %s <source> <destination>\n", argv[0]); then compiled using: gcc -wall $(pkg-config --cflags gio-2.0) -c io.c gcc -wall $(pkg-config --libs gio-20) -o io io.o run program using: ./io io.c new_io.c
Read more

jsp - java.sql.SQLException: [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Expected 1 -

-
i'm calling inserstudent.jsp file in action of form addstudent.jsp want insert data in database. my database table's structure below: id|name|rollnumber|phonenumber|studyprogram|status below code inserstudent.jsp <%@page contenttype="text/html" pageencoding="utf-8"%> <%@ page import="java.sql.*" %> <!doctype html> <html> <body> <% string nam=request.getparameter("stuname"); string roll=request.getparameter("sturoll"); string phone=request.getparameter("stuphone"); string prog=request.getparameter("stuprogram"); string stats=request.getparameter("stustatus"); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); string url = "jdbc:odbc:stdprojectdatadsn"; connection c = drivermanager.getconnection(url); statement statement = c.createstatement() ; string sql = "insert students (id, name, rollnumb...
Read more

delphi - When I encode/decode SMS PDU (GSM 7 Bit) user data, do I need prepend the UDH first? -

-
while can encode , decode user data part of sms message when udh not present, i'm having trouble doing when udh is present (in case, concatenated sms). when decode or encode user data, need prepend udh text before doing so? this article provides encoding routine sample compensates udh padding bits (which still don't understand) doesn't give example of data being passed routine don't have clear use case (and not find decoding sample on site): http://mobiletidings.com/2009/07/06/how-to-pack-gsm7-into-septets/ . so far, have been able results if prepend udh user data before decoding it, suspect coincidence. as example (using values https://en.wikipedia.org/wiki/concatenated_sms ): udh := '050003000302'; encoded_user_data_part := 'd06536fb0dbabfe56c32'; // padding, evidently decodeduserdata := decode7bit(udh + encoded_user_data_part); writeln(decodeduserdata); output: "ß@ø¿Æ @hello world" encodeduserdata := encode7bit(decodeduse...
Read more