Devart Forums

Code: Select all

//---------------------------------------------------------------------------

#include 
#include 
#include 
#include 

#pragma hdrstop

//---------------------------------------------------------------------------

#pragma argsused
int main(int argc, char* argv[])
{
	int r = 0;
	try {
		std::auto_ptr connector;
		connector.reset( new TSQLConnection(0) );

		std::cout LoginPrompt = false;
		connector->KeepConnection = true;

		connector->DriverName = "Oracle (Core Lab)";
		connector->LibraryName = "dbexpoda40.dll";
		connector->VendorLib = "oci.dll";
		connector->GetDriverFunc = "getSQLDriverORA";

		connector->Params->Values["BlobSize"] = "-1";
		connector->Params->Values["Database"] = "TNS_NAME";
		connector->Params->Values["User_Name"] = "USERNAME";
		connector->Params->Values["Password"] = "PASSWORD";

		connector->Open ();

		std::cout  query;
		query.reset( new TSQLQuery(0) );
		query->SQLConnection = connector.get();
		query->Active = false;

		query->SQL->Text = "INSERT INTO DS_DEBUG(ID_SESSION, TS_DEBUT) "
						   "              VALUES(:P_SESSION, :P_DEBUT) ";

		query->ParamByName("P_SESSION")->AsString = "093B3DD5-2DD6-408A-949C-4A74F7F43CD7";
		query->ParamByName("P_DEBUT")->AsDateTime = Now();

		std::cout StartTransaction(transaction);
		query->ExecSQL();
		std::cout Rollback (transaction);
		std::cout CloseDataSets();
		connector->Close ();
        std::cout > end;

	return r;
}
//---------------------------------------------------------------------------

Code: Select all

query->ParamByName("P_DEBUT")->AsSQLTimeStamp = DateTimeToSQLTimeStamp(Now());