I'm using ListX to insert data into a table - but sometimes the user might try to duplicate the primary key. In this case it just fails and the user doesn't know. How can I let the user know that their insert failed?

Hi,

Sorry for the late response.

You can do it in the following way: Give a name for the insert query that you executed. For example, INSERTQRY. You can check whether insert succeeded or failed using [INSERTQRY.isSuccessful,Action] - returns true or false. The actual error is returned in the [INSERTQRY.Error,A]

Under Actions:
INSERTQRY: INSERT INTO MyTable VALUES(@Col1)

So, you can display the error using [INSERTQRY.Error,A]

You can also refer to the ListX documentation (page no. 52)

Thanks,
Sindura
R2integrated