SerPep
|
| Posted: 04/13/2004, 12:35 PM |
|
Hi all.
I'm a newbie to ccs and have some problems concerning custom delete in a
grid.
When defining the delete type to custom what must I enter in the following
mask?
How must the sql look like?
I'm using ccs2.3.60 with ASP on an Oracle 9i.
Sorry for my bad english 
Best
Stephan
|
|
|
 |
DonB
|
| Posted: 04/13/2004, 2:32 PM |
|
Don't worry, you won't need to write any SQL at all. The delete only
requires you to specify the selection criteria (column name and the value)
for selecting rows to be deleted. Just fill in the properties in the dialog
box.
--
DonB
http://www.gotodon.com/ccbth
"SerPep" <Serpep@gmx.de> wrote in message
news:c5hfe3$j89$1@news.codecharge.com...
> Hi all.
>
> I'm a newbie to ccs and have some problems concerning custom delete in a
> grid.
> When defining the delete type to custom what must I enter in the following
> mask?
> How must the sql look like?
>
> I'm using ccs2.3.60 with ASP on an Oracle 9i.
>
> Sorry for my bad english
>
> Best
> Stephan
>
>
|
|
|
|
Sergeant Pepper
|
| Posted: 04/13/2004, 11:08 PM |
|
Am Tue, 13 Apr 2004 16:32:06 -0500 schrieb DonB:
> Don't worry, you won't need to write any SQL at all. The delete only
> requires you to specify the selection criteria (column name and the value)
> for selecting rows to be deleted. Just fill in the properties in the dialog
> box.
Thanx RonB,
but if I wonna do an Update instead of an Delete? Is it possilbe to do this
from this mask?
Best
Stephan
|
|
|
|
DonB
|
| Posted: 04/14/2004, 4:43 PM |
|
The custom actions all work basically the same. An insert might not have a
primary key (if it is an autoincremented key). You must supply the WHERE
portion for UPDATE and DELETE, so that the correct record can be located in
the table. I find the custom INSERT and UPDATE useful because there are
times when columns (other than those appearing on the form) need to be
affected.
--
DonB
http://www.gotodon.com/ccbth
"Sergeant Pepper" <SerPep@gmx.de> wrote in message
news:4ztlwrinewu4.1sgzcvpn52ddc.dlg@40tude.net...
> Am Tue, 13 Apr 2004 16:32:06 -0500 schrieb DonB:
>
> > Don't worry, you won't need to write any SQL at all. The delete only
> > requires you to specify the selection criteria (column name and the
value)
> > for selecting rows to be deleted. Just fill in the properties in the
dialog
> > box.
>
> Thanx RonB,
>
> but if I wonna do an Update instead of an Delete? Is it possilbe to do
this
> from this mask?
>
> Best
> Stephan
|
|
|
|
Sergeant Pepper
|
| Posted: 04/15/2004, 1:54 AM |
|
Am Wed, 14 Apr 2004 18:43:45 -0500 schrieb DonB:
> The custom actions all work basically the same. An insert might not have a
> primary key (if it is an autoincremented key). You must supply the WHERE
> portion for UPDATE and DELETE, so that the correct record can be located in
> the table. I find the custom INSERT and UPDATE useful because there are
> times when columns (other than those appearing on the form) need to be
> affected.
Don,
Thank you again. I think my explnation was not as good as it should.
If I will select Custom Delete Type=SQL the IDE will always generate a
DELETE statement. My intention is not to delete the record but to update
a status field with a "delete" flag.
So is it possible, when using a grid with a delete checkbox, to perform an
update generated via IDE instead of a DELETE?
Hope this is a litle bit more acurate than my postings before.
Best
Stephan
|
|
|
|
DonB
|
| Posted: 04/15/2004, 8:56 AM |
|
I guess you have buttons for ADD, UPDATE and DELETE (like normal) but the
DELETE is really an UPDATE. So, go ahead and make it an UPDATE button
(having two is not a problem). Give it the caption "DELETE" and make your
custom update set the deleted flag.
The Button properties has a place to define it's action as an update,
delete, etc. Once you change that you are all set. The caption of the
button has nothing to do with the function that the button performs, so
having it say delete but do update is perfectly OK.
--
DonB
http://www.gotodon.com/ccbth
"Sergeant Pepper" <SerPep@gmx.de> wrote in message
news:1d8kubzkegsjs$.1nviplhkju2q3.dlg@40tude.net...
> Am Wed, 14 Apr 2004 18:43:45 -0500 schrieb DonB:
>
> > The custom actions all work basically the same. An insert might not
have a
> > primary key (if it is an autoincremented key). You must supply the
WHERE
> > portion for UPDATE and DELETE, so that the correct record can be located
in
> > the table. I find the custom INSERT and UPDATE useful because there are
> > times when columns (other than those appearing on the form) need to be
> > affected.
>
> Don,
>
> Thank you again. I think my explnation was not as good as it should.
> If I will select Custom Delete Type=SQL the IDE will always generate a
> DELETE statement. My intention is not to delete the record but to update
> a status field with a "delete" flag.
> So is it possible, when using a grid with a delete checkbox, to perform an
> update generated via IDE instead of a DELETE?
> Hope this is a litle bit more acurate than my postings before.
>
> Best
> Stephan
|
|
|
|
Sergeant Pepper
|
| Posted: 04/19/2004, 7:56 AM |
|
Am Thu, 15 Apr 2004 10:56:39 -0500 schrieb DonB:
> I guess you have buttons for ADD, UPDATE and DELETE (like normal) but the
> DELETE is really an UPDATE. So, go ahead and make it an UPDATE button
> (having two is not a problem). Give it the caption "DELETE" and make your
> custom update set the deleted flag.
>
> The Button properties has a place to define it's action as an update,
> delete, etc. Once you change that you are all set. The caption of the
> button has nothing to do with the function that the button performs, so
> having it say delete but do update is perfectly OK.
Ron,
Thank you again. That's exactly what I will do now.
Best
Stephan
|
|
|
|
kevind
Posts: 251
|
| Posted: 11/22/2004, 12:15 PM |
|
Reopening this topic.
I'm on the same task as Stephan (sergeant Pepper).
How do you accomplish this in an editable grid. The row I want to delete will be a foreign key to another table and, so, cannot disappear.
Is there an easy way to do this using the custom delete mechanism ? If not, I'll simply include the flag field as a check box in the grid.
Thanks for any feedback.
Kevin
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
 |
|
|
