lookup replaces field lookup (v2023)

crash · Post by **crash** » Sun Feb 25, 2024 4:21 am

Using ASPNM23
I'm using the standard code

public void Lookup_Selecting(DbField fld, ref string filter) {
    if (fld.Name == "MyLookupField") {
        fld.Lookup.UserSelect = "SELECT Field1 AS lf, Field2 AS df, Field3 AS df2, '' AS df3, '' AS df4 FROM Table1"; // Modify SELECT
        fld.Lookup.UserOrderBy = "Field2 ASC"; // Modify ORDER BY
    }
}

I'm trying to display additional fields in the lookup but save only the first two field in the table, but all four fields in my lookup get captured and overrides the field lookup,
How do I save only the first two fields even if lookup displays four fields.

Thanks

MichaelG · Post by **MichaelG** » Sun Feb 25, 2024 7:18 am

Lookup should save the link field (lf) to the database only.

crash · Post by **crash** » Sun Feb 25, 2024 7:55 pm

Thanks I've manged to get it to show only lf... when i save it shows in the view page... but now when I go back to edit page the record is empty and have to enter again.
both fiels are VarChar..

MichaelG · Post by **MichaelG** » Mon Feb 26, 2024 6:27 am

If you mean you want to show different value for lookup in view page, use the Row_Rendered server event.

crash · Post by **crash** » Tue Feb 27, 2024 4:24 am

no I mean that when you save the field the record shows in view... but when you then go back to edit the record disappears from the field, then have to re-enter the records. and then save again

MichaelG · Post by **MichaelG** » Tue Feb 27, 2024 7:59 am

You should simply:

set up Lookup settings properly so that the lookup display correctly in add/edit page
use the Row_Rendered server event to set up the display value in your view/list page

crash · Post by **crash** » Wed Feb 28, 2024 6:31 am

I have checked the fields match the sequence of the fields in the lookup code match the fields in the aspnm field lookup table, i tried removing the fields, tried changing the link field, no matter what I do when i go back to the edit after a successful save, the records do not show and I have to re-enter.
Fields that do not use the code works and shows the old record.

MichaelG · Post by **MichaelG** » Wed Feb 28, 2024 8:20 am

You do not need the Lookup_Selecting codes. You should simply set up your lookup settings for use in the add/edit page and use the Row_Rendered server event to change the display value for the list/view page.

crash · Post by **crash** » Tue Mar 05, 2024 5:59 am

Row rendered seems to only modify css...

MichaelG · Post by **MichaelG** » Tue Mar 05, 2024 7:15 am

You can modify the field view value by:

Field.ViewValue = "<new value>";

crash · Post by **crash** » Tue Mar 05, 2024 8:58 am

Thanks but then there will still be a value.. I just want to hide the last two display fields

MichaelG · Post by **MichaelG** » Wed Mar 06, 2024 6:22 am

You should get the row data and format on your own. For example:

var row = ExecuteRow("SELECT DisplayField1, DisplayField2 FROM LookupTable WHERE LinkField = ...");
Field.ViewValue = Convert.ToString(row["DisplayField1"]) + ", " + Convert.ToString(row["DisplayField2]);

crash · Post by **crash** » Thu Mar 14, 2024 9:41 am

When I go back to edit my record it’s empty.

MichaelG · Post by **MichaelG** » Fri Mar 15, 2024 7:36 am

Show you complete lookup settings and all the server event codes you are using.