QString qOrderByClause( const QSqlIndex & i, const QString& prefix = QString::null ) { QString str; int k = i.count(); if( k == 0 ) return QString::null; str = " order by " + i.toString( prefix ); return str; }
QString qOrderByClause(const QSqlIndex & i, const QString& prefix = QString()) { QString str; int k = i.count(); if(k == 0) return QString(); str = QLatin1String(" order by ") + i.toString(prefix); return str; }
bool Q3SqlCursor::select(const QString & filter, const QSqlIndex & sort) { QString fieldList(toString(d->nm)); if (fieldList.isEmpty()) return false; QString str(QLatin1String("select ") + fieldList); str += QLatin1String(" from ") + d->nm; if (!filter.isEmpty()) { d->ftr = filter; str += QLatin1String(" where ") + filter; } else d->ftr.clear(); if (sort.count() > 0) str += QLatin1String(" order by ") + sort.toString(d->nm); d->srt = sort; return exec(str); }
bool QSqlCursor::select( const QString & filter, const QSqlIndex & sort ) { QString fieldList = toString( d->nm ); if ( fieldList.isEmpty() ) return FALSE; QString str= "select " + fieldList; str += " from " + d->nm; if ( !filter.isEmpty() ) { d->ftr = filter; str += " where " + filter; } else d->ftr = QString::null; if ( sort.count() > 0 ) str += " order by " + sort.toString( d->nm ); d->srt = sort; return exec( str ); }