Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uniqueness violation
Message
De
25/07/2003 15:07:57
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Uniqueness violation
Divers
Thread ID:
00813610
Message ID:
00813610
Vues:
35
I keep getting a uniqueness violation error in the following code after the insert.
				Select tparams
				Local lcSetFeature
				lcSetFeature=lcToolSet+'.'+Alltrim(cImport.ffeature)
				If !Indexseek(lcSetFeature,.F.,'tparams','setfeature')
					**fgagenum is not included in the import data
					Insert Into tparams (ftoolset,ffeature,fbase,fplus,fminus) Values ;
						(lcToolSet,cImport.ffeature,cImport.fbase_b,cImport.fplus,cImport.fminus)
				Endif
Where setfeature is a primary key.=alltrim(ftoolset)+'.'+alltrim(ffeature) filter set to .not. deleted().

First I am searching to see if the key already exists with the indexseek. Then if it does not, I insert a new one. How is uniqueness being violated. I have set exact on. It seems impossible to violate uniqueness here??
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform