Grid Error not showing

[ChristJC]

Hello All

Steve Wood et al assisted me with getting this code working, but for whatever reason, the error codes are no longer showing as they once did. The code works ie duplicates are prevented from being inserted via a SQL statement, but in both live preview and published mode, the error doesnt show

Does anyone have any ideas?

FUNCTION CanInsertRecord as v (DataSubmitted as P, Args as p, PageVariables as p, Result as p)
	WITH PageVariables
		dim t as P
		dim qdx as P
		t = table.open("persons")
		query.filter = "Surname = '" + alltrim(DataSubmitted.Surname) + "' .and. FirstName = '" + alltrim(DataSubmitted.FirstName) + "'"
		query.order = ""
		qdx = t.query_create()
		save_to_file(query.filter,"c:\test.txt")
		IF qdx.records_get() > 0
		result.cancel = .t.
		result.errorHTML = "This person already exists within CDIS"	
		END IF
		t.close()
	END WITH
END FUNCTION

Thanks

Jason

[ChristJC]

Re: Grid Error not showing

Hello All

Have answered my own question, all web components I have built recently did not have an echo or update section. As soon as I inserted these two sections, the error messages appeared.

I think this has only been occurring since I downloaded the latest V9 build back in Sept

Jason

[Anis]

Re: Grid Error not showing

Chris;

What do you mean by echo and update section ?
where do you insert them.
The grid is updateable I assume.

I'm having the same issue and I can't get the error to show?

[ChristJC]

Re: Grid Error not showing

Its Jason actually :)

Re the components, I found that before I updated to the latest version of Alpha, when I inserted a component into an A5 page, there was the grid, search etc AND an echo and update section. After I updated A5, when I inserted components into a5 pages, the echo and update didnt show, and subsequently nor did my error messages. As soon as you insert them manually, the error message appears

Hope this helps

[Anis]

Re: Grid Error not showing

do you know which patch it works with because I went back from 64 to 61 and it still didn't insert them.

[ChristJC]

Re: Grid Error not showing

no idea. I was multiple patches behind because I hadnt updated for so long. If it were me, just stick with the latest version and manually add the sections in. Its only a few lines of code

[Anis]

Re: Grid Error not showing

That's the problem, I did add it, but no luck.
It validated all validation rules but not the error that is setup in the CanInsertRecords event.

I tested the same page in ver 8 it works fine.

[ChristJC]

Re: Grid Error not showing

gotcha, I understand. Silly question, but the data you entered definitely should have triggered the code?

[Anis]

Re: Grid Error not showing

This is what I ended up doing.
I created the page on ver 8, copied the source to ver 9, published it and it works.