Normal Topic XLookupAll not working on "Form Change" (Read 342 times)
carsten
Junior Member
**
Offline


Carpe Diem

Posts: 74
Location: Germany
Joined: Aug 24th, 2005
XLookupAll not working on "Form Change"
Jul 18th, 2006 at 5:58pm
Print Post Print Post  
Hi There,

I am using XLookupAll to retrieve several values from recors with the same key. I would like to invoke it on Form Change to update some fields in the form. The form itself is one of the records with the search key.

The following code does work fine on form entry but does not seem to work on any other event:

// Calculate/Update number of rooms

var tZimmer as String

If Gruppe
{
     tZimmer = @XLookupAll(@FN,Buchungsnummer,"Reisebuchung!Buchungsnummer","Zimmer")

     EZ = @CompareStringArray(tZimmer, "EZ")
     DZ = @CompareStringArray(tZimmer, "1/2 DZ") / 2
     DreierZ = @CompareStringArray(tZimmer, "3er") / 3
     ViererZ = @CompareStringArray(tZimmer, "4er") / 4
}

EZ, DZ, DreierZ, and ViererZ are placed on a tab

Any ideas?
Is XLookupAll maybe blocked as the record is blocked when viewed?

Thanks
Carsten
  

Carsten&&The Houseman&&"Smiling improves your face value"&&"A Clean House is a Sign of a Wasted Life"&&"Rather Big and Hard then Micro and Soft"
Back to top
 
IP Logged
 
carsten
Junior Member
**
Offline


Carpe Diem

Posts: 74
Location: Germany
Joined: Aug 24th, 2005
Re: XLookupAll not working on "Form Change"
Reply #1 - Jul 18th, 2006 at 7:33pm
Print Post Print Post  
Wellllllllll,

sometimes it is the heat I suppose and those long hours!

I solved the problem:

Sesame does exactly what it is supposed to do: it returns the values in the database. As the form is still open, all I needed to do was save it using FormCommit() and it worked!

-Carsten
  

Carsten&&The Houseman&&"Smiling improves your face value"&&"A Clean House is a Sign of a Wasted Life"&&"Rather Big and Hard then Micro and Soft"
Back to top
 
IP Logged