Skip to main content
rameshbabub7775
rameshbabub7775
December 27, 2023
Question

Unable to save data to Database table

  • December 27, 2023
  • 7 replies
  • 0 views

hii all,

in a editable grid i am fetching backend data by selecting a product name ,if i have selected product name then in next field the respected product description should come , after filling all the fields in editable grid i am going to submit and updating a data base , here every field  of editable grid is storing except the product description, respected product description is showing in the grid layout but its not storing in to data base ,but if i edit that product desciption and  submitting then its storing in the database . please help me 

my requirement is to fetch product description by selecting a product name in grid and storing it in to the database

thanks and regards,

b ramesh babu

7 replies

niranjanreddym9323
niranjanreddym9323
December 27, 2023

Hi [mention:7f203c45eb0a4e0b8dca3f5b85b6db47:e9ed411860ed4f2ba0265705b8793d05] ,

are you using process model or a!writeToDataStoreEntity() function in UI to write to database?

1. Verify whether your data(description) is saving to variables.

2. While submitting verify the appropriate variable is passed to the valueToStore parameter.

3. Investigate pv variables if you are using PM to write data.

4. Make sure you are not saving any null values while submitting.

rameshbabub7775
rameshbabub7775Author
December 27, 2023

hii kiran, i am using process model , here what happening is in interface , i am fetching product description from backend data table , if i have selected a product name in editable grid then the respected product description is coming in the product description field , but it is not storing in the local variable , when ever i am just editing that description then its storing and as well as saving into the main data table i dont know whats going there

niranjanreddym9323
niranjanreddym9323
December 29, 2023

Hi [mention:7f203c45eb0a4e0b8dca3f5b85b6db47:e9ed411860ed4f2ba0265705b8793d05] ,

in that case save the product description to local var in the saveInto of product name field. In the saveInto parameter of productName field fetch the productDescription and save to repective local variables.

    sangeethab0005
    sangeethab0005
    December 27, 2023

    Hi [mention:7f203c45eb0a4e0b8dca3f5b85b6db47:e9ed411860ed4f2ba0265705b8793d05] ,

    Kindly check whether you are passing correct value in valueTostore parameter of writeToDataStoreEntity. 

    When you are selecting a row, you will be storing the selected row into a variable. Check that variable once. 

    rameshbabub7775
    rameshbabub7775Author
    December 27, 2023

    hii sangeetha,

    i am passing correct values only, i am using process model , here what happening is in interface , i am fetching product description from backend data table , if i have selected a product name in editable grid then the respected product description is coming in the product description field , but it is not storing in the local variable , when ever i am just editing that description then its storing and as well as saving into the main data table i dont know whats going there

    sangeethab0005
    sangeethab0005
    December 27, 2023

    [mention:7f203c45eb0a4e0b8dca3f5b85b6db47:e9ed411860ed4f2ba0265705b8793d05]  If possible can you share snip of the code?

    There is some issue in the input of the grid or in the selection

    Terms & ConditionsAccessibility statement