add "temporary" TAG in Index ?

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
tonton2
Posts: 484
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
WatsApp :+213770943143
User avatar
tonton2
Posts: 484
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
WatsApp :+213770943143
User avatar
tonton2
Posts: 484
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 106 times
L'Algerie vous salut
Y.TABET
WatsApp :+213770943143
User avatar
tonton2
Posts: 484
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 94 times
L'Algerie vous salut
Y.TABET
WatsApp :+213770943143
User avatar
serge_girard
Posts: 3420
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