Norbert
|
| Posted: 03/03/2003, 11:31 AM |
|
Hi,
I use CCS 2 beta3, IIS, MS access, .asp
On my page I have a record form.
It simply adds some data to database.
Database structure is very simple:
ID - primary, autoincrement
some_text - text
I try to achieve the following:
1. I instert the data into the record form
2. I press submit button
3. Data is saved into database record
and
4. My page is reloaded and data from the saved record is automaticly loaded
into my form for additional edit.
In the beginning it looks very simple, but I can't "guess" the ID value
and hence cannot open the record. Could somebody tell me how to do that.
I will appreciate your help very much
Thanks
Norbert
|
|
|
 |
DonB
|
| Posted: 03/03/2003, 5:17 PM |
|
Do you really NEED to redisplay it in the "record" format? I normally have
a "grid" format as the main screen, then send the user to the record form
for add/edit/delete, then return them to the grid once they submit the
record form. If you utilize the PK for sorting (descending), then you will
end up with the new record at the top of your grid because it was the most
recently-added.
Will this work?
DonB
"Norbert" <nneubauer@nospam.zabki.net.pl> wrote in message
news:b40ai8$fso$1@news.codecharge.com...
> Hi,
> I use CCS 2 beta3, IIS, MS access, .asp
> On my page I have a record form.
> It simply adds some data to database.
>
> Database structure is very simple:
> ID - primary, autoincrement
> some_text - text
>
> I try to achieve the following:
>
> 1. I instert the data into the record form
> 2. I press submit button
> 3. Data is saved into database record
> and
> 4. My page is reloaded and data from the saved record is automaticly
loaded
> into my form for additional edit.
>
> In the beginning it looks very simple, but I can't "guess" the ID value
> and hence cannot open the record. Could somebody tell me how to do that.
>
> I will appreciate your help very much
>
> Thanks
>
> Norbert
>
>
|
|
|
|
Norbert
|
| Posted: 03/04/2003, 1:32 AM |
|
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:b40urh$sgc$1@news.codecharge.com...
> Do you really NEED to redisplay it in the "record" format? I normally
have
> a "grid" format as the main screen, then send the user to the record form
> for add/edit/delete, then return them to the grid once they submit the
> record form. If you utilize the PK for sorting (descending), then you
will
> end up with the new record at the top of your grid because it was the most
> recently-added.
>
>
> Will this work?
>
> DonB
>
Well I need to have to tables, lets call them header and details
Header contains some header information like, ID, DATE, USER, and some other
stuff.
Details contains positions related to header, displayed as grid on the page.
I'd like to have header record form and details grid on one page.
The idea is that once user submited header record, he could then add
details.
Do you have any idea?
Norbert
|
|
|
|
DonB
|
| Posted: 03/05/2003, 3:48 PM |
|
Have you considered the Editable grid from Version 2 of CCS? If there are
not a huge number of fields, then this might work out well.
"Norbert" <nneubauer@nospam.zabki.net.pl> wrote in message
news:b41rrl$rc8$1@news.codecharge.com...
>
> "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
>news:b40urh$sgc$1@news.codecharge.com...
> > Do you really NEED to redisplay it in the "record" format? I normally
> have
> > a "grid" format as the main screen, then send the user to the record
form
> > for add/edit/delete, then return them to the grid once they submit the
> > record form. If you utilize the PK for sorting (descending), then you
> will
> > end up with the new record at the top of your grid because it was the
most
> > recently-added.
> >
> >
> > Will this work?
> >
> > DonB
> >
>
> Well I need to have to tables, lets call them header and details
>
> Header contains some header information like, ID, DATE, USER, and some
other
> stuff.
> Details contains positions related to header, displayed as grid on the
page.
>
> I'd like to have header record form and details grid on one page.
> The idea is that once user submited header record, he could then add
> details.
>
> Do you have any idea?
>
> Norbert
>
>
|
|
|
|
Norbert
|
| Posted: 03/05/2003, 4:21 PM |
|
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:b462bt$eub$1@news.codecharge.com...
> Have you considered the Editable grid from Version 2 of CCS? If there are
> not a huge number of fields, then this might work out well.
Don thanks for your help.
I asked CCS support for help - the solution was trivial. They told me to set
the after insert event. It should be
Dlookup("Max(ID)","table_name","1=1",connection").
I connected this with session and it works fine - after submiting record I
am able to edit it - and this is what I wanted to achieve.
I do appreciate your help and ideas.
Thank you
Norbert
|
|
|
|
DonB
|
| Posted: 03/05/2003, 4:42 PM |
|
Be careful with that suggestion. It is going to show you the last record
inserted - not the last record YOU inserted. If more than one person will
be doing insertions, this can trip you up.
DonB
"Norbert" <nneubauer@nospam.zabki.net.pl> wrote in message
news:b4649g$j3g$1@news.codecharge.com...
> "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
>news:b462bt$eub$1@news.codecharge.com...
> > Have you considered the Editable grid from Version 2 of CCS? If there
are
> > not a huge number of fields, then this might work out well.
>
>
> Don thanks for your help.
>
> I asked CCS support for help - the solution was trivial. They told me to
set
> the after insert event. It should be
> Dlookup("Max(ID)","table_name","1=1",connection").
>
> I connected this with session and it works fine - after submiting record I
> am able to edit it - and this is what I wanted to achieve.
>
> I do appreciate your help and ideas.
> Thank you
>
> Norbert
>
>
|
|
|
|
Norbert
|
| Posted: 03/06/2003, 8:29 AM |
|
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:b465ht$lss$1@news.codecharge.com...
> Be careful with that suggestion. It is going to show you the last record
> inserted - not the last record YOU inserted. If more than one person will
> be doing insertions, this can trip you up.
>
You are right, but I can add extra parameter (userID) or in my case string
that represents user's domain logon name - then it is quite safe.
/Norbert
|
|
|
|
|
