Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EStack Overflow error on delphi

Status
Not open for further replies.

MarvinManuel

Programmer
Apr 28, 2005
11
PH
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.
 
Wrong Forum this is Interbase, there is also a Borland Delphi forum.

Steven
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top