the request string_agg and TMemo problem

[azizi_lazard1988]

hello,
i work with portgresql and lazarus , and i want to repurate two varchar fields in one fields
and show them in same TMemo
i use the request of String_agg this  but when i execute he show me  type_main not found  but when i execute request in postgresql all is fine  can you help me please

Code: Pascal  [Select][+][-]

1.  GmaoDataModule.PreventifDetailQuery.Active:=true;
2.   GmaoDataModule.PreventifDetailQuery.SQL.Text:= 'SELECT ref_equip,string_agg(type_maintenance,'''+''+''') as type_main FROM "PreventifDetail" where ref_equip='''+NewOTForm.CodeAmcEdit.Text+''' GROUP BY ref_equip;';
3.   NewOTForm.Memo1.Text:=GmaoDataModule.PreventifDetailQuery.FieldByName('type_main').AsString;
4.   GmaoDataModule.PreventifDetailQuery.Active:=true;
5.  NewOTForm.Show;  

[taazz]

hello,
i work with portgresql and lazarus , and i want to repurate two varchar fields in one fields
and show them in same TMemo
i use the request of String_agg this  but when i execute he show me  type_main not found  but when i execute request in postgresql all is fine  can you help me please

Code: Pascal  [Select][+][-]

1.  GmaoDataModule.PreventifDetailQuery.Active:=true;
2.   GmaoDataModule.PreventifDetailQuery.SQL.Text:= 'SELECT ref_equip,string_agg(type_maintenance,'''+''+''') as type_main FROM "PreventifDetail" where ref_equip='''+NewOTForm.CodeAmcEdit.Text+''' GROUP BY ref_equip;';
3.   NewOTForm.Memo1.Text:=GmaoDataModule.PreventifDetailQuery.FieldByName('type_main').AsString;
4.   GmaoDataModule.PreventifDetailQuery.Active:=true;
5.  NewOTForm.Show;  

Code: Pascal  [Select][+][-]

1.  GmaoDataModule.PreventifDetailQuery.Active:=False;//<-- why true?
2.   GmaoDataModule.PreventifDetailQuery.SQL.Text:= 'SELECT ref_equip,string_agg(type_maintenance,'''+''+''') as type_main FROM "PreventifDetail" where ref_equip='''+NewOTForm.CodeAmcEdit.Text+''' GROUP BY ref_equip;';
3.   //NewOTForm.Memo1.Text:=GmaoDataModule.PreventifDetailQuery.FieldByName('type_main').AsString;//<-- ofcourse it will raise an exception it has the old dataset in memory.
4.   GmaoDataModule.PreventifDetailQuery.Active:=true;//<--new data, new fields
5.   NewOTForm.Memo1.Text:=GmaoDataModule.PreventifDetailQuery.FieldByName('type_main').AsString; //no problems
6.  NewOTForm.Show;  

Keep in mind that nothing was tested, I just changed the order of things, to what I consider a more appropriate order, if it does not work post more info.

[azizi_lazard1988]

thank you very much the problem is resolved it is really good i'am very happy thank you very much