Not yet. To put it straight, so far SqlExp was designed for Oracle and will need further tweaks for other SQL engines.
Mirek
OFFSET-LIMIT clause is quite necessary in MySQL, SQLite and PostgreSQL.
So, could this code be put into next dev5 release?
into Sqlexp.h:
SqlSet& Limit(const unsigned int limit);
SqlSet& Limit(const unsigned int offset, const unsigned int limit);
SqlSet& Offset(const unsigned int offset);
into Sqlexp.cpp:
SqlSet& SqlSet::Limit(const unsigned int limit) {
text << " limit " << limit;
return *this;
}
SqlSet& SqlSet::Limit(const unsigned int offset, const unsigned int limit) {
text << " limit " << offset << ", " << limit;
return *this;
}
SqlSet& SqlSet::Offset(const unsigned int offset) {
text << " offset " << offset;
return *this;
}