Re: storedproc.edit: "select permission denied" when assigning to a field
From: Del M (Del.Murray_at_CreditHawk.Net)
Date: 02/08/05
- Next message: Mike Shkolnik: "Re: Null fields not printing correctly"
- Previous message: Andrew Skinner: "Null fields not printing correctly"
- In reply to: Matt Jacobs: "Re: storedproc.edit: "select permission denied" when assigning to a field"
- Next in thread: Jeremy: "Re: storedproc.edit: "select permission denied" when assigning to a field"
- Reply: Jeremy: "Re: storedproc.edit: "select permission denied" when assigning to a field"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 8 Feb 2005 06:35:00 -0500
Delphi isn't doing anything inside the stored procedure, SQL Server is doing
it. Do you have a primary key on the table?
Since the stored proc is returning an adorecordset, then you should change
the tadostoredproc to a tadodataset. Set the commandtype to stored
procedure, set the lock type to batchoptimistic, be sure after completion of
your loop that you do "updatebatch" to actually apply the changes to the
table.
If you are looking for speed, you could just use a tadodataset and do a
"update table1 set x=y, z=q, where ... in (select ... "
That would probably go much faster since the database engine will update the
database for you and your delphi program will never even see the data or
send it back and forth between the client and the database.
- Next message: Mike Shkolnik: "Re: Null fields not printing correctly"
- Previous message: Andrew Skinner: "Null fields not printing correctly"
- In reply to: Matt Jacobs: "Re: storedproc.edit: "select permission denied" when assigning to a field"
- Next in thread: Jeremy: "Re: storedproc.edit: "select permission denied" when assigning to a field"
- Reply: Jeremy: "Re: storedproc.edit: "select permission denied" when assigning to a field"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
