English
Online-Documentation

dbbrowse function: data base, DBase, SQL

 

Dirk
Kuntzmann
erg% = @db("Browse",I1,I2,s3,I4,s5,I6)

Syntax to Version 10: erg% = @dbBrowse(I1,I2,s3,I4,s5,I6)

dbBrowse() is a dialog, the the works with dBase-tables vastly vereinfacht (Related: LINKF:[dbEdit]()). The scheduler must before with LINKF:[dbOpen]() opened and LINKF:[dbUse]() choosed been his. should one index used go, must it with LINKF:[dbIndex]() opened been his. (Ggf. is it before with LINKP:[dBCreateIndex] to create.)

Parameterbeschreibung:
P:I1,P:I2- XY-position the DBF-Browsers on-screen
P:s3- cover (Überschriftzeile)
P:I4- Number of darzustellenden Lines (3..100)
P:s5- Parameter to indicated the anzuzeigenden boxes (Split). for each slot go three indicated (through Semikolon separated) needed (max. 100 Split):
- name the Field in the Datenbanktabelle
- Anzuzeigende Spaltenüberschrift for the area
- wide the Field in Pixeln
P:I6- mode
0 = only reading
1 = Change/delete allows
2 = Auswahlliste (gewählter set in Result the function)
3 = Auswahlliste with erweiterter Editierfunktion and Suchfunktion

to that mode are 16 To add (means 16, 17 or 18), if at Click into Scrollable (between Button and arrow), The list not circa 10% (standard in XProfan) weitergescrollt go should, separate exakt around the circa 1 reduced Number of dargestellten Lines. the allows one flaking by the scheduler.

the Result depends itself to the chosen mode:
0- without weight
1- mismatched 0 (zero): it watts one Datensatz changed or deleted
2- Ausgewählter set

in the entrapment of mode 1 is it recommendable with one Funktionsergebnis mismatched 0 (zero) The Datenbanktabelle with LINKF:[dbPack] To pack and if one index used watts, it with LINKP:[dbCreateIndex] new to create. (with dbPack weg fundamentally any Indexinformationen lost.)

circa a Datensatz To edit, is the suitable Radiobutton anzuklicken. The Changes go through activate the "ENTER"- or. "RETURN"-Button completed and The Datenbanktabelle written. with "ESC", by the Button "ZURÜCK" or STRG-A, through erneutes Anklicken the row or through Anklicken of/ one others row go The Changes verworfen. through pressing the Buttons "LÖSCHEN" or STRG-L becomes the Datensatz as deleted markiert (he'll gray displayed); through erneutes repeat the action becomes it again manufactured. Derart as deleted markierte Datensätze (gray statement) go first then for good deleted, if joining LINKF:[dbPack] called becomes! If one not Editiermodus is, can through "NEU" or. STRG-n a new clear Insert Record. becomes one index used, becomes it on whom beginning the scheduler staid, otherwise on its end.

in the Auswahlmodus 2 becomes the currently chosen Datensatz with "OK" zurückgegeben.

The mode 3 allows it, with only one appeal a complete application for a scheduler To release. in the mode 3 there a additional Button "Ändern". If one this pressing, becomes the markierte Datensatz How with LINKF:[dbEdit]() to that edit opened. exits one whom Dialogue with "OK" becomes The Änderung into scheduler übernommen. The Button "New" opens here too whom Editier-Dialogue with one clear Datensatz. and has The opened scheduler yet a active index, so there a further Button "Suchen" and one can in the Indexfeld (or. in the first, if it one Key from several Feldern is) search. Datumsfelder must in the landestypischen stature (means with us "TT.MM.JJJJ") association go. otherwise results one Info and the set won't übernommen. Ausserdem must the date one gültiges gregorianisches date his.

Numerische boxes go screen and in the tuned stature displayed. Fehleingabe won't allows.

with logischen Feldern becomes the first characters the input ausgewertet. The letters YyJjTt go as true gewertet and as "T" into scheduler geschrieben; with NnFf becomes one "F" written.

go with Textfeldern too long Strings association, go tappt im dunkeln on Feldlänge gekürzt.
 
01/19/38  
 



Note / Question or Comment to the Help--Topic


Topictitle, max. 100 characters.
 

Systemprofile:

no Systemprofil laid out. [anlegen]

XProfan:

 Posting  Font  Smilies  ▼ 

Please register circa a Posting To verfassen.
 

Topic-Options

1.289 Views

Untitledvor 0 min.
QuaraMan08/28/21
Walter02/21/19
Rainer Hoefs07/05/15
KFU07/12/13
More...

Themeninformationen

this Topic has 1 subscriber:

Dirk Kuntzmann (1x)


Admins  |  AGB  |  Applications  |  Authors  |  Chat  |  Privacy Policy  |  Download  |  Entrance  |  Help  |  Merchantportal  |  Imprint  |  Mart  |  Interfaces  |  SDK  |  Services  |  Games  |  Search  |  Support

One proposition all XProfan, The there's!


My XProfan
Private Messages
Own Storage Forum
Topics-Remember-List
Own Posts
Own Topics
Clipboard
Log off
 Deutsch English Français Español Italia
Translations

Privacy Policy


we use Cookies only as Session-Cookies because of the technical necessity and with us there no Cookies of Drittanbietern.

If you here on our Website click or navigate, stimmst You ours registration of Information in our Cookies on XProfan.Net To.

further Information To our Cookies and moreover, How You The control above keep, find You in ours nachfolgenden Datenschutzerklärung.


all rightDatenschutzerklärung
i want none Cookie