ultimatepp/uppsrc/MSSQL/MSSQL.h

#ifndef _MSSQL_MSSQL_h
#define _MSSQL_MSSQL_h

#include "ODBC/ODBC.h"

// debian: sudo apt-get install unixodbc-dev

namespace Upp {

String MsSqlTextType(int width);

typedef ODBCSession MSSQLSession;

inline
bool   MSSQLPerformScript(const String& text, StatementExecutor& executor,
                         Gate2<int, int> progress_canceled = false)
{
	return ODBCPerformScript(text, executor, progress_canceled);
}

void IdentityInsert(Sql& sql, const SqlInsert& ins);
void IdentityInsert(const SqlInsert& ins);

class MsSqlSequence : public ValueGen {
	const SqlId  *seq;
	SqlSession   *session;

public:
	virtual Value  Get();

	Value operator++()                                                  { return Get(); }

	void Set(const SqlId& id, SqlSession& s)                            { seq = &id; session = &s; }

#ifndef NOAPPSQL
	void Set(const SqlId& id)                                           { seq = &id; session = NULL; }

	MsSqlSequence(const SqlId& seq)                                     { Set(seq); }
	MsSqlSequence(const char *seq);
#endif
	MsSqlSequence(const SqlId& seq, SqlSession& s)                      { Set(seq, s); }

	MsSqlSequence()                                                     { seq = NULL; session = NULL; }
};

};

#endif