how do i use the tdbgrid control to update or delete records

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
martene
Posts: 1
Joined: Thu 02 Oct 2008 09:32

how do i use the tdbgrid control to update or delete records

Post by martene » Thu 02 Oct 2008 09:41

Hi All!

I have a TMSConnection, TMSQuery, TMSDatasource, TDBNavigator and a TCRDBGrid all arranged so that i can see and traverse the data, but i can not persist any changes to the database. Obviously i am doing something wrong here. I would be very grateful to anyone pointing me in the right direction

Delphi 2007/SQL Server DataAccess Components 4.50.0.39/SQL Server Express on local machine

Cheers

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Mon 06 Oct 2008 13:02

You can enable Debug to determine whether SDAC performs UPDATE statements or not. To do this set the Debug property of TMSQuery to True and add the SdacVcl unit to the uses clause.

Post Reply