NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: terryd on February 27, 2012, 01:15:52 AM

Title: Not changing record values - NT544
Post by: terryd on February 27, 2012, 01:15:52 AM

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.

Title: Re: Not changing record values - NT544
Post by: kevin plummer on February 27, 2012, 02:00:42 AM

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

Title: Re: Not changing record values - NT544
Post by: Bruce on February 27, 2012, 02:24:04 AM

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

cheers
Bruce

Title: Re: Not changing record values - NT544
Post by: terryd on February 27, 2012, 04:53:23 AM

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)

Title: Re: Not changing record values - NT544
Post by: terryd on February 27, 2012, 04:59:02 AM

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

Title: Re: Not changing record values - NT544
Post by: Bruce on February 27, 2012, 05:32:53 AM

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

Title: Re: Not changing record values - NT544
Post by: terryd on February 27, 2012, 06:02:34 AM

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?

Title: Re: Not changing record values - NT544
Post by: Rob de Jager on February 27, 2012, 10:40:04 AM

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

Title: Re: Not changing record values - NT544
Post by: Bruce on February 27, 2012, 09:23:37 PM

Terry,

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

cheers
Bruce

Title: Re: Not changing record values - NT544
Post by: kevin plummer on February 27, 2012, 11:20:12 PM

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]

Title: Re: Not changing record values - NT544
Post by: terryd on February 28, 2012, 11:34:03 PM

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.

Title: Re: Not changing record values - NT544
Post by: kevin plummer on February 29, 2012, 02:21:12 AM

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.