C / C++ / MFC

Erudite_Eric wrote:

or doing something else odd in his code.

Richard MacCutchan wrote:

let's hope one of the driver experts sees this question tomorrow

vishalgpt wrote:

RtlZeroMemory

memset(quary_table, 0, sizeof(RTL_QUERY_REGISTRY_TABLE) * 2);

WCHAR *szTempLine = NULL;

wstring str;
getline(sqlDBFile, str, '\n');

// Load the SQL Server Commands
    std::wifstream *sqlDBFile = new std::wifstream;
    sqlDBFile->open(szFilePath);

    // if the file stream opened
    if (sqlDBFile->is_open() ) {

        // While file stream is in memory
        while (sqlDBFile->good() ) {
            // Make a temp sql command buffer
            WCHAR *pzSQLCommand = new WCHAR[1024];

            while (sqlDBFile->good() ) {
                // read the line of text
                WCHAR szAnsiBuffer[1024];
                sqlDBFile->getline(szAnsiBuffer, 1024, L'\n');

                int jdx = 0;
                WCHAR *szBufferLine = new WCHAR[1024];
                for (int i = 2; i < 1024; ++i) {
                    szBufferLine[jdx] = szAnsiBuffer[i];
                    i++;
                    jdx++;
                }
                int iLength = wcslen(szBufferLine);
                szBufferLine[iLength] = L'\0';

                // if text != GO, add to buffer
                if ((wcsncmp( szBufferLine, L"GO", wcslen(L"GO") )) != 0) {
                    wcsncat_s(pzSQLCommand, wcslen(pzSQLCommand), szBufferLine, wcslen(szBufferLine) );

                    pzSQLCommand[wcslen(pzSQLCommand) + 1] = L'\0';
                    break;
                }
                else {
                    // if text = GO, terminate the buffer and execute the buffered command
                    hr = pICommandText->SetCommandText( DBGUID_DBSQL, pzSQLCommand );
                    hr = pICommandText->QueryInterface( IID_ICommandProperties, ( void ** ) &pICommandProperties );
                    hr = pICommandText->Execute( NULL, IID_IRowset, NULL, &cRowsAffected, ( IUnknown ** ) &pIRowset );

                }
            }
        }

// read the line of text
WCHAR szAnsiBuffer[1024];
sqlDBFile->getline(szAnsiBuffer, 1024, L'\n');

int jdx = 0;
WCHAR *szBufferLine = new WCHAR[1024];
for (int i = 2; i < 1024; ++i) {
    szBufferLine[jdx] = szAnsiBuffer[i];
    i++;
    jdx++;
}
int iLength = wcslen(szBufferLine);
szBufferLine[iLength] = L'\0';

// read the line of text
WCHAR szBufferLine[1024];
sqlDBFile->getline(szBufferLine, 1024, L'\n');

WCHAR *pzSQLCommand = new WCHAR[1024];
*pzSQLCommand = L'\0';

wcsncat_s(pzSQLCommand, 1024, szBufferLine, wcslen(szBufferLine) );

+		szCommandLine	0x0012f0e0 "ÿþC"	wchar_t [1024]

CREATE TABLE [dbo].[BatchSettlementIndex] (
  [BatchID] int IDENTITY(1, 1) NOT NULL,
  [BatchName] varchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  [BatchDate] datetime NULL,
  [BatchAmount] decimal(10, 2) NULL
)
ON [PRIMARY]
GO

// Load the SQL Server Commands
    std::wifstream *sqlDBFile = new std::wifstream;
    sqlDBFile->open(szFilePath, std::wifstream::in);

    // if the file stream opened
    if (sqlDBFile->is_open() ) {

        // While file stream is in memory
        while (sqlDBFile->good() ) {
            // Make a temp sql command buffer
            WCHAR *pzSQLCommand = new WCHAR[1024];
            *pzSQLCommand = L'\0';

            while ( sqlDBFile->get() ) {
                // read the line of text
                WCHAR szCommandLine[1024];
                sqlDBFile->getline(szCommandLine, 1024, L'\n');


                // if text != GO, add to buffer
                if (szCommandLine != L"GO") {
                    wcsncat_s(pzSQLCommand, 1024, szCommandLine, wcslen(szCommandLine) );
                    break;
                }
                else {
                    // if text = GO, terminate the buffer and execute the buffered command
                    hr = pICommandText->SetCommandText( DBGUID_DBSQL, pzSQLCommand );
                    hr = pICommandText->QueryInterface( IID_ICommandProperties, ( void ** ) &pICommandProperties );
                    hr = pICommandText->Execute( NULL, IID_IRowset, NULL, &cRowsAffected, ( IUnknown ** ) &pIRowset );

                }
            }
        }

        // close the sql command file
        sqlDBFile->close();
        sqlDBFile = NULL;
    }