Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SYS(14) and KEY() do not include FOR clause, what does?
Message
De
11/12/2001 10:05:18
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
11/12/2001 09:59:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00592616
Message ID:
00592648
Vues:
16
>I guess that is what happens when I don't 'think about' what I'm reading! I should have paid closer attention!
>
>Thanks for the code!
>Tracy
VFP version :)
Create cursor crsINDEXES ;
	(TAG_NAME C(10) nocptrans, ;
	KEY_EXPR M, ;
	NDXTYPE C(1), ;
	IS_DESC L, ;
	FILTEREXPR M nocptrans, ;
	_TABLENAME M nocptrans)
*..

If tagcount()>0
   Dimension arrIndexes[tagcount(),6]
   For jx=1 to tagcount()
    arrIndexes[jx,1] = tag(jx)
    arrIndexes[jx,2] = key(jx)
    arrIndexes[jx,3] = iif(Primary(jx),'P',;
        iif(Candidate(jx),'C',iif(unique(jx),'U','R')))
    arrIndexes[jx,4] = descending(jx)
    arrIndexes[jx,5] = sys(2021,jx)
    arrIndexes[jx,6] = arrTables[ix,1]
  Endfor
  Insert into crsINDEXES from array arrIndexes
Endif
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform