void CTableBase::BuildInsertQuery1(CString &s)
{
s.Format(_T("INSERT INTO %s\r\n(%s)\r\nVALUES(%s)\r\n"),
m_sTableName,
BuildFieldList(),
BuildValueList());
}
/**
* Metodo para construir a query de selecao
*/
CString CTableBase::BuildSelectQuery(BOOL bWhereWithKeyOnly, BOOL bIgnoreNULL)
{
CString s;
s.Format(_T("SELECT %s\r\nFROM %s\r\n%s\r\n%s\r\n"),
BuildFieldList(),
m_sTableName,
BuildWhereList(bWhereWithKeyOnly, bIgnoreNULL),
BuildOrderByList());
return s;
}
void
VPVectorFdfDirCB (Widget w,
XtPointer clientData,
XtPointer xt_call_data )
/*
* Called when a new FDF chapter is chosen.
*/
{
GuiVertProfileObjectType *vpt;
Widget vector_list;
char *model, *chapter, *directory;
int verbose;
ButtonObject *bo = (ButtonObject *) clientData;
XmPushButtonCallbackStruct *cbs =
(XmPushButtonCallbackStruct *) xt_call_data;
verbose = GetVerboseLevel();
if( verbose > VERBOSE_0 )
printf ( "VPVectorFdfDirCB\n" );
vpt = GetGuiVertProfileDialog();
chapter = strdup ( bo->string );
/*
* Save FDF chapter.
*/
FreeModelVPVectorDir ( vpt );
SetModelVPVectorDir ( vpt, chapter );
/*
* Refill the scrolled list.
*/
vector_list = GetVectorListVPW( vpt );
XtUnmanageChild ( vector_list );
RemoveProductsFromList ( vector_list );
model = strdup ( GetModelTypeVP ( vpt ) );
directory = GetConfigValue( "vpvectorfdf" );
BuildFieldList ( vector_list, directory, chapter, model,
&(vpt->vector_list) );
XtManageChild ( vector_list );
Free ( model );
Free ( chapter );
Free ( directory );
return;
}
/**
* Metodo para a montagem da query de insercao/update de registro
*/
CString CTableBase::BuildInsertOrReplaceQuery()
{
CString s;
//O método format trabalha somente com 1024 bytes, por isso optamos pela concatenação manual
/*s.Format(_T("INSERT INTO %s\r\n(%s)\r\nVALUES(%s)\r\n"),
m_sTableName,
BuildFieldList(),
BuildValueList());*/
s = L"INSERT OR REPLACE INTO "+m_sTableName+L"("+ BuildFieldList() + L") VALUES ("+ BuildValueList()+L")";
//STLOG_WRITE(L"CTableBase::BuildInsertQuery() = %s",s);
return s;
}
