MarvinManuel
Programmer
Im using MS-Access as my database engine, whenever I call the ADOCommand.Execute method, it displays the EStack Overflow error. But the error message doesn't display when I run the exe file and the database is being updated. I'm getting confused because I know what Stack overflow means, I've check my fields and the data I'm inserting and updating. My code goes like:
sSql := 'INSERT INTO EMPLOYEES('
+ 'EMP_CODE, '
+ 'EMP_LAST_NAME, '
+ 'EMP_FIRST_NAME) '
+ 'VALUES('
+ ':vEMP_CODE, '
+ ':vEMP_LAST_NAME,'
+ ':vEMP_FIRST_NAME)';
with DataMD1.ADOCommand1 do begin
CommandText := sSql;
Parameters.ParamByName('vEMP_CODE').Value := 101;
Parameters.ParamByName('vEMP_LAST_NAME').Value := 'MNM';
Parameters.ParamByName('vEMP_FIRST_NAME').Value := 'MVV';
DataMD1.ADODataSet1.Recordset := Execute;
end;
Can someone tell me what's the problem? Thank you again.
sSql := 'INSERT INTO EMPLOYEES('
+ 'EMP_CODE, '
+ 'EMP_LAST_NAME, '
+ 'EMP_FIRST_NAME) '
+ 'VALUES('
+ ':vEMP_CODE, '
+ ':vEMP_LAST_NAME,'
+ ':vEMP_FIRST_NAME)';
with DataMD1.ADOCommand1 do begin
CommandText := sSql;
Parameters.ParamByName('vEMP_CODE').Value := 101;
Parameters.ParamByName('vEMP_LAST_NAME').Value := 'MNM';
Parameters.ParamByName('vEMP_FIRST_NAME').Value := 'MVV';
DataMD1.ADODataSet1.Recordset := Execute;
end;
Can someone tell me what's the problem? Thank you again.