Response.redirect to a particular detail view

[Dorothy]

I am cloning a record from a table to the same table. The id field is autoincremented correctly according to the field rule. Here's what I want to happen:

Initially the user is on the detail view of a grid, which is displayed separately from the grid, when s(he) initiates the a5w page which contains the cloning. I want the user to be sent back to this detail view with the new, cloned record showing. I do not know how to capture the new id value nor to write the response.redirect line.

This is what is on the a5w page:
dim vid as c
dim newvid as c
dim src as p
dim dest as p
dim indx1 as p
'Open a src first instance of the table
src=table.open("[PathAlias.ADB_Path]\productstest")
'Open a trg second instance of the same table
dest=table.open("[PathAlias.ADB_Path]\productstest")
'Set its index to id order
indx1=src.index_primary_put("id")
'Find the specific record
src.fetch_find(vid)
'Put dest into enter mode and clone record from the src
dest.enter_begin(.T.)
dest.record_clone(src)
'This next line shows that dest.id and src.id are = at this point
'newvid=dest.id
dest.enter_end(.T.)
'This next line shows that the dest.id doesn't transfer to newvid
'newvid=dest.id
dest.close()
src.close()
'send user to the prod_detailview of this cloned record
'This line brings the user to the grid part but not the detail part.
response.redirect("productstest.a5w")

So, when does the id field rule fire? And how do I get that new value. Then how do I use it in a response.redirect statement?

Any help would be appreciated.

Dorothy

[Dorothy]

Re: Response.redirect to a particular detail view

It turns out the value for newvid is saved correctly if it is placed after dest.close() - since the field rules work after the file is closed.

The value for newvid is local to the page. How do I get the url to recognize it???

[Peter.Wayne]

Re: Response.redirect to a particular detail view

Hi Dorothy.
Without knowing exactly how your grid is set up, it's hard to give an answer, but in general you would want something like

response.redirect("productstest.a5w?id="+newvid)

if the productstest.a5w grid has the intelligence to move to an indicated record. I haven't worked with grids in a while but I believe there are ways to get them to sync to a given record.

[Dorothy]

Re: Response.redirect to a particular detail view

Hi Peter,

Indeed that does work to display all the records in the grid form with the correct record number in the url. But with the thousands of records in this table, the user would have to search for the one they want, then click through to get the detail view of that record.

The particular setup is that initially the grid is shown without the detail. To do this I chose those options in the grid setup.

On the grid I click on the detail link field to get the related detail view.

On this detail view I have a clickable field that goes out to clonepage.a5w ( the code above ) and now I want to return the user to the detail view of the cloned record, not the grid view.

productstest.a5w?productstest_DetailView=036&162259624#Productstest_DetailView

When I click through by hand from the grid to the detail, the above line ends up in the url. The numbers in red are added, I believe, by the Alpha program and without it I can't make it work.

It is pretty important that the user land on this cloned detail form in order to edit and complete it.

Dorothy

[Dorothy]

Re: Response.redirect to a particular detail view

It was a pleasure to stop "beating my head against this wall".

Instead I got to do a workaround. I created another grid which contains all the fields I had in the original detail view - only there is no detail view in this new one - only the grid part.

Then, with Pat Bremkamp's help, a filter arg was created and that passed the specific record number to the new grid and voila! the user is on the desired record.

Thanks to all for your help - it all led me in the right direction.

Dorothy