Click above to get retro games delivered to your door ever month!

 build from fields   Create a database from a field list
------------------------------------------------------------------------------
 Syntax
   build cFile from fields fields

 Arguments
   cFile is the name of the database file to create.
   fields is a list of fields defined in an alias declaration.

 Description
   The build from fields command creates the database file specified
   by cFile and then constructs a database header from fields.

   The file created by build from fields is not open when the command returns,
   i. e. it is not ready for appending, replacing, etc. The file must be
   opened with the open or use command after it has been built.

 Example
   #define EXAMPLE_DATABASE
   #include example.hdr

   dbfdef sTemp2
      char( 15 ) lastname
      dbl( 9:2 ) balance
      date       due
   enddef
   
   proc Test_buildfromfields
   vardef
      uint n
   enddef
   open sTest                          // open template database
   build "stemp2.dbf" from fields sTest->lastname, sTest->balance, sTest->due
   open sTemp2                         // open new database
   ? "New database is", adbf( sTemp2 ) // display structural data
   ? "Number of fields is", istr( afldcnt( sTemp2 ) )
   for n := 1 to afldcnt( sTemp2 )
      ? afieldname( sTemp2, n ):10, afieldtype( sTemp2, n ), ;
         afieldlen( sTemp2, n ), afielddec( sTemp2, n )
   next
   close all                           // clean up
   endproc

   proc main
   Test_buildfromfields()
   endproc