CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Skip records in edit-form with PHP?

Print topic Send  topic

Author Message
SnoopyCC

Posts: 3
Posted: 10/17/2005, 12:36 AM

Hello,

I like to combine an simple edit form (NewRecord1) with a navigator to skip through the records of a MySQL-table. At the moment, I can view and edit only one record in the form.

But CCS says, the navigator can only be used with a grid or an editable grid. But I do not want a grid. :-<

Is there a solution to extend the edit form with PHP? Create a "skip forward"- and "skip back"-button and combine the onclick-event with PHP-source?

Thank you in advance.

Regards,
Snoopy, a CCS-beginner
View profile  Send private message
wkempees
Posted: 10/17/2005, 2:19 AM

A Record Form traditionally needs a record pointer in the form of an
"id" to function in "edit" mode.
Therefore if you give it the Next id and call itself it should function.
Next and Previous would be buttons with a function for retreiving the
next and previous record id in you select.

I only once thought about this but as I can remember I solved it by
building a single row grid record form combi.
But this was a long time ago.

Just as a trigger it CAN be done.
Greetz,

Walter
Walter Kempees
Posted: 10/17/2005, 4:05 AM

My answer was incomplete:
Please look at ExamplePack NavGrid and NavRecordGrid, MultiStepRegistration
too.
It's explained in full.
Walter
"SnoopyCC" <SnoopyCC@forum.codecharge> schreef in bericht
news:5435354947370d@news.codecharge.com...
> Hello,
>
> I like to combine an simple edit form (NewRecord1) with a navigator to
> skip
> through the records of a MySQL-table. At the moment, I can view and edit
> only
> one record in the form.
>
> But CCS says, the navigator can only be used with a grid or an editable
> grid.
> But I do not want a grid. :-<
>
> Is there a solution to extend the edit form with PHP? Create a "skip
> forward"-
> and "skip back"-button and combine the onclick-event with PHP-source?
>
> Thank you in advance.
>
> Regards,
> Snoopy, a CCS-beginner
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

Damian Hupfeld
Posted: 10/17/2005, 5:30 AM

Try creating an Editable Record Grid with 1 spare row and only 1 record.

Damian

"SnoopyCC" <SnoopyCC@forum.codecharge> wrote in message
news:5435354947370d@news.codecharge.com...
> Hello,
>
> I like to combine an simple edit form (NewRecord1) with a navigator to
> skip
> through the records of a MySQL-table. At the moment, I can view and edit
> only
> one record in the form.
>
> But CCS says, the navigator can only be used with a grid or an editable
> grid.
> But I do not want a grid. :-<
>
> Is there a solution to extend the edit form with PHP? Create a "skip
> forward"-
> and "skip back"-button and combine the onclick-event with PHP-source?
>
> Thank you in advance.
>
> Regards,
> Snoopy, a CCS-beginner
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

SnoopyCC

Posts: 3
Posted: 10/17/2005, 5:55 AM

@wkempees, Damian Hupfeld: thank you for your answers

@Damian Hupfeld

I've tried to create an Editable Record Grid with only 1 row. But CCS always generates the fields in horizontal orientation. When I change the html manually to vertical, the structure seems to be destroyed. :-(

What I would like to have is an option to generate an Editable Record Grid with only one row, that is vertically aligned. A simple Edit Form with Navigation. That would solve the problem. And such forms are a standart in almost all applications.
View profile  Send private message
Damian Hupfeld
Posted: 10/17/2005, 6:04 AM

During the last step in the wizard change to Column layout.
If you are only ever updating records with this form set the spare row to
0.

regards
Damian Hupfeld

"SnoopyCC" <SnoopyCC@forum.codecharge> wrote in message
news:543539f3f1672f@news.codecharge.com...
> @wkempees, Damian Hupfeld: thank you for your answers
>
> @Damian Hupfeld
>
> I've tried to create an Editable Record Grid with only 1 row. But CCS
> always
> generates the fields in horizontal orientation. When I change the html
> manually
> to vertical, the structure seems to be destroyed. :-(
>
> What I would like to have is an option to generate an Editable
> Record
> Grid with only one row, that is vertically aligned. A simple Edit
> Form
> with Navigation. That would solve the problem. And such forms are a
> standart in
> almost all applications.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

SnoopyCC

Posts: 3
Posted: 10/17/2005, 7:04 AM

Quote Damian Hupfeld:
During the last step in the wizard change to Column layout. If you are only ever updating records with this form set the spare row to 0.
Super. This solves the problem - almost. I now have my Edit-Form with navigation, vertically.

But: If I click on the link (ID in this example) on the list-table, my new grid-edit-form opens. Ok. And the ID is transferred via html-get (&ID=10 for example), but the actual record isn't positioned. Instead it always starts a the first record. If I switch back, the edit-box (without navigations) runs fine.

?!??
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.