TIP: Click on subject to list as thread! ANSI
echo: paradox
to: LEE MOST
from: LANCE LEONARD
date: 1994-11-25 15:04:00
subject: Record# Field In Pdoxwin

Lee,
 
 LM> I want to put a record number field in a detail table on a form
It's actually pretty easy, but it is different that what you might be
expecting.  Add a column to your table frame and then define the field 
that's created in the new column as a calculated field using:
   self.recNo
recNo is a property of data-bound objects and returns the record number
of the underlying table.  Also, remember that appended records (the records 
added to the bottom of a table frame when you move beyond the last record) 
have a record number of 0 until they're posted to the table.  This stems from 
the fact that the appended record doesn't truly "exist" in the table until 
it's actually posted.  (In SQL terms, this is called a "crack" record.)
 
(I may be mis-remembering the actual syntax.  If self.recNo doesn't compile, 
then try self.recNo().)
 
Hope this helps...
 
-- Lance
--- Maximus 2.02
---------------
* Origin: Mountain Retreat (1:216/506)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.