Surely i havent made a junior mistake like that! I'll check to see if something isnt being escaped, though i swear i thought it was :)
Adam On Saturday 04 September 2010 02:42:00 Noli Sicad wrote: > I think there is problem with reading the data, when the record has this > entry, > > Mr. Bill O'Neilly > > > WARNING: nonstandard use of \' in a string literal > LINE 1: INSERT INTO customer VALUES (14,'Mr ','Bill','O\''Neill','2... > ^ > HINT: Use '' to write quotes in strings, or use the escape string > syntax (E'...'). > > > Noli > > ````````````````````````` > > transaction<READ COMMITTED> committed more than once > kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > > || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, > > o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='barcode' AND > o_type=1 LIMIT 1" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "barcode_pkey" for table "barcode" > kexi(7247)/KexiDB KexiDB::Connection::querySingleString: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > "SELECT o_id FROM kexi__objects WHERE o_type=1 AND > lower(o_name)='barcode' LIMIT 1" > kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > > || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, > > o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='customer' > AND o_type=1 LIMIT 1" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "customer_pkey" for table "customer" > kexi(7247)/KexiDB KexiDB::Connection::querySingleString: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > "SELECT o_id FROM kexi__objects WHERE o_type=1 AND > lower(o_name)='customer' LIMIT 1" > kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > > || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, > > o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='item' AND > o_type=1 LIMIT 1" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "item_pkey" for table "item" > kexi(7247)/KexiDB KexiDB::Connection::querySingleString: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > "SELECT o_id FROM kexi__objects WHERE o_type=1 AND > lower(o_name)='item' LIMIT 1" > kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > > || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, > > o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderinfo' > AND o_type=1 LIMIT 1" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "orderinfo_pkey" for table "orderinfo" > kexi(7247)/KexiDB KexiDB::Connection::querySingleString: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > "SELECT o_id FROM kexi__objects WHERE o_type=1 AND > lower(o_name)='orderinfo' LIMIT 1" > kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > > || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, > > o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderline' > AND o_type=1 LIMIT 1" > kexi(7247)/KexiDB KexiDB::Connection::querySingleString: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > "SELECT o_id FROM kexi__objects WHERE o_type=1 AND > lower(o_name)='orderline' LIMIT 1" > kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > > || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name, > > o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='stock' AND > o_type=1 LIMIT 1" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "stock_pkey" for table "stock" > kexi(7247)/KexiDB KexiDB::Connection::querySingleString: > Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof() > "SELECT o_id FROM kexi__objects WHERE o_type=1 AND > lower(o_name)='stock' LIMIT 1" > transaction<READ COMMITTED> committed more than once > WARNING: nonstandard use of \' in a string literal > LINE 1: INSERT INTO customer VALUES (14,'Mr ','Bill','O\''Neill','2... > ^ > HINT: Use '' to write quotes in strings, or use the escape string > syntax (E'...'). _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
