 |
Ziandrox
Newbie
Joined: 08 Feb 2002
Posts: 8
|
 Posted: Mon Feb 18, 2002 4:59 am
Space in database column
|
I'm adding a check for previous entries of the same item in my database and I figured the best way would be to check the key words of the items, since these are bound to be unique even when the names are not. I named the key words column "Key Words" (Fits, eh?) and have had no problems working with it like it is (with the space). The problem comes when I try to check for duplicates...
#FIND {@ItemStats.Name} {All|ai} {Name} {1}
#IF (%rec = %null) {#NEW {All|ai} {@ItemStats}} {}
(Taken from an example on this board)
Now, I'm using @ItemStats.Name because I can't get Key Words to work. I've tried {@ItemStats.Key Words} and {"@ItemStats.Key Words"} (Yes, I've changed the other Name area to match). What is the correct way? |
|
|
|
|
Kjata
GURU
Joined: 10 Oct 2000
Posts: 4379
Location: USA
|
Posted: Mon Feb 18, 2002 1:16 pm
|
Can't remember very well if this will work, but try:
@{ItemStats.Key Words}
If it still doesn't work, then I suggest you think about changing that columns name.
Kjata |
|
|
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
