add "temporary" TAG in Index ?

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
tonton2
Posts: 455
Joined: Sat Jun 29, 2013 1:26 pm
Location: Algerie
Contact:

Re: add "temporary" TAG in Index ?

Post by tonton2 »

Code: Select all

PROC CreaIndices
LOCAL aExtructura, nFor, cCampo, cIndice, Cais, cBase, cIndice
	Cais:=(cDossier+"\"+cFichier)
	cBase:=cDossier+"\Ind"
	USE &cais 
	aExtructura:=DBSTRUCT()
	FOR nFor=1 TO LEN(aExtructura)
		cCampo :=FIELNAME(nFor)
		cIndice:=cBAse+StrZero(nFor,2)
		INDEX ON &cCampo TO (cIndice) ADDITIVE	
	NEXT
RETURN

[/quote]
Voila ce que je voulais ,
A partir d'une base de donnée quelconque (cBase), je voudrais créer une base de donnée des differents champs avec COPY STRUCTURE EXTENDED (cBase_Champ) , de là créer des fichiers index (index on cBase_Champ->Field_Name to cindice pour recno(1)
index on cBase_Champ->Field_Name to cindice pour recno(2) etc...)

translate from google
Esto es lo que quería,
Desde cualquier base de datos (cBase), me gustaría crear una base de datos de los diferentes campos con COPY STRUCTURE EXTENDED (cBase_Champ), desde allí crear archivos de índice (index on cBase_Champ->Field_Name to cindice pour recno(1)
index on cBase_Champ->Field_Name to cindice pour recno(2) etc...)
L'Algerie vous salut
Y.TABET
User avatar
tonton2
Posts: 455
Joined: Sat Jun 29, 2013 1:26 pm
Location: Algerie
Contact:

Re: add "temporary" TAG in Index ?

Post by tonton2 »

Your example working very good thank's
L'Algerie vous salut
Y.TABET
User avatar
tonton2
Posts: 455
Joined: Sat Jun 29, 2013 1:26 pm
Location: Algerie
Contact:

Re: add "temporary" TAG in Index ?

Post by tonton2 »

Bonjour ,
Aquí está el programa finalizado gracias a la Sr. SALINETAS24 y GRIGORY muchas gracias a ellos.
Here is the program finalized thanks to Mrs SALINETAS24 and GRIGORY big thanks to them
Voila le programme finalisé grâce à Mrs SALINETAS24 et GRIGORY grand merci a eux
Attachments
DOSSIER_ESSAI.rar
(1.22 MiB) Downloaded 87 times
L'Algerie vous salut
Y.TABET
User avatar
tonton2
Posts: 455
Joined: Sat Jun 29, 2013 1:26 pm
Location: Algerie
Contact:

Re: add "temporary" TAG in Index ?

Post by tonton2 »

tonton2 wrote: Thu Jan 26, 2023 1:05 pm Bonjour ,
Aquí está el programa finalizado gracias a la Sr. SALINETAS24 y GRIGORY muchas gracias a ellos.
Here is the program finalized thanks to Mrs SALINETAS24 and GRIGORY big thanks to them
Voila le programme finalisé grâce à Mrs SALINETAS24 et GRIGORY grand merci a eux
The same example but it is for HMG extended (Minigui) because Edit Extended Minigui is better than HMG.3.4.4
Attachments
OuvrirDBF_MINIGUI.rar
(951.37 KiB) Downloaded 76 times
L'Algerie vous salut
Y.TABET
User avatar
serge_girard
Posts: 3309
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: add "temporary" TAG in Index ?

Post by serge_girard »

Tonton,

de combiens de d'enregistrements dans le fichier il s'agit? A tu essaye LOCATE?
Creer des indexes ça prends du temps aussi..!

Serge
There's nothing you can do that can't be done...
Post Reply