For binding purpose i'm using the followng query--
"INSERT INTO table_bank (Name,Balance,Withdraw,Address) VALUES (?,?,?,?)";
but when i'm going to bind a 5th parameter like
"INSERT INTO b1 (Name,Balance,Withdraw,Address,DateTime) VALUES (?,?,?,?,?)";
i observed-
- No compilation error.
- Not adding any thing to database even the rest 4 parameters which were adding to database earlier .
I just want to know whether is there any insertion limit or any thing i'hv to change with my Query.
Also i'hv attached the code stuff as i'm using .Please find the same .txt file.
Please let me know soon.
Code:
// DBApplicationDlg.cpp : implementation file
//
#include "stdafx.h"
#include "DBApplication.h"
#include "DBApplicationDlg.h"
#include <windows.h>
#include <sqlext.h>
#define LENGTH 200
#define LENGTH_COL 100
#ifdef _DEBUG
#define new DEBUG_NEW
#endif
/////////////////////////////////////////
////////////////////////////////////////////Global Declaration ////////////////////////////////Litu SQL Query ...................
HENV hEnv = NULL;
HDBC hDBC = NULL;
HSTMT hStmt = NULL;
UCHAR szDSN[SQL_MAX_DSN_LENGTH] = "BankInfo";
UCHAR* szUID = NULL;
UCHAR* szPasswd = NULL;
UCHAR szSqlStr[250]= "Select * From b1";
UCHAR szSqlStrPre[250]= "INSERT INTO b1 (Name,Balance,Withdraw,Address,DateTime) VALUES (?,?,?,?,?)";
UCHAR szSqlStrSel[250]="SELECT Name FROM b1";
RETCODE retcode;
CString date;
////////////////////////////////////////////////////////////////////////Global Declaration End/////////////////////////////Litu
// CAboutDlg dialog used for App About
class CAboutDlg : public CDialog
{
public:
CAboutDlg();
// Dialog Data
enum { IDD = IDD_ABOUTBOX };
protected:
virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support
// Implementation
protected:
DECLARE_MESSAGE_MAP()
};
CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
}
void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
}
BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
END_MESSAGE_MAP()
// CDBApplicationDlg dialog
CDBApplicationDlg::CDBApplicationDlg(CWnd* pParent /*=NULL*/)
: CDialog(CDBApplicationDlg::IDD, pParent)
{
m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}
void CDBApplicationDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
DDX_Control(pDX, IDC_EDIT1, m_name);
DDX_Control(pDX, IDC_EDIT2, m_Balance);
DDX_Control(pDX, IDC_EDIT3, m_Withdraw);
DDX_Control(pDX, IDC_EDIT4, m_Addss);
DDX_Control(pDX, IDC_EDIT6, m_date);
DDX_Control(pDX, IDC_EDIT5,m_test);
DDX_Control(pDX, IDC_LIST1, m_fieldList);
}
BEGIN_MESSAGE_MAP(CDBApplicationDlg, CDialog)
ON_WM_SYSCOMMAND()
ON_WM_PAINT()
ON_WM_QUERYDRAGICON()
//}}AFX_MSG_MAP
// ON_EN_CHANGE(IDC_EDIT4, &CDBApplicationDlg::OnEnChangeEdit4)
ON_BN_CLICKED(IDC_BUTTON1, &CDBApplicationDlg::OnBnClickedButton1)
// ON_EN_CHANGE(IDC_EDIT1, &CDBApplicationDlg::OnEnChangeEdit1)
ON_BN_CLICKED(IDC_BUTTON2, &CDBApplicationDlg::OnBnClickedButton2)
ON_BN_CLICKED(IDC_BUTTON4, &CDBApplicationDlg::OnBnClickedButton4)
ON_BN_CLICKED(IDC_BUTTON3, &CDBApplicationDlg::OnBnClickedButton3)
END_MESSAGE_MAP()
// CDBApplicationDlg message handlers
BOOL CDBApplicationDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// Add "About..." menu item to system menu.
// IDM_ABOUTBOX must be in the system command range.
ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
ASSERT(IDM_ABOUTBOX < 0xF000);
CMenu* pSysMenu = GetSystemMenu(FALSE);
if (pSysMenu != NULL)
{
CString strAboutMenu;
strAboutMenu.LoadString(IDS_ABOUTBOX);
if (!strAboutMenu.IsEmpty())
{
pSysMenu->AppendMenu(MF_SEPARATOR);
pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
}
}
// Set the icon for this dialog. The framework does this automatically
// when the application's main window is not a dialog
SetIcon(m_hIcon, TRUE); // Set big icon
SetIcon(m_hIcon, FALSE); // Set small icon
// TODO: Add extra initialization here
m_name.SetFocus(); ////////////Litu
m_test.ShowWindow(0);
int day, month, year;
int hour, minute,sec;
CTime currentTime = CTime::GetCurrentTime();
day = currentTime.GetDay();
month = currentTime.GetMonth();
year = currentTime.GetYear();
hour = currentTime.GetHour();
minute = currentTime.GetMinute();
sec=currentTime.GetSecond();
//date.Format(" date- %d/%d/%d Time- %d:%d:%d",day,month,year,hour,minute,sec);
date = "678";
return TRUE; // return TRUE unless you set the focus to a control
}
void CDBApplicationDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
if ((nID & 0xFFF0) == IDM_ABOUTBOX)
{
CAboutDlg dlgAbout;
dlgAbout.DoModal();
}
else
{
CDialog::OnSysCommand(nID, lParam);
}
}
// If you add a minimize button to your dialog, you will need the code below
// to draw the icon. For MFC applications using the document/view model,
// this is automatically done for you by the framework.
void CDBApplicationDlg::OnPaint()
{
if (IsIconic())
{
CPaintDC dc(this); // device context for painting
SendMessage(WM_ICONERASEBKGND, reinterpret_cast<WPARAM>(dc.GetSafeHdc()), 0);
// Center icon in client rectangle
int cxIcon = GetSystemMetrics(SM_CXICON);
int cyIcon = GetSystemMetrics(SM_CYICON);
CRect rect;
GetClientRect(&rect);
int x = (rect.Width() - cxIcon + 1) / 2;
int y = (rect.Height() - cyIcon + 1) / 2;
// Draw the icon
dc.DrawIcon(x, y, m_hIcon);
}
else
{
CDialog::OnPaint();
}
}
// The system calls this function to obtain the cursor to display while the user drags
// the minimized window.
HCURSOR CDBApplicationDlg::OnQueryDragIcon()
{
return static_cast<HCURSOR>(m_hIcon);
}
void CDBApplicationDlg::OnBnClickedButton1()
{
// Allocate memory for ODBC Environment handle
SQLAllocEnv (&hEnv);
// Allocate memory for the connection handle
SQLAllocConnect (hEnv, &hDBC);
// Connect to the data source "BankInfo" using userid and password.
retcode = SQLConnect (hDBC, szDSN, SQL_NTS, szUID, SQL_NTS, szPasswd, SQL_NTS);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
// Allocate memory for the statement handle
retcode = SQLAllocStmt (hDBC, &hStmt);
CString nm ,ads,bal,wdr;//,date;
m_name.GetWindowText(nm);
m_Balance.GetWindowText(bal);
m_Withdraw.GetWindowText(wdr);
m_Addss.GetWindowText(ads);
/*int day, month, year;
int hour, minute;
CTime currentTime = CTime::GetCurrentTime();
day = currentTime.GetDay();
month = currentTime.GetMonth();
year = currentTime.GetYear();
hour = currentTime.GetHour();
minute = currentTime.GetMinute();
date.Format(" Date- %d/%d/%d Time- %d:%d",day,month,year,hour,minute);*/
CString testvalue ;
m_test.GetWindowText(testvalue);
TCHAR nme[LENGTH], addss[LENGTH],datetime[LENGTH];
TCHAR blnce[LENGTH],wdrw[LENGTH];
SDWORD cname, cbalnce, cwithdraw,caddress,cdttm;
// SDWORD count;
retcode = SQLPrepare(hStmt,szSqlStrPre,sizeof(szSqlStrPre));////////////////////Litu prepare
//retcode = SQLPrepare(hStmt,szSqlStr,sizeof(szSqlStr));
cname = SQL_NTS; /* null terminated string */
cbalnce = 0;
cwithdraw = 0;
caddress=SQL_NTS;
//cdttm=SQL_DATA_AT_EXEC;
retcode = SQLBindParameter(hStmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_CHAR, LENGTH, 0,nme, 0, &cname);
retcode = SQLBindParameter(hStmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_INTEGER, LENGTH, 0,blnce, 0, &cbalnce);
retcode = SQLBindParameter(hStmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_INTEGER, LENGTH, 0,wdrw, 0, &cwithdraw);
retcode = SQLBindParameter(hStmt, 4, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_CHAR, LENGTH, 0,addss, 0, &caddress);
retcode = SQLBindParameter(hStmt,4, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_CHAR, LENGTH, 0,datetime, 0, &cdttm);
strcpy_s(nme, nm);
cname = strlen(nme);
strcpy_s(blnce, bal);
cbalnce = strlen(blnce);
strcpy_s(wdrw, wdr);
cwithdraw = strlen(wdrw);
strcpy_s(addss, ads);
caddress = strlen(addss);
testvalue = date ;
strcpy_s(datetime, testvalue);
caddress = strlen(datetime);
// SQLCHAR query[] = "INSERT INTO b1 VALUES(?,0,1,'test1')";//////
retcode = SQLExecDirect(hStmt,szSqlStrPre, SQL_NTS);
retcode = SQLExecDirect(hStmt, (SQLCHAR*)"UPDATE b1 SET Name = 'Litu' WHERE Address = 'shd'", SQL_NTS); /////// UPDATE UPDATE UPDATE
retcode = SQLExecDirect(hStmt, (SQLCHAR*)"DELETE FROM b1 WHERE withdraw = 9860", SQL_NTS); /////// DELETE......
// Execute the SQL statement handle
retcode = SQLExecute (hStmt);
// Get row of data from the result set defined above in the statement
retcode = SQLFetch (hStmt);
// Free the allocated statement handle
SQLFreeStmt (hStmt, SQL_DROP);
// Disconnect from datasource
SQLDisconnect (hDBC);
}
}
