PureBasic

Code : Tout sélectionner

Create & Open Database
LdbOpen(Database.s)					Open an existing Database
LdbCreate(Database.s,Fields.s)		Create a new empty Database

Pointer in the Database
LdbGetPointer()					Get the current record
LdbSetPointer(Record)				Set the current record

Operation on records
LdbRecordCount()					Return the number of records
LdbRead(Field)						Read a field from the current record ( memo with CRLF accepted )
LdbWrite(Field,Text.s)				Write a field to the current record  ( memo with CRLF accepted )
LdbDeleteRecord()					Delete the current record
LdbInsertRecord(Nb)					Insert a record as Nb record, -1 add as last record
LdbPreviousRecord()					Move to the previous record
LdbNextRecord()					Move to the next record

Operation of Fields
LdbFieldCount()					Return the number of fields
LDBSetFieldName(Nb,FieldName.s)		Set the name of the specified field
LdbGetFieldName(Nb)					Return the name of the specified field
LdbAddField(FieldName.s)				Add a new field as last field 
LdbDeleteField(Nb)					Delete the specified field from the database

Search
LdbSearchInit(Field,Text.s,Options)	#Exact #CaseInsensitive #Everywhere
LdbSearch						Return the record while search found

Write Database
LdbClose()						Write and close the Database on disk