I have forms with index lookup in them. the lookup appears to work correctly but nothing is saved to the control.[pre]Return Value

Type blank

Target @self

Message TEXT

Params '@RETVAL'

Skip if null False

[/pre]

This seems to be the section that is not working … thoughts

David Tod Sigafoos

SigsSolutions

Hi Dave,

IXLOOKUP is an odd beast - what happens if you remove the "return value" section altogether?

P.S. Happy Traitors day Carl Pates

I will try that later today after I finish celebrating

David Tod Sigafoos

SigsSolutions

i removed all the bits from RETURN and it didn't really like that. it accepted and saved but when run it crashed.

I also turned off/on the quick event to start new and that didn't work as I didn't know the separators for the fields and as noted in issue tracker the whole selection process is wrong for indexes.

David Tod Sigafoos

SigsSolutions

Hi Dave

What do you mean by "crashed" - did you hit the debugger or was it something worse like a GPF?

Thanks

Carl Pates

Sorry I should have been more explicit .. still high from celebrating freedom from the queen

It went to debugger. I didn't not the error .. sorry

David Tod Sigafoos

SigsSolutions

Well that's not much use is it? Guess I'll have to figure it out all on my own then …

Carl Pates

I'll retest this afternoon and enter the error number

David Tod Sigafoos

SigsSolutions

I am trying indexing on new forms and it appears to be working much better than converted form. There is still the issue of building the index information … but I wouldn't spend much time on this untill I can give you a scenario that is reproducible

David Tod Sigafoos

SigsSolutions

What should the params string look like …I can't get any indexes to work but I am guessing at the params string since the indexbuilder windows are wrong

David Tod Sigafoos

SigsSolutions

Hi Dave,

I'm sorting out a parameters dialog for the IndexLookup event, but in the mean time the arguments are:[pre] IndexedTable : the table containing btree index(es)

 SearchColumns :  the indexed columns to search, delimited by @FM

 DisplayColumns:  the columns to display in the resultant popup, delimited by @FM

 SelMode       :  the selection mode, @FM delimited:

    <1>     :  "MULTI" or "SINGLE"  (if null, then single)

    <2>     :  control to return popup result (if null, then browse mode)

    <3>     :  control property to set (generally 'TEXT') [/pre]

If you were to put them in the QuickEvent params yourself it would look something like this:[pre]"MYTABLENAME",["IDXCOL1","IDXCOL2","IDXCOL3"],["DISPCOL1","DISPOL2","DISPCOL3"], "MULTI"[/pre]

As you're using the "[]" to denote an @fm'd list. You should be able to leave the SelMode <2> and <3> blank because the event should be able to work it out for itself.

Carl Pates

Thanks Carl. I'll be able to use that on remaining windows. Currently just writing the code in script as it lets me force the read at the same time since that doesn't seem to happen

David Tod Sigafoos

SigsSolutions

View this thread on the Works forum...