Not changing record values - NT544

[terryd]

Windows64 Ultimate Clarion 8.8778 Nettal5.44
I have an existing (win32) application doing CRUD operations on a MSSQL backend.
I have created a NTweb application to duplicate, and eventually replace the existing application.
I have created a browse with a form attached and change enabled.
When I select a record and change a value and then click save the record is not changed. There is no error message, the form simply returns to the browse. Returning to the form just shows the same information.
The primary ID on the table is a single autonumber record which is unique.
Any ideas why this would happen and  any advice on what to do to try and track down this error would be greatly appreciated.

[kevin plummer]

If you use csmessage check to see if any file driver error message is logged

[Bruce]

try forcing the WebServer procedure to regenerate by touching a setting.

cheers
Bruce

[terryd]

Yes I am using csmessage and I have no records in my csmessage table.
I have forced a regeneration, still no luck.
I have created a record in the database using a form ( a different one but none the less a form)

[terryd]

Further update
On the form I mention in my previous post I added a change. I can add a record, but using the same procedure to change a record leaves the original value the same

[Bruce]

not a lot to work with Terry.
I guess an example might help - or follow the code in the form (using the p_stage as a starting point.)

cheers
Bruce

[terryd]

Hi Bruce
Yes I realise that unfortunately the SQL backend makes it difficult to send an complete example unless just the dct and app is enough? The form has no embeds and is all simple fill in the fields operation.
I'll try and step through the code. Any advice as to what I should be looking out for?

[Rob de Jager]

Terry, this a long shot on my part, but two things that I can think of.  One, make sure that you did not populate the record's unique id on the form and two, that the table has a unique id and primary key.

Cheers

Rob

[Bruce]

Terry,

you could try modding one of the example apps to show what you are doing, and hence hopefully recreate the bug.

cheers
Bruce

[kevin plummer]

Hi Terry,

I converted the accounts example some time ago to MSSQL. I have attached a zip. Let me know if any files are missing. Set the SQL DNS via the FM3.ini file

HTH's

Kev

[attachment deleted by admin]

[terryd]

Thanks Kevin
What's really got to me is that with a simple form I can add a record but the same form does not change the record.

[kevin plummer]

I've got 3 apps running SQL, no prob although a different version than yourself. Did you get the example I uploaded working? Would be interested to see if you had the same problem there as it would start to narrow down where the problem may lies.