[Qt-interest] QSqlite Table not showing all rows in app

[Al]

Since we are top posting, I don't use qt but my sql code would be: 
'SELECT count(*) FROM tablename' to get the number of rows...

William Lugg wrote:
> Sorry, I should have included this info.  I'm using a QSqlTableModel.  Here is 
> the line of code I use to report the total rows in the model:
>
>    QString strRecordCount = " of "
>                             + QString::number( memberDataModel->rowCount() );
>
> I use a QDataWidgetMapper to map data to widgets.  I use 
> QDataWidgetMapper::toLast() and QDataWidgetMapper::toNext() to move forware in 
> the code in the following way:
>
>    // If we're not at the last record, move to the next record
>    if ( memberDataMapper->currentIndex() < memberDataModel->rowCount() )
>    {
>       memberDataMapper->toNext();
>       setRecordCounter();
>    }
>
> member_data_entry::setRecordCounter() looks like this:
> void member_data_entry::setRecordCounter()
> {
>    ui->txtRecordNum->
>          setText( QString::number( memberDataMapper->currentIndex() ) );
>    return;
> }
>
> It returns 255 when I'm on the "last" record, which makes sense given zero-
> based counting, but doesn't make sense given that there are 3100 records in 
> the table.
>
> Any help would be greatly appreciated.
> ----
> Bill Lugg
>   Milstar Software Support
>   Peterson AFB, CO
>   No Micro$oft products were used to create this email.  
>   God rules and if He needed a computer it would run Linux!
>
>
> On Saturday 06 February 2010 02:50:31 pm Robert Wood wrote:
>   
>> William Lugg wrote:
>>     
>>> In the DB app I'm working on, when I query the model for the row count
>>> it claims it only contains 256 rows, though SQLite and a GUI browser I
>>> use to look at the DB both verify that there are actually upwards of
>>> 3100 rows in the table. What do I need to do in my code to get at the
>>> rest of the data?
>>>
>>> The problem is two fold - I need my record counter to report the total
>>> number of records and I need to be able to navigate to those records
>>> when the user wants to go there.
>>>       
>> Not sure how much sqllite differs from mysql, but how are you querying
>> the size of the database? Can we have a peek at the relevant line of
>> code please?
>>
>> This works for me in mysql in that it does return the number of rows in
>> the table:
>>
>> QSqlQuery query;
>> quint32 rows;
>> QString queryString;
>>
>> queryString = "SELECT * FROM tablename"
>> query.exec(queryString);
>> rows = query.size();
>> _______________________________________________
>> Qt-interest mailing list
>> Qt-interest at trolltech.com
>> http://lists.trolltech.com/mailman/listinfo/qt-interest
>>     
>
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest
>