UniUpdateSQL not saving to server

[trw_mavrik]

Hi Guys

I was wondering if someone could help me as I've managed to pull data from a Firebird 2.5 server using Unidac but when I amend the data and post, I don't get any error messages and find that the updates don't save?

Here is my (very basic) code:

UniUpdateSQL1->ModifySQL->Add("UPDATE CLIENT SET NHS_NO = :NHS_NO, TITLE = :TITLE,FORENAMES = :FORENAMES, SURNAME = :SURNAME, KNOWN_AS = :KNOWN_AS, ADDRESS_1 = :ADDRESS_1, ADDRESS_2 = :ADDRESS_2, TOWN = :TOWN, COUNTY = :COUNTY, POSTCODE = OSTCODE, REGION = :REGION, TELEPHONE = :TELEPHONE, WORK_TEL = :WORK_TEL, MOBILE = :MOBILE, EMAIL = :EMAIL, DOB = OB, SEX = :SEX, WEIGHT = :WEIGHT, GP_NAME = :GP_NAME, GP_ADDRESS1 = :GP_ADDRESS1, GP_ADDRESS2 = :GP_ADDRESS2, GP_ADDRESS3 = :GP_ADDRESS3, GP_ADDRESS4 = :GP_ADDRESS4, GP_POSTCODE = :GP_POSTCODE, GP_TEL = :GP_TEL, REFFERED_BY = :REFFERED_BY, NEXT_APPT = :NEXT_APPT, ITINERARY = :ITINERARY, DAY1 = AY1, where IDNO = :IDNO; commit;") ;

UniUpdateSQL1->ExecSQL(ukModify) ;

Any help would be appreciated.

Kind regards

T

[ViktorV]

In order to get a detailed answer, please compose a small sample demonstrating the described behavior and send it using the contact form https://www.devart.com/company/contactform.html including scripts for creating database objects. Also please specify the Firebird version you are using.