Oct 10, 2008 15:21
15 yrs ago
French term
France
clé
French to English
Tech/Engineering
IT (Information Technology)
I know that this sounds like such a stupid basic question but I've been pondering over the sentence below for a few days now:
"L'interrogation du référentiel local des plateformes est effectuée avec comme ***clé*** le champ EquipmentID sur le champ EQUIPEMENT."
What does "clé" mean here? Does it mean "search term" or "key value" or simply "key"?
The problem is that I don't see how a query can be run in a given field using another field...?
Can anyone more knowledgeable in IT help?
Thanks.
"L'interrogation du référentiel local des plateformes est effectuée avec comme ***clé*** le champ EquipmentID sur le champ EQUIPEMENT."
What does "clé" mean here? Does it mean "search term" or "key value" or simply "key"?
The problem is that I don't see how a query can be run in a given field using another field...?
Can anyone more knowledgeable in IT help?
Thanks.
Proposed translations
(English)
| 4 +1 | key |
Maureen Wilkins (X)
|
| 4 | key |
Yasdnil1
|
| 3 | search term / key value |
veratek
|
Proposed translations
+1
5 mins
Selected
key
The EquipmentID field is used as the "key" from one file (data record) to match with the EQUIPMENT field in the other file to retrieve the data from the associated record in the second file.
Do they mean "champ" EQUIPMENT or "enregistrement" EQUIPMENT? I wonder.
Do they mean "champ" EQUIPMENT or "enregistrement" EQUIPMENT? I wonder.
4 KudoZ points awarded for this answer.
Comment: "Yes, of course! Now I remember how I used to organise my Access DB a long time ago... :-).
Thanks to everyone for your patience and your explanations!"
8 mins
key
This sounds like the field in one table is a foreign key to the field in the other table, so can be used to join from one table to another during a search.
Note from asker:
| Thanks Yasdnil for your explanation! Unfortunately, I can't split points... |
7 mins
search term / key value
Without any more context, as far as I understand it, they are going to take the value in the EquipmentID field as the search term running it against the values in the Equipment field.
--------------------------------------------------
Note added at 10 mins (2008-10-10 15:32:05 GMT)
--------------------------------------------------
running it against the values (in different records) in the Equipment field.
What I first wrote was ambiguous, it's not that the Equipment field has many values, but a file will have several records each containing an Equipment field, thus the "values" that will be compared to the Equipment ID search term.
--------------------------------------------------
Note added at 18 hrs (2008-10-11 09:42:27 GMT)
--------------------------------------------------
Neil: I disagree that "search term" is definitely out. They are looking up each record in the second database (specifically the Equipment field) and comparing it against the value they took from EquipmentID to find a match. Thus the value in EquipmentID is being used as a search term.
Ex:
http://www.textanalysis.com/help/howtobuild/dictlookupurl/di...
Discover Variable Names to Accompany CGI
Variables for word lookup are specified after the question mark "?". Key-value pairs can be found separated by the ampersand character "&". Each key-value pair is further separated by an equal sign "=".
The first key-value pair (q=baas) is our search term "baas" and the second key-value pair (btnG=Google+Search) is the Google convention used to indicate an unknown key-value pair.
======================================
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserve...
If I understand what you're trying to do correctly, you do this:
CREATE PROC ProductPrice
AS
SELECT * from products WHERE ProductID LIKE "%Car%" OR ProductID IS NOT
NULL)
GO
You'd normally want to pass a parameter though instead of hard-coding a search term like "%car%".
===================================
On the other hand, since the original was "comme clé," maybe key value is the best choice.
It's not that relevant, but the original text also states "est effectuée avec **comme** clé" - so, as I understand it, EquipmentID is not a key, but it's being used as one.
--------------------------------------------------
Note added at 10 mins (2008-10-10 15:32:05 GMT)
--------------------------------------------------
running it against the values (in different records) in the Equipment field.
What I first wrote was ambiguous, it's not that the Equipment field has many values, but a file will have several records each containing an Equipment field, thus the "values" that will be compared to the Equipment ID search term.
--------------------------------------------------
Note added at 18 hrs (2008-10-11 09:42:27 GMT)
--------------------------------------------------
Neil: I disagree that "search term" is definitely out. They are looking up each record in the second database (specifically the Equipment field) and comparing it against the value they took from EquipmentID to find a match. Thus the value in EquipmentID is being used as a search term.
Ex:
http://www.textanalysis.com/help/howtobuild/dictlookupurl/di...
Discover Variable Names to Accompany CGI
Variables for word lookup are specified after the question mark "?". Key-value pairs can be found separated by the ampersand character "&". Each key-value pair is further separated by an equal sign "=".
The first key-value pair (q=baas) is our search term "baas" and the second key-value pair (btnG=Google+Search) is the Google convention used to indicate an unknown key-value pair.
======================================
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserve...
If I understand what you're trying to do correctly, you do this:
CREATE PROC ProductPrice
AS
SELECT * from products WHERE ProductID LIKE "%Car%" OR ProductID IS NOT
NULL)
GO
You'd normally want to pass a parameter though instead of hard-coding a search term like "%car%".
===================================
On the other hand, since the original was "comme clé," maybe key value is the best choice.
It's not that relevant, but the original text also states "est effectuée avec **comme** clé" - so, as I understand it, EquipmentID is not a key, but it's being used as one.
Peer comment(s):
| neutral |
Neil Coffey
: The name "EquipmentID" definitely sounds like the name of a database column. So I think "key" rather than "key value"; "search term" definitely out.
8 hrs
|
Something went wrong...