i'll make sure that gets fixed! Feel free to file a bug so i dont forget :)
On Saturday 04 September 2010 11:22:58 Noli Sicad wrote: > 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
