9f16c2bf8e
* *
* update copyright headers with new FSF postal address
* COPYING.txt -> LICENSE.txt (rest of repo to be synced)
139 lines
4.3 KiB
Plaintext
139 lines
4.3 KiB
Plaintext
/*
|
|
* ARRAY RDD example
|
|
*
|
|
* Copyright 2009 Francesco Saverio Giudice <info / at / fsgiudice / dot / com>
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify
|
|
* it under the terms of the GNU General Public License as published by
|
|
* the Free Software Foundation; either version 2, or (at your option)
|
|
* any later version.
|
|
*
|
|
* This program is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU General Public License
|
|
* along with this program; see the file LICENSE.txt. If not, write to
|
|
* the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
|
|
* Boston, MA 02110-1301 USA (or visit https://www.gnu.org/licenses/).
|
|
*
|
|
* As a special exception, the Harbour Project gives permission for
|
|
* additional uses of the text contained in its release of Harbour.
|
|
*
|
|
* The exception is that, if you link the Harbour libraries with other
|
|
* files to produce an executable, this does not by itself cause the
|
|
* resulting executable to be covered by the GNU General Public License.
|
|
* Your use of that executable is in no way restricted on account of
|
|
* linking the Harbour library code into it.
|
|
*
|
|
* This exception does not however invalidate any other reasons why
|
|
* the executable file might be covered by the GNU General Public License.
|
|
*
|
|
* This exception applies only to the code released by the Harbour
|
|
* Project under the name Harbour. If you copy code from other
|
|
* Harbour Project or Free Software Foundation releases into a copy of
|
|
* Harbour, as the General Public License permits, the exception does
|
|
* not apply to the code that you add in this way. To avoid misleading
|
|
* anyone as to the status of such modified files, you must delete
|
|
* this exception notice from them.
|
|
*
|
|
* If you write modifications of your own for Harbour, it is your choice
|
|
* whether to permit this exception to apply to your modifications.
|
|
* If you do not wish that, delete this exception notice.
|
|
*
|
|
*/
|
|
|
|
REQUEST ARRAYRDD
|
|
|
|
#define USE_DBCREATE_EXTENSIONS
|
|
|
|
PROCEDURE Main()
|
|
|
|
LOCAL aStruct
|
|
|
|
Set( _SET_DATEFORMAT, "yyyy-mm-dd" )
|
|
SET DELETED OFF
|
|
CLS
|
|
|
|
? "Create a new dbf in memory using dbCreate() command"
|
|
aStruct := { ;
|
|
{ "NAME" , "C", 40, 0 }, ;
|
|
{ "ADDRESS" , "C", 40, 0 }, ;
|
|
{ "BIRTHDAY" , "D", 8, 0 }, ;
|
|
{ "AGE" , "N", 3, 0 } }
|
|
|
|
#ifndef USE_DBCREATE_EXTENSIONS
|
|
? "Create it"
|
|
dbCreate( "arrtest.dbf", aStruct, "ARRAYRDD" )
|
|
WAIT
|
|
? "Open it"
|
|
USE arrtest.dbf VIA "ARRAYRDD"
|
|
WAIT
|
|
#else
|
|
? "Create it and leave opened"
|
|
dbCreate( "arrtest.dbf", aStruct, "ARRAYRDD", .T., "arrtest" )
|
|
WAIT
|
|
#endif
|
|
|
|
? "Show structure"
|
|
? hb_ValToExp( dbStruct() )
|
|
WAIT
|
|
|
|
? "ALIAS", Alias(), "RECNO", RecNo(), ;
|
|
"BOF", Bof(), "EOF", Eof(), "LASTREC", LastRec()
|
|
? RecNo(), '"' + FIELD->NAME + '"'
|
|
dbGoBottom()
|
|
? RecNo(), '"' + FIELD->NAME + '"'
|
|
dbGoTop()
|
|
? RecNo(), '"' + FIELD->NAME + '"'
|
|
WAIT
|
|
|
|
? "Adding some data"
|
|
dbAppend()
|
|
field->name := "Giudice Francesco Saverio"
|
|
field->address := "Main Street 10"
|
|
field->birthday := hb_SToD( "19670103" )
|
|
field->age := 39
|
|
|
|
? RecNo(), '"' + FIELD->NAME + '"'
|
|
|
|
dbAppend()
|
|
field->name := "Mouse Mickey"
|
|
field->address := "Main Street 20"
|
|
field->birthday := hb_SToD( "19400101" )
|
|
field->age := 66
|
|
|
|
WHILE ! Eof()
|
|
? RecNo(), '"' + FIELD->NAME + '"'
|
|
IF RecNo() == 20
|
|
Inkey( 0 )
|
|
ENDIF
|
|
dbSkip()
|
|
ENDDO
|
|
? "ALIAS", Alias(), "RECNO", RecNo(), ;
|
|
"BOF", Bof(), "EOF", Eof(), "LASTREC", LastRec()
|
|
WAIT
|
|
dbGoBottom()
|
|
? "ALIAS", Alias(), "RECNO", RecNo(), ;
|
|
"BOF", Bof(), "EOF", Eof(), "LASTREC", LastRec()
|
|
WAIT
|
|
WHILE ! Bof()
|
|
? RecNo(), '[' + FIELD->NAME + ']'
|
|
IF RecNo() == LastRec() - 20
|
|
Inkey( 0 )
|
|
ENDIF
|
|
dbSkip( -1 )
|
|
ENDDO
|
|
? "ALIAS", Alias(), "RECNO", RecNo(), ;
|
|
"BOF", Bof(), "EOF", Eof(), "LASTREC", LastRec()
|
|
WAIT
|
|
|
|
? "Show it - Please don't press any key except movement keys and ESC"
|
|
? " to exit from Browse(), otherwise you will get an error"
|
|
? " due to missing index support"
|
|
WAIT
|
|
Browse()
|
|
|
|
RETURN
|