Error Exception Class "External:SIGSEGV" lazarus / 13-General ---------------------------------------------------------------------- Dennz · 2009-11-20 04:18 Bro, i using fedora 8. Everything is compiling fine but when runing I got the message: exception class 'External: SIGSEGV' Could somebody help me with some tips about it? Code: [Select]this is my code -------------------------------------------- unit frm_mast_valas; {$mode objfpc}{$H+} interface uses   Classes, SysUtils, sqldb, mysql50conn, db, FileUtil, LResources, Forms,   Controls, Graphics, Dialogs, DbCtrls, Buttons, ExtCtrls, DBGrids, Grids,   StdCtrls, LR_Class, LR_DBSet, LR_Shape; type   { Tfm_mast_valas }   Tfm_mast_valas = class(TForm)     BCancel: TButton;     BSave: TButton;     DBCheckBox2: TDBCheckBox;     DBEd_pnNama: TDBEdit;     DBEd_pnKode: TDBEdit;     DBEd_pnNilai: TDBEdit;     DBGrid1: TDBGrid;     DBNavigator1: TDBNavigator;     ds_master: TDatasource;     Editlocate: TEdit;     Label1: TLabel;     Label2: TLabel;     Label3: TLabel;     Label4: TLabel;     MySQL50Connection1: TMySQL50Connection;     Panel1: TPanel;     Panel2: TPanel;     Panel3: TPanel;     pnl_Data: TPanel;     qr_master: TSQLQuery;     qr_masterfieldnama: TStringField;     qr_masterFlaging: TStringField;     qr_masterflag_id: TSmallintField;     qr_masterkode: TStringField;     qr_masterlookup_id: TLongintField;     qr_masternama: TStringField;     qr_masternilai: TBCDField;     qr_mastertanggal_tambah: TDateTimeField;     qr_mastertanggal_ubah: TDateTimeField;     qr_masteruser_tambah: TStringField;     qr_masteruser_ubah: TStringField;     btnpreview: TSpeedButton;     btnprinting: TSpeedButton;     btnclose: TSpeedButton;     btnlocate: TSpeedButton;     SQLTransaction1: TSQLTransaction;     procedure BCancelClick(Sender: TObject);     procedure BSaveClick(Sender: TObject);     procedure btnpreviewClick(Sender: TObject);     procedure DBCheckBox2Click(Sender: TObject);     procedure DBGrid1TitleClick(Column: TColumn);     procedure EditlocateEnter(Sender: TObject);     procedure EditlocateKeyPress(Sender: TObject; var Key: char);     procedure FormCreate(Sender: TObject);     procedure fptMastBrandGetValue(const ParName: String; var ParValue: Variant       );     procedure qr_masterAfterDelete(DataSet: TDataSet);     procedure qr_masterAfterEdit(DataSet: TDataSet);     procedure qr_masterAfterInsert(DataSet: TDataSet);     procedure btnprintingClick(Sender: TObject);     procedure btncloseClick(Sender: TObject);     procedure btnlocateClick(Sender: TObject);     procedure qr_masterAfterScroll(DataSet: TDataSet);     procedure qr_masterBeforeDelete(DataSet: TDataSet);     procedure qr_masterBeforeEdit(DataSet: TDataSet);     procedure qr_masterBeforeInsert(DataSet: TDataSet);     procedure qr_masterBeforePost(DataSet: TDataSet);     procedure qr_masterCalcFields(DataSet: TDataSet);   private     vp_beforedel : integer;     sColums,     sSort : string;     procedure Reopening;   public     { public declarations }   end; var   fm_mast_valas: Tfm_mast_valas; implementation uses frm_main,dmd_Data; { Tfm_mast_valas } procedure Tfm_mast_valas.FormCreate(Sender: TObject); begin   top :=fm_main.top + 55;   left :=fm_main.left + 5;   width :=fm_main.width - 10;   height :=fm_main.height - 65;   sSort :=' ASC ';   // Retrieve   qr_master.Close; qr_master.SQL.Clear;   qr_master.SQL.Add('select * from m_lookup_t');   qr_master.SQL.Add('where fieldnama = '+quotedstr('valas_id'));   qr_master.SQL.Add('  and flag_id <> 3 order by kode');   // Insert   qr_master.InsertSQL.Clear; qr_master.InsertSQL.Text :=   'insert into m_lookup_t ('+   'lookup_id,fieldnama,kode,nama,nilai,'+   'tanggal_tambah,tanggal_ubah,user_tambah,'+   'user_ubah,flag_id) values ('+   ':lookup_id,:fieldnama,:kode,:nama,:nilai,'+   ':tanggal_tambah,:tanggal_ubah,:user_tambah,'+   ':user_ubah,:flag_id)';   // Update   qr_master.UpdateSQL.Clear; qr_master.UpdateSQL.Text :=   'update m_lookup_t set '+   'fieldnama =:fieldnama, '+   'kode = :kode, '+   'nama = :nama, '+   'nilai = :nilai, '+   'tanggal_tambah = :tanggal_tambah, '+   'tanggal_ubah = :tanggal_ubah, '+   'user_tambah = :user_tambah, '+   'user_ubah = :user_ubah, '+   'flag_id = :flag_id '+   'where lookup_id=:lookup_id';   //   qr_master.Open; end; procedure Tfm_mast_valas.qr_masterAfterInsert(DataSet: TDataSet); begin   dm_Data.pdatetimenow;   qr_mastertanggal_tambah.AsDateTime:=dm_data.TgljamTgljam.AsDateTime;   qr_masteruser_tambah.AsString:=dm_data.UserNM;   qr_mastertanggal_ubah.AsDateTime:=dm_data.TgljamTgljam.AsDateTime;   qr_masteruser_ubah.AsString:=dm_data.UserNM;   dm_data.Tgljam.Close;   //   qr_masternilai.asinteger:=0;   qr_masterflag_id.asinteger:=1;   qr_masterfieldnama.asstring:='valas_id'; end; procedure Tfm_mast_valas.qr_masterBeforePost(DataSet: TDataSet); begin   if (trim(qr_masterkode.value)='') or (qr_masterkode.IsNull) then   begin     MessageDlg('You must input valas code ....',mtError,[mbOK],0);     DBEd_pnKode.SetFocus;     abort;     Exit;   end;   if (trim(qr_masternama.value)='') or (qr_masternama.IsNull) then   begin     MessageDlg('You must input valas name ...',mtError,[mbOK],0);     DBEd_pnNama.SetFocus;     abort;     Exit;   end;   if (qr_masternilai.value<0) or (qr_masternilai.IsNull) then   begin     MessageDlg('You must input valas value ...',mtError,[mbOK],0);     DBEd_pnNilai.SetFocus;     abort;     Exit;   end;   dm_Data.Qry_Validate.Close; dm_Data.Qry_Validate.Sql.Clear;   dm_Data.Qry_Validate.Sql.Text:=   'select kode from m_lookup_t where fieldnama = '+quotedstr('valas_id')+   ' and flag_id<>3 and lookup_id<>'+inttostr(qr_masterlookup_id.value)+   ' and kode='+QuotedStr(qr_masterkode.value);   dm_Data.Qry_Validate.Open;   if (dm_Data.Qry_Validate['kode'] <> null) then   begin     MessageDlg('Valas code already exist ...',mtError,[mbOK],0);     DBEd_pnKode.SetFocus;     Abort;   end; end; procedure Tfm_mast_valas.qr_masterAfterEdit(DataSet: TDataSet); begin   dm_Data.pdatetimenow;   qr_mastertanggal_ubah.AsDateTime:=dm_data.TgljamTgljam.AsDateTime;   qr_masteruser_ubah.AsString:=dm_data.UserNM;   dm_data.Tgljam.Close; end; procedure Tfm_mast_valas.qr_masterBeforeDelete(DataSet: TDataSet); begin   vp_beforedel :=qr_masterlookup_id.AsInteger;;   //   dm_Data.QRexec.Close; dm_Data.QRexec.SQL.Clear; dm_Data.QRexec.SQL.Text :=   'select valasjual_id from m_barang_t where flag_id <> 3 '+   ' and valasjual_id = '+inttostr(vp_beforedel);   dm_Data.QRexec.open;   if not dm_Data.QRexec.isempty then   begin     showmessage('Can''t delete this record, because already in use');     abort;   end; end; procedure Tfm_mast_valas.qr_masterBeforeEdit(DataSet: TDataSet); begin   pnl_Data.Visible:=True; end; procedure Tfm_mast_valas.qr_masterBeforeInsert(DataSet: TDataSet); begin   pnl_Data.Visible:=True; end; procedure Tfm_mast_valas.qr_masterAfterDelete(DataSet: TDataSet); begin   dm_Data.QRexec.Close; dm_Data.QRexec.SQL.Clear;   dm_Data.QRexec.SQL.Add('update m_lookup_t set flag_id = 3 where lookup_id ='+IntToStr(vp_beforedel));   dm_Data.QRexec.ExecSQl;   // not batch   Reopening; end; procedure Tfm_mast_valas.DBGrid1TitleClick(Column: TColumn); begin   sColums :=Column.Title.Caption;   if ssort = ' ASC ' then ssort :=' DESC ' else  ssort :=' ASC ';   Reopening; end; procedure Tfm_mast_valas.BSaveClick(Sender: TObject); begin   qr_master.ApplyUpdates; end; procedure Tfm_mast_valas.btnpreviewClick(Sender: TObject); begin  // type = prev > show dlg-Mlookup_t-table [sama] end; procedure Tfm_mast_valas.btnprintingClick(Sender: TObject); begin  // type = print > show dlg-Mlookup_t-table [sama] end; procedure Tfm_mast_valas.DBCheckBox2Click(Sender: TObject); begin   if DBCheckBox2.Checked then      DBCheckBox2.Caption :='Active' else      DBCheckBox2.Caption :='Non Active'; end; procedure Tfm_mast_valas.BCancelClick(Sender: TObject); begin   qr_master.Cancel;        //current rec   qr_master.CancelUpdates; //all of rec   pnl_Data.Visible:=False; end; procedure Tfm_mast_valas.EditlocateEnter(Sender: TObject); begin   DBGrid1.SetFocus;  // get column field nm   Editlocate.SelectAll;   Editlocate.SetFocus; end; procedure Tfm_mast_valas.fptMastBrandGetValue(const ParName: String;   var ParValue: Variant); begin  if ParName ='v1' then     ParValue:=dm_data.Setup.Alamat;  if ParName ='v2' then     ParValue:=dm_data.Setup.Kota; end; procedure Tfm_mast_valas.EditlocateKeyPress(Sender: TObject; var Key: char   ); begin  if key = #13 then btnlocateClick(Sender); end; procedure Tfm_mast_valas.btnlocateClick(Sender: TObject); begin   if Editlocate.text<>'' then   begin     if DBGrid1.SelectedField = qr_masterkode then        qr_master.Locate('kode',Editlocate.Text,[]) else     if DBGrid1.SelectedField = qr_masternama then        qr_master.Locate('nama',Editlocate.Text,[]) else     if DBGrid1.SelectedField = qr_masternilai then        qr_master.Locate('nilai',Editlocate.Text,[]) else     if DBGrid1.SelectedField = qr_masterflag_id then        qr_master.Locate('flag',Editlocate.Text,[]) else     // date harus format date     if DBGrid1.SelectedField = qr_mastertanggal_tambah then        qr_master.Locate('tanggal_tambah',Editlocate.Text,[]) else     if DBGrid1.SelectedField = qr_mastertanggal_ubah then        qr_master.Locate('tanggal_ubah',Editlocate.Text,[]) else     if DBGrid1.SelectedField = qr_masteruser_tambah then        qr_master.Locate('user_tambah',Editlocate.Text,[]) else        qr_master.Locate('user_ubah',Editlocate.Text,[]);   end; end; procedure Tfm_mast_valas.qr_masterAfterScroll(DataSet: TDataSet); begin   if qr_masterflag_id.AsInteger = 1 then      DBCheckBox2.Caption:='Active' else      DBCheckBox2.Caption:='Non Active'; end; procedure Tfm_mast_valas.qr_masterCalcFields(DataSet: TDataSet); begin   if qr_masterflag_id.AsInteger = 1 then      qr_masterFlaging.AsString:='Active' else      qr_masterFlaging.AsString:='Non Active'; end; procedure Tfm_mast_valas.Reopening; var lcl_div_id : integer; begin   if qr_master.active then lcl_div_id :=qr_masterlookup_id.asinteger else lcl_div_id :=0;   qr_master.Close; qr_master.SQL.Clear;   qr_master.SQL.Add('select * from m_lookup_t');   qr_master.SQL.Add('where fieldnama = '+quotedstr('valas_id'));   qr_master.SQL.Add('  and flag_id <> 3 order by ');   if sColums = 'Code' then    qr_master.SQL.Add('kode '+sSort+',nama '+sSort) else   if sColums = 'Name' then    qr_master.SQL.Add('nama '+sSort+',kode '+sSort) else   if sColums = 'Value' then    qr_master.SQL.Add('nilai '+sSort+',kode '+sSort) else   if sColums = 'Flag' then    qr_master.SQL.Add('flag_id '+sSort+',lookup_id '+sSort) else   if sColums = 'Date Add' then    qr_master.SQL.Add('tanggal_tambah '+sSort+',tanggal_ubah '+sSort) else   if sColums = 'Date Changed' then    qr_master.SQL.Add('tanggal_ubah '+sSort+',tanggal_tambah '+sSort) else   if sColums = 'User Add' then    qr_master.SQL.Add('user_tambah '+sSort+',user_ubah '+sSort) else   if sColums = 'User Changed' then    qr_master.SQL.Add('user_ubah '+sSort+',user_tambah '+sSort) else    qr_master.SQL.Add('kode '+sSort+',nama '+sSort);   //   qr_master.close; qr_master.open;   qr_master.Locate('lookup_id',lcl_div_id,[loPartialKey]);   // dijadikan satu dgn query add tdk mau (setelah close open baru mau)   if (sColums = 'Code') or (sColums = 'Kode') then  // ? tdak mau kenapa ?    DBGrid1.SelectedField :=qr_masterkode else   if (sColums = 'Name') or (sColums = 'Nama') then    DBGrid1.SelectedField :=qr_masternama else   if sColums = 'Value' then    DBGrid1.SelectedField :=qr_masternilai else   if sColums = 'Flag' then    DBGrid1.SelectedField :=qr_masterFlaging else   if sColums = 'Date Add' then    DBGrid1.SelectedField:=qr_mastertanggal_tambah else   if sColums = 'Date Changed' then    DBGrid1.SelectedField:=qr_mastertanggal_ubah else   if sColums = 'User Add' then    DBGrid1.SelectedField:=qr_masteruser_tambah else   if sColums = 'User Changed' then    DBGrid1.SelectedField:=qr_masteruser_ubah else    DBGrid1.SelectedField :=qr_masterkode; end; procedure Tfm_mast_valas.btncloseClick(Sender: TObject); begin   Close; end; initialization   {$I frm_mast_valas.lrs} end. ------------------------------------------- ---------------------------------------------------------------------- davesimplewear · 2009-11-20 08:03 have you tried debugging by using a breakpoint to see where the error is occuring? I haven't used mysql very much so not sure where I can help. ---------------------------------------------------------------------- picstart · 2009-11-20 08:53 If you get this SIGSEGV error immediately upon running then plod through since it appears the error is a feature of Lazarus since 26.2 and you'll just have to live with it. Exit from the assembler list then select run again and maybe the debugger will work and or your code will run. ---------------------------------------------------------------------- Dennz · 2009-11-24 03:13 Quote from: davesimplewear on November 20, 2009, 09:03:57 amhave you tried debugging by using a breakpoint to see where the error is occuring? I haven't used mysql very much so not sure where I can help. how i can use debugging by using a break point. could you help me? thx ---------------------------------------------------------------------- davesimplewear · 2009-11-24 08:29 To use a break point, pick a point in your code where you think the error may be occuring and click in the left pane of the code window next to your code and you will get a highlighted line, the code will run up to this point, keep doing this until you find where it is occuring and this will isolate the part of the code throwing the error. You will also need to set the debugger select Enviroment/Debugger and set the debugger if you haven't already. Good Luck