Deutsch English
Alphabetical index
Array functions
CGI functions
Data types
Date functions
Debugging
Fulltext functions
Language elements
Numerical functions
Operators
Other functions
Ramtext functions
Selecting
Socket functions
Statistical functions
Stream functions
String functions
System functions
Table functions
    		• access()
    		• andmarks()
    		• autofield()
    		• autorecno()
    		• blobsize()
    		• blobtype()
    		• cleardat()
    		• closedb()
    		• copyblob()
    		• copymemo()
    		• dbdir()
    		• dbname()
    		• dbno()
    		• dbrights()
    		• deldb()
    		• delindex()
    		• delmark()
    		• delmarkedrecords()
    		• delmarks()
    		• delrec()
    		• editoff()
    		• editon()
    		• embedblob()
    		• exists()
    		• fields()
    		• filemode()
    		• fileno()
    		• filesize()
    		• findandmark()
    		• findauto()
    		• findrec()
    		• firstmark()
    		• firstrec()
    		• flushdb()
    		• fsum()
    		• genindex()
    		• getcode()
    		• getdef()
    		• getfield()
    		• getmarks()
    		• getmode()
    		• getpw()
    		• getrec()
    		• getrfield()
    		• getstructure()
    		• gettype()
    		• incrfield()
    		• inddef()
    		• indname()
    		• indno()
    		• ismark()
    		• label()
    		• labelno()
    		• lastrec()
    		• link()
    		• linkblob()
    		• linkinfo()
    		• lock()
    		• makedb()
    		• markdoubles()
    		• markindex()
    		• markpattern()
    		• maxfile()
    		• maxlabel()
    		• memolen()
    		• memostr()
    		• newtable()
    		• nextmark()
    		• nextrec()
    		• nmarks()
    		• opendb()
    		• prevrec()
    		• primfile()
    		• primtable()
    		• putmarks()
    		• putrec()
    		• readmemo()
    		• readrec()
    		• recno()
    		• recno()
    		• recnr()
    		• regenall()
    		• regenind()
    		• relation()
    		• rendb()
    		• reopendb()
    		• revmarks()
    		• setalias()
    		• setauto()
    		• setfield()
    		• setfields()
    		• setfilter()
    		• setmark()
    		• setmarks()
    		• setrecord()
    		• setrfield()
    		• sortmark()
    		• treeinfo()
    		• unlock()
    		• writerec()
    Text functions
    Home    Overview    Search    Impressum    Contact    Members
    Topic complex Table functions
    Function firstrec()
    Short Number of the first record regarding to the actual access
    Syntax FIRSTREC(db : INTEGER) : INTEGER
    Parameter db : Table handle from OpenDB
    Return physical record number of the first record
    See also:
    lastrec() nextrec() prevrec() firstmark() nextmark()
    Description In a way how the access is set with ACCESS for a table, FIRSTREC returns different results:

    Marking (-2): first record in marking list
    Number (-1) : 1 (if table is not empty)
    Index (0..15) : Record with the smallest index information

    Example: complete ordered passing through a table via an index 

    db:=OpenDB(...);

    access(db,1); // Set access on index

    x:=firstrec(db);

    WHILE x DO

      readrec(db,x);

      ... here the record is available

      x:=nextrec(db)

    END;
    		

    

    


    

    

    
 
    User comments:
    
 
    

    

    

    


    
Write a comment:

    




    

    
Name

    

    
EMail

    

    
Subject

    

    
Text (Switch mode)

    Choose between
    the normal and the
     advanced editor.
     The advanced editor
     runs in IE 5+ and
    Mozilla 1.4+ only
    		

    

    
SPAM-Protection Please enter tdbengine in this field.

    

    

    

    		
         		
    
    
   
    
      		
  
   
    
    
    
     
      
    
       
    
        
        
       
    
       
    
        
        
       
    
      
    
         		
    
    
    
    
     
      
    
       
    
        
        

    



    
           		
       
      
    
     
    	
       		
  
    
 
    
    		

    

    
 
  
    
   
    
    
    
	tdbengine chat
    
    irc.tdbengine.org
    
    #tdbengine    		
    
   
    
   
    
  
    
     		
 
  
    
   
    
   
    
      Copyright © 2003-2004 tdb Software Service GmbH
    
      Alle rechte vorbehalten. / All rights reserved
    
      Last changed:  21.10.2004
    
   
    
  
    
     		
 
  
    
   
    
    
    
      
    
       
    
       
    {Fehler für :execmacro{execmacro="sessionspy"}