Our form contains an edit box for the user to enter the first part of a two part key. The next edit box is for the 2nd part of the key.

When the user enters both keys, the data from the record is displayed on the form - no big deal.

Now the problem(s)

1. We added color to the active edit box using the set_property and changing the background color in the Got_Focus event and reset the color in the Lost_Focus event.

  Result:

      The color change worked fine, however, we lost the data from the record.  It will not display.

Any ideas as to why we are losing the read/display????

2. We deleted the set_property for color from the Got_Focus and Lost_Focus and recompiled.

  Result:  the color was still on the form when it was ran as if no changes were made.  No read/display either.

Any ideas as to why, when the script is removed from an edit box, event it is still there????

Andy,

This sounds like you are not continuing the event chain.

You say you removed the event but how did you do this .. you didn't just delete did you. You have to 'clear event' from the edit menu in the event editor.

[email protected] onmouseover=window.status=imagine … a company that supports their product from pride not extortion;return(true)"

David Tod Sigafoos ~ SigSolutions

[email protected] Cell:503-341-2983

Andy-

As Sig has already suggested, you need to get rid of an event handler by choosing Edit-Clear Event from the menu in the Event handler menu.

Regarding your loss of data- did you have a ' return 1 ' at the end of your scripts? It sounds like you were truncating the event chain.

Hope it helps-

Mike Ruane

WinWin Solutions Inc.

WWW.WinWinSol.Com

Thanks Mike

The Clear Event worked. We are new to OpenInsight. We knew it had to be something simple, it normally is.

However we still having a problem with the Return

The only thing we have in Got_Focus and Lost_Focus is the Declare Function for the Set_Property, the got is setting the color to yellow, the lost is setting the color to 0. The system is automatically doing everything else. We tried changing the Return 0 (that the got and lost automatically gave us) to Return 1 and still have the same problem with the read/display.

Can you please give us more information?

Thanks

Andy et al

Dave - Thanks for the info on clear event. It worked.

We are new to OpenInsight and are trying various things.

However we still having a problem with the Return

The only thing we have in Got_Focus and Lost_Focus is the Declare Function for the Set_Property, the got is setting the color to yellow, the lost is setting the color to 0. The system is automatically doing everything else. We tried changing the Return 0 (that the got and lost automatically gave us) to Return 1 and still have the same problem with the read/display.

Can you please give us more information?

Andy, if you haven't done so already, I suggest you take a look at the "Oh teach me great Fhopha!" topic archived in this forum (use Search with keyword Fhopha). This covers the documented and undocumented properties of edit boxes and their coats of many colors :)

My deepest gratitude to the guys who contributed to Fhopha. I learned a lot there.

Mark

Mark,

But wasn't the Fhopha thread about edit tables?

- Oystein -

PS. Who on earth is Fhopha?

Andy,

With user event return there are three cases:

A. You have an event handler with "return 1". The "1" will cause the execution to continue with the next handler in the event chain.

B. You have an event handler with "return 0". The "0" causes the execution to finish, and not continue with the next handler in the chain.

C. You haven't made any event handler. Like in case A execution will continue with the next handler in the event chain. What's confusing is if you open the handler with the Event Editor, you will still see a "return 0" statement. So it looks like case B - like it's a handler that does nothing, and makes execution finish. But don't be fooled! This virginal "return 0" handler really is more like a "return 1"!

- Oystein -

]]Mark,

But wasn't the Fhopha thread about edit tables?

- Oystein -«

Ok, Ok. It was late at night, the bottle was almost empty, and I was lost in thought (or was I thoughtless?) :)

It is intriguing, though. This is the first time I've seen discussion involving the use of edit boxes to create record keys.

Mark

Mark,

Yes, and half a key even. Perhaps it's a new technique with storing data in the key and vice versa.

But I'm ranting. Even without the aid of bottled stuff. Must be that I'm three hours past lunch time.

And note that I wrote the word "even" an even number of times. Odd. Definitely time for lunch.

- Oystein -

View this thread on the forum...