Lobject_VeriyeSatırİleErişmek_GetTableName_StaticDirectQuery()_
string resultTxt = ""; string tblItems = uapp.GetTableName(1, uapp.CurrentFirm, uapp.ActivePeriod); MessageBox.Show(tblItems.ToString()); string sqlTxt = "SELECT LOGICALREF,CODE FROM " +tblItems+" "; UnityObjects.Query Qry = uapp.NewQuery(); Qry.Statement = sqlTxt; if (Qry.OpenDirect()) { bool res = Qry.First(); while (res) { if (Qry.QueryFields[1].Value.ToString()=="500 GB DİSK") { resultTxt = resultTxt + Qry.QueryFields[0].Value.ToString() + "\t" + Qry.QueryFields[1].Value.ToString() + "\n"; } res = Qry.Next(); } MessageBox.Show(resultTxt); } else { MessageBox.Show(Qry.DBErrorDesc.ToString()); } Qry.Close();
.JPG)
