27-04-2020, 03:51 AM
27-04-2020, 11:43 AM
![[صورة: 872162611.png]](https://www7.0zz0.com/2020/04/27/13/872162611.png)
01 - نضغط مرتين على FDTable1 تظهر لنا قائمة فارغة للحقول
02 - كليك يمين نختار اظافة جميع الحقول
03 - نختار الحقل من نوع Memo في خيار 「DisplayValue」 توجد عدة خيارات من بينها dvFull تظهر النص بالكامل و dvClip جزء من النص
![[صورة: 515586052.png]](https://www7.0zz0.com/2020/04/27/13/515586052.png)
![[صورة: 565300461.png]](https://www7.0zz0.com/2020/04/27/13/565300461.png)
27-04-2020, 01:26 PM
شكرا علي الرد ولكني استخدم الكود في runtime
--
مثال
----
--
مثال
----
PHP كود :
procedure TForm3.Button1Click(Sender: TObject);
var
ini: Tinifile;
Server, User, Pass, DBName: string;
begin
ini:= TIniFile.Create(ExtractFilePath (Application.ExeName) + 'dbconn.ini'); // initialize the ini file
Server:= ini.ReadString ('serverinfo', 'ServerIP',''); // database ip address
DBName:= ini.ReadString ('serverinfo', 'SQLDBName',''); // database name
User:= ini.ReadString ('serverinfo', 'SQLUserID',''); // database user name
Pass:= ini.ReadString ('serverinfo', 'SQLPwd',''); // database password
try
ADOConnection1.ConnectionString:= 'Provider = SQLOLEDB.1; Persist Security Info = False;'
+'User ID =' + trim(User)
+';Password ='+ trim(Pass)
+';Initial Catalog =' + trim(DBName)
+'; Data Source =' + trim(Server);
ADOConnection1.Open;
ShowMessage('connected');
//ADOConnection1.Close;
ADOTable1.Connection := ADOConnection1;
ADOTable1.TableName :='items';
ADOTable1.Active := true;
DataSource1.DataSet :=ADOTable1;
DBGrid1.DataSource := DataSource1;
except
application.MessageBox ('database connection fails, check the INI configuration file', 'tips', 64);
application.Terminate;
end;
end;
27-04-2020, 02:35 PM
PHP كود :
procedure TForm3.Button1Click(Sender: TObject);
var
ini: Tinifile;
Server, User, Pass, DBName: string;
begin
ini:= TIniFile.Create(ExtractFilePath (Application.ExeName) + 'dbconn.ini'); // initialize the ini file
Server:= ini.ReadString ('serverinfo', 'ServerIP',''); // database ip address
DBName:= ini.ReadString ('serverinfo', 'SQLDBName',''); // database name
User:= ini.ReadString ('serverinfo', 'SQLUserID',''); // database user name
Pass:= ini.ReadString ('serverinfo', 'SQLPwd',''); // database password
try
ADOConnection1.ConnectionString:= 'Provider = SQLOLEDB.1; Persist Security Info = False;'
+'User ID =' + trim(User)
+';Password ='+ trim(Pass)
+';Initial Catalog =' + trim(DBName)
+'; Data Source =' + trim(Server);
ADOConnection1.Open;
ShowMessage('connected');
//ADOConnection1.Close;
ADOTable1.Connection := ADOConnection1;
ADOTable1.TableName :='items';
ADOTable1.Active := true;
TMemoField(ADOTable1.FieldByName('هنا أكتب اسم الحقل ميمو')).DisplayValue := dvFull;
DataSource1.DataSet :=ADOTable1;
DBGrid1.DataSource := DataSource1;
except
application.MessageBox ('database connection fails, check the INI configuration file', 'tips', 64);
application.Terminate;
end;
end;
27-04-2020, 10:27 PM
(27-04-2020, 02:35 PM)larbiparadox كتب : [ -> ]الف شكر تحياتيPHP كود :procedure TForm3.Button1Click(Sender: TObject);
var
ini: Tinifile;
Server, User, Pass, DBName: string;
begin
ini:= TIniFile.Create(ExtractFilePath (Application.ExeName) + 'dbconn.ini'); // initialize the ini file
Server:= ini.ReadString ('serverinfo', 'ServerIP',''); // database ip address
DBName:= ini.ReadString ('serverinfo', 'SQLDBName',''); // database name
User:= ini.ReadString ('serverinfo', 'SQLUserID',''); // database user name
Pass:= ini.ReadString ('serverinfo', 'SQLPwd',''); // database password
try
ADOConnection1.ConnectionString:= 'Provider = SQLOLEDB.1; Persist Security Info = False;'
+'User ID =' + trim(User)
+';Password ='+ trim(Pass)
+';Initial Catalog =' + trim(DBName)
+'; Data Source =' + trim(Server);
ADOConnection1.Open;
ShowMessage('connected');
//ADOConnection1.Close;
ADOTable1.Connection := ADOConnection1;
ADOTable1.TableName :='items';
ADOTable1.Active := true;
TMemoField(ADOTable1.FieldByName('هنا أكتب اسم الحقل ميمو')).DisplayValue := dvFull;
DataSource1.DataSet :=ADOTable1;
DBGrid1.DataSource := DataSource1;
except
application.MessageBox ('database connection fails, check the INI configuration file', 'tips', 64);
application.Terminate;
end;
end;