FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
Accueil
→
WINDEV Mobile 2024
→
More detail in resetting database
More detail in resetting database
Débuté par Mike Stewart, 07 fév. 2017 18:47 - 4 réponses
Connectez-vous…
Mike Stewart
#1
Posté le 07 février 2017 - 18:47
I am trying to delete all of the data from my database as part of a security feature.
I tried looping through an array of filenames and using hdeleteall but not all of the physical files had been created yet because of some of them needing password protection.
However, I was unable to deal with the errors when the files could not be found.
This I solved by creating the file using hcreationifnotfound to create the files.
However......
I am still having problems as they are certain files which hdeleteall is not working. I have tried opening and or closing the file before hand. I have tried hdelete... but the one line of data is still there.
Please help... this is driving me crazy
Signaler
0
0
Fabrice Harari
#2
Posté le 07 février 2017 - 21:32
Hi Mike,
as I was saying before, a simple loop on hCreation will do the trick
(it will create/force the file EMPTY)
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)
More information on
http://www.fabriceharari.com
Le 2/7/2017 à 12:47 PM, Mike Stewart a écrit :
I am trying to delete all of the data from my database as part of a
security feature.
I tried looping through an array of filenames and using hdeleteall but
not all of the physical files had been created yet because of some of
them needing password protection.
However, I was unable to deal with the errors when the files could not
be found.
This I solved by creating the file using hcreationifnotfound to create
the files.
However......
I am still having problems as they are certain files which hdeleteall is
not working. I have tried opening and or closing the file before hand.
I have tried hdelete... but the one line of data is still there.
Please help... this is driving me crazy
Signaler
0
0
Mike Stewart
#3
Posté le 07 février 2017 - 22:35
OK... so hcreation works where hdeleteall doesn't
No idea why but thanks Fabrice
Signaler
0
0
BOLLER
#4
Membre enregistré
3 657 messages
Popularité : +175 (223 votes)
Posté le 08 février 2017 - 03:21
Hello mike
Contact me by skype adrianoboller
I will help you
:thank you:
--
Adriano José Boller
______________________________________________
Consultor e Representante Oficial da
PcSoft no Brasil
+55 (41) 99949 1800
adrianoboller@gmail.com
skype: adrianoboller
http://wxinformatica.com.br/
Signaler
0
0
Fabrice Harari
#5
Posté le 08 février 2017 - 13:17
Hi
Le 2/7/2017 à 4:35 PM, Mike Stewart a écrit :
OK... so hcreation works where hdeleteall doesn't
No idea why but thanks Fabrice
It's simple: They are not doing the same thing.
hdeleteall delete ALL RECORDS inside the file. For that, the file NEEDS
TO EXIST, and that was your problem.
hCreation creates the file empty (if it's already there it's overwritten
empty). So this works if your file exist or not (and i('s much faster too).
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)
More information on
http://www.fabriceharari.com
Signaler
0
0
→ Revenir à WINDEV Mobile 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte