Posted by Jerry Stuckle on 10/18/07 18:35

Arne Essa Madsen wrote:
> Need help to idea for how to make the following procedure or function:
>
> What I have:
> On the screen I have a simple list with with the most important fields
> of a the records in an MySQL database.
>
> What I want to do:
> I want a program/function/procedure so I can click a link in each record
> and then jump to a form showing all the fields.
>
> Why I want to do it:
> So I can see all the fields in the record, Or edit the data in the form
>
> The problem:
> The problem is NOT the program for the list or the form "Show record" or
> the form "Edit record"
>
> What I would like to get here:
> Either the idea for how to implement this program/function/procedure or
> a complete program/function/procedure to do it.
>
> This request may be boiled down to:
> How can I extract the record number from a simple database list so I can
> use it to a search or to select a specific record.
>
> Arne
> flying_donald_duck@msn.com
>

SQL databases don't have a "record number". Rather, you need to define
a primary key for the table (usually an autonumber column).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]