Skip Works With Numbers Not Characters

[jrtarrago]

Hi:

I made a field in a children table, that must be skiped with some values of a field in a head table. If the field in the head table it is a number (field number type) it works fine, but if the field in the head table is character type, it does not work, Could somebody give an idea of what's happening?

Thank you in advance

[Tom Cone Jr]

Re: Skip Works With Numbers Not Characters

Can't say until you show us the details, or furnish an example.

My guess is that you've forgotten to trim trailing blanks when comparing character strings.

[Keith Hubert]

Re: Skip Works With Numbers Not Characters

Or even put the Skip value in "Quotes".

[jrtarrago]

Re: Skip Works With Numbers Not Characters

Well, I think the problem could be in that way, but I have no idea how to deal it.
I can send you the small db that I made to test and solve the problem.

[jrtarrago]

Re: Skip Works With Numbers Not Characters

Or even put the Skip value in "Quotes".

Hi Keith : Yes I put the text between quotes

[jrtarrago]

Re: Skip Works With Numbers Not Characters

I am attaching then DB

[aschone]

Re: Skip Works With Numbers Not Characters

When I searched for the *StrKey() function it came back as being marked for internal use only. Not really sure what it is supposed to do but I do not believe you need it in your expressions. I have re-written the expressions for the skip fields and in the little test I did it appeared to be working correctly.


Skip entry for Fieldtoskip1

LOOKUP("entete","ID="+ID,"Datos")="BBBBBBBBBB"

Skip entry for Fieldtoskip2

LOOKUP("entete","ID="+ID,"Datos")="DDD"

[jrtarrago]

Re: Skip Works With Numbers Not Characters

Hi Ashcone:

Yes it works!!!, but I do not understand the logical:

LOOKUP("entete","ID="+ID,"Datos")="BBBBBBBBBB"

It make a lookup in entete table, then then made a filter with "ID="+ID, in "Datos"???

I am lost!!!

[Stan Mathews]

Re: Skip Works With Numbers Not Characters

Andrew,

That gave me pause as well.

? *strkey(3,2,0)
= "103"

Not at all what is needed and made the lookup fail (with the given data sample) - thus never skipping.

[Stan Mathews]

Re: Skip Works With Numbers Not Characters

Hi Ashcone:

Yes it works!!!, but I do not understand the logical:

LOOKUP("entete","ID="+ID,"Datos")="BBBBBBBBBB"

It make a lookup in entete table, then then made a filter with "ID="+ID, in "Datos"???

I am lost!!!

LOOKUP("entete","ID="+ID,"Datos")

reads as

lookup in the entete table
find entry where the ID field in the entete table =
the current value of the id field in the List table (the current context of the field rule)
return the Datos field from the entete table
check that being equal to "BBBBBBBBBB"

[jrtarrago]

Re: Skip Works With Numbers Not Characters

Well, Stan, thank you, I now I almost understand, but in the origin, do you know why does not work in the same way with numbers and with letters?

[Stan Mathews]

Re: Skip Works With Numbers Not Characters

It does work the same way. Your lookup failed (returned a logical false) because the *strkey() function return value did not match any ID's in the entete table.

You do have to change the lookup() filter for character values because Alpha handles numbers and strings differently.

? lookup("entete","ID = "+3,"Datos")
= "DDD       "

? lookup("entete","alltrim(str(ID)) = "+quote("3"),"Datos")
= "DDD       "