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; }