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 );
}
