private void tmrWorkerThree_Tick(object sender, EventArgs e) { tmrWorkerThree.Enabled = false; Recordset lObjRecordset = null; try { lObjRecordset = DIApplication.GetRecordset(); lObjRecordset.DoQuery("SELECT ItemCode FROM OITM"); lstThreadThree.Items.Clear(); if (lObjRecordset.RecordCount > 0) { for (int i = 0; i < lObjRecordset.RecordCount; i++) { lstThreadThree.Items.Add(lObjRecordset.Fields.Item(0).Value.ToString()); lObjRecordset.MoveNext(); } } } catch (Exception ex) { lstThreadThree.Items.Add(ex.ToString()); } finally { MemoryUtility.ReleaseComObject(lObjRecordset); tmrWorkerThree.Enabled = true; } }
/// <summary> /// Checks if a User Defined Field exists. /// </summary> /// <param name="tableName">The table of the field.</param> /// <param name="ufdName">The name of the field.</param> /// <returns><c>true</c> if it exists, <c>false</c> otherwise.</returns> public static bool ExistsUFD(string tableName, string ufdName) { SAPbobsCOM.Recordset rs = DIApplication.GetRecordset(); try { rs.DoQuery(string.Format("SELECT \"AliasID\" FROM \"CUFD\" WHERE \"TableID\" = '{0}' AND \"AliasID\" = '{1}'", tableName, ufdName)); if (rs.RecordCount > 0) { return(true); } } catch (Exception) { } finally { MemoryUtility.ReleaseComObject(rs); } return(false); }