Transform

[Charles Hoens]

I'm having a terrible problem with what I call a transform function. I know this is not the same as referred to in the field rules, but perhaps it should be.

In any event, I need to change/modify/transform, a user's entry in a character field which only accepts numbers. The change needs to be made in the CanDepart event, so that when a user enters "1" for example, the field is transformed into "01". Similarly if he enters "2", then the field is changed to "02".

I've tried the "set value of a field" function, but it does not seem to yield the results I need. I can do this outside of the database with an operation, but that will create other problems for me. Shouldn't this be a transform function or am I missing something????

Charlie

[crimmelcp]

RE: Transform

Assuming that the table is not part of a set and the form is based on the table.

t=table.current()
t.change_begin()
If val(t.field)>0 .and. val(t.field)

[drgarytraub]

RE: Transform

Isn't the key point here that the field cannot be numeric. It has to be character. Also, an an alternative way would be to put this into the OnDepart event:

if len(field.value)=1
field.value="0"+alltrim(field.value)
end if

Gary Traub

[drgarytraub]

RE: Transform

I just tested this and it works well from the OnDepart, CanDepart, or OnChange events.

Gary

[Charles Hoens]

RE: Transform

Thanks guys:

I tried both of these suggestions and I cannot get them to work. Part of the problem is that I am using the CanDepart event to check for duplicates using a comnplicated function. This "ApprNumber" field is one item that is used to calculate another expression which in turn is checked for duplicates.

I am using the year and the month along with this number to make up this field viz. "2002-12-01", "2002-12-02", etc.

Each one of these needs to be unique. The lookup and duplicate checking is working fine, so now I'm down to this function. If I put the expression in the OnDepart, the CanDepart precedes it and I get an error. Therefore, what I need is to transform the entry in the CanDepart area.

Thanks for any additional help.

Charlie

[Charles Hoens]

RE: Transform

Gary:

Maybe it's me, but I keep getting "Apprnumber not found". Apprnumber is the name of the field.

Am I messed up?

Charlie

[Charles Hoens]

RE: Transform

Gary:

I figured out that I had to delete some code in another place to fix one problem.

Now I am getting A5 telling me "property not found" on the line "if len(field.value)=1"

Make any sense to you?

Charlie

[drgarytraub]

RE: Transform

if len(field.value)=1

is field the name of your field?

and is field a character field?

gary

[drgarytraub]

RE: Transform

Why not post the entire script so we can take a deeper look?

[Charles Hoens]

RE: Transform

No. The name of the field is apprnumber.

Yes, it is character.

Charlie

[Charles Hoens]

RE: Transform

I know - I always tell everyone else that too.

It's ok. I figured it out. It's getting so confusing that I'm about to write my own "Peter Wayne" book when I'm done!!!!!

Thanks for your help. You're the best!

Charlie

[Charles Hoens]

RE: Transform

Gary (and anyone else):

Here's the corrected code. Thanks to Gary and Charlie for getting me started!

t=table.current()
if len(trim(t.field))=1 then
t.field="0"+substr(t.field,1,1)
end if

As you can see, you need to have the table opened. Also, you need to trim the "Len" function. "Len" by itself will return the length of the character field, not what is in it. That's why when I entered a 1 by itself, I got a wrong result. The trim function sees what is in the field and thus you can test for it. Therefore, if the user enters "1" this function will correct itself and conversely if he enters "01" it will be all right too.

Again, my many thankks to Gary and Charlie. Just goes to show you that by giving each other a hand we can all help ourselves immensely!

Charlie