|
| Débuté par John Marrone, 24 sep. 2008 01:55 - 4 réponses |
| |
| | | |
|
| |
Posté le 24 septembre 2008 - 01:55 |
Hi All
I have a problem. I have created 6 tables. 2 of them have composite keys. 1 table is called workouts. When I run the program I get the error ->HBuildKey function called. No item found in Entries file. Error code 70202. I am adding data to the workouts table. I am building the key ->dateHrsName = HBuildKeyValue(Wokouts.date_of_workouthorse,rd[index, 101 + i] ,rd[index,45]). What has this got to do with the entries table. The entries table is not even linked to the workouts table. I am in the local procedure ImportWorkoutsData. I just got threw importing data into the entries table before I called this procedure?? Am I not in the right work area And I don't think WD has work areas but I am really reaching on this one.
Here is my could. It errors out at the HBuildKey line.
PROCEDURE ImportWorkoutsData(index is int)
LOCAL
i is a int
dateHrsName is a string
IF rd[index,5] = "S" THEN RETURN
FOR i = 1 TO 10
IF rd[index, 101 + i] = "" THEN
RETURN
END
dateHrsName = HBuildKeyValue(Wokouts.date_of_workouthorse,rd[index, 101 + i] ,rd[index,45]) HBuildKey function called. No item found in Entries file. Error code 70202. Hope somebody can help me here. I can not figure this out.
END |
| |
| |
| | | |
|
| | |
| |
Posté le 24 septembre 2008 - 01:54 |
Hi All
I have got it working by switching to this code and not using HBuildkey.
HReadSeekFirst(Wokouts, date_of_workouthorse,[rd[index, 101 + i], rd[index,45]])
This way you do not have to build a composite key. I still don't understand why it would not work right the other way. I looked in help under HBuildKey and the help recommended to use this method as it is quicker.
Thought others might want to know this.
Thanks for you time and effort. |
| |
| |
| | | |
|
| | |
| |
Posté le 24 septembre 2008 - 01:55 |
Hello,
It actually does work but there's a typo in your code. Wokouts.date_of_workouthorse this will result in the date you mentioned.
[code]
dateHrsName = HBuildKeyValue(Wokouts.date_of_workouthorse,rd[index, 101 + i] ,rd[index,45]) |
| |
| |
| | | |
|
| | |
| |
Posté le 24 septembre 2008 - 01:55 |
Thanks, I work alone so I don't have an other pair of eyes to look at the code. Thanks I should of guessed that cause I know how to use the function. I knew it had to be me. |
| |
| |
| | | |
|
| | |
| |
Posté le 24 septembre 2008 - 01:56 |
Hi John,
I also use the second way of searching on comp keys.
I have had a quick look on your code : I think the point after your filename should be replaced by an comma.
dateHrsName = HBuildKeyValue(Wokouts[size=x-large][color=#FF0000].[/color][/size]date_of_workouthorse,rd[index, 101 + i] ,rd[index,45])
must be
dateHrsName = HBuildKeyValue(Wokouts[size=x-large][color=#FF0000],[/color][/size]date_of_workouthorse,rd[index, 101 + i] ,rd[index,45])
regards,
Joris. |
| |
| |
| | | |
|
| | | | |
| | |
|