I removed the offending data and it is working now. The Kexi is not Irish friendly :- )
Thanks. Noli On 9/4/10, Adam Pigg <[email protected]> wrote: > 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
