English
Forum

Datenbankeintrag delete

 
of these code lösche I aimed a Datenbankeintrag:
CompileMarkSeparation
IF CLICKED(kill%) | MenuItem(60)

    MessageBox(Wollen Sie den Eintrag
    +UPPER$(titel$)+
    wirklich löschen ?,Lösch-Funktion,292)

    IF %Button = 6

        CHDIR pfad$+\+verz01$
        @db(Open, #3, pfad$+\+verz01$+\DB_KATALOG.DBF)
        @db(Use,#3)
        @db(Go, Z%)
        @db(Delete)
        @db(Pack)
        @db(close,#3)
        @db(Open, #4, pfad$+\+verz01$+\DB_KATALOG.DBF)
        @db(Use,#4)
        @db(CreateIndex, NAME, IXNAME)
        @db(CreateIndex, BILD, IXBILD)
        @db(close,#4)
        @db(Open, #5, pfad$+\+verz01$+\DB_KATALOG.DBF)
        @db(Use,#5)
        @db(Index, IXNAME, IXBILD)
        @db(close,#5)
        INHALTS_ANZEIGE Hier wird die Eintragsanzeige aktualisiert
        SetFocus(mn_inhalt&)

    ENDIF

ENDIF


The entry becomes too deleted but joining stand The Texts the others data confusion. in the data-bank are 1 area with the names, 1 area with a Bildernamen and two Memofelder. everything works, bloss the Delete proposes Purzelbaum - What is wrong ?
 
06/13/08  
 




Thomas
Freier
somehow have I doubt, that the before so went. in the principle can for a MEMO-area no index-File prepares go.
 
Gruß Thomas
Windows XP SP2, XProfan X2
06/13/08  
 




Dieter
Zornow
You open The data base setting none index and using but with db(go,index The with Indexvariante instead of db(GO,feldnr&) How Jac already written has can no Memofelder as Indizes uses go. 4 x Indizes go neither More taken care of maximum 2
 
Er ist ein Mann wie ein Baum. Sie nennen ihn Bonsai., Win 7 32 bit und Win 7 64 bit, mit XProfan X2
06/14/08  
 



now Have I to Euren Ratschlägen whom code modifiziert (in the first Posting Have I the code ausgetauscht) and its very so How before. Why I get, if I X%=@db(index, IXNAME, IXBILD) request, a zero. loudly Help should here a one showing. The index-Files are still present. see me my stupid Fragerei to. After many years Profan-using work I the first time with database-Files. there are The Error already vorprogrammiert ! Nobody is perfect !

Nachschlag:
The Error lying by me - Getcount is Nullbasierend (nice word) and the Feldeinträge begin with one. my Loop for Inhaltsanzeige began too with one To count and therefore coming to the Delete one Datensatzes everything confusion ! - now begins The Loop with zero and alls works.
thanks but nevertheless for Tipps about INDEX
 
06/14/08  
 




Jac
de
Lad
@Dieter: I had here yet nothing written, schließe me but immediate the opinion on.
 
Profan² 2.6 bis XProfan 11.1+XPSE+XPIA+XPRR (und irgendwann XIDE)
Core2Duo E8500/T2250, 8192/1024 MB, Radeon HD4850/Radeon XPress 1250, Vista64/XP
06/14/08  
 




Dieter
Zornow
@Jac, you're right was Yes Thomas, having well yet your names in the head, I before your again rauf and down red having.
 
Er ist ein Mann wie ein Baum. Sie nennen ihn Bonsai., Win 7 32 bit und Win 7 64 bit, mit XProfan X2
06/14/08  
 




Jac
de
Lad
Oh You think on me.
 
Profan² 2.6 bis XProfan 11.1+XPSE+XPIA+XPRR (und irgendwann XIDE)
Core2Duo E8500/T2250, 8192/1024 MB, Radeon HD4850/Radeon XPress 1250, Vista64/XP
06/14/08  
 



...I war yet The crisis
everything to regulation made. Delete goes now, if I whom last Sign in the GridBOX lösche.
take I a willkürlichen entry , go The Texts into Memo-Feldern vertauscht. - and what's this thing for a File, which at Delete prepares becomes - DB3$$$.D$$ ? - nervous utterly on the ground Please I circa resolution
 
06/15/08  
 




Dieter
Zornow
i think time, that it longer the GridBOX as with the data base zusammenhängt, but without to know what You there make can you nobody help.
so as looks reads You The data base into GridBOX one, if You then what änderst has the first Sign in the GridBOX whom index 0 in the data base but 1 or if You a index einliest ever another Datensatznummer, there depends Perhaps your Error.
 
Er ist ein Mann wie ein Baum. Sie nennen ihn Bonsai., Win 7 32 bit und Win 7 64 bit, mit XProfan X2
06/15/08  
 



@Dieter - something like in the manner Have so did i in suspicion. work already with two variables (GridBOX and index) - Schalte I a Messagebox between to control, shows me these whom chosen entry too on and he'll deleted, but seltsamerweise move the Texts the Memo-boxes - the happens only, if I a free selection meet. The latest indicated entry becomes without complications deleted. - come but yet behind it
 
06/15/08  
 




Thomas
Freier
@Horst: I mach it something unkonventionell....Datensatz reading...Felderinhalte + Datensatznummer with Column 0 in a row.
CompileMarkSeparation
1. Spalten definieren
Titel$ = Links;0;180;Mitte;2;100;Nummer;1;0
2. Gridbox erstellen
hGrid&   = Create(GridBox, Dlg%, Titel$, 3, 3, 0, 400, 190)
3. hier werden die Gridbox-Zeilen hinzugefügt
AddString(hGrid&, FELD1|FELD2|Datensatz-Nr)

to that Change (Own mask) or Delete read I The Datensatznummer from and go so to that Datensatz.
so I had yet zero Problems, alike How indiziert or a GridBOX or one List view umsortiert watts.
 
Gruß Thomas
Windows XP SP2, XProfan X2
06/15/08  
 




Thomas
Freier
@Horst, I hope you have The crisis überwunden and dbf not The corner banished.
In of my Müllkiste found I one Script for MEMO-area data in a list view (yet not uses) and something in your direction adjusted. Perhaps find You there Solutions.

389 kB
Hochgeladen:06/17/08
Downloadcounter121
Download
 
Gruß Thomas
Windows XP SP2, XProfan X2
06/17/08  
 




Answer


Topictitle, max. 100 characters.
 

Systemprofile:

no Systemprofil laid out. [anlegen]

XProfan:

 Posting  Font  Smilies  ▼ 

Please register circa a Posting To verfassen.
 

Topic-Options

1.733 Views

Untitledvor 0 min.
Tommy02/18/14
Uwe Lang07/17/12
funkheld05/25/12
Georg12/14/11

Themeninformationen



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