We have MySQL 5.1 running in production (on OS X) and development (on Windows 7). The VFP app picks up record updates from a 3rd party software and adds/updates records in the MySQL table. My code has been working flawlessly in production for 2 months however when I run the same code in development the add function works but the update fails (we actually got our cart before the horse and have only recently decided it prudent to set up a development environment-go figure). When I step thru the program and copy the SQL command to a text file I can execute the query directly on the server (via SQLyog) and it works.

This is the INSERT command which works in production and development.
fld_list = "SET "
fld_list = fld_list + "`Fileno`='" + m.FileNo +"', "
fld_list = fld_list + "`BillSCM`='" + ALLT(STR(m.Comm_Split,9,2)) +"' "
fld_list = fld_list + ";"
sqlcmd = "INSERT ignore into `database`.`table` "+fld_list
sqlok = SQLEXEC(MyDBconx,sqlcmd,'MyCursor',qResult)

The UPDATE command works in production but not in development.

fld_list = "SET "
fld_list = fld_list + "`ClaimStat`='" + m.Claimstat +"', "
fld_list = fld_list + "`ClaimStatField`='"+ m.ClaimStatFld +"', "
fld_list = fld_list + "`BillSCM`='" + ALLTRIM(STR(m.Comm_Split,9,2)) +"' "
fld_list = fld_list + " where TRIM(fileno) = '" + ALLTRIM(m.fileno)+"'"
* fld_list = fld_list + ";"
sqlcmd = "UPDATE `database`.`table` "+fld_list
sqlok = SQLEXEC(MyDBconx,sqlcmd,'MyCursor',qResult)

NOTE: I've tried adding/removing the semi-colon on the UPDATE with no difference in result.

Are there any obvious places to look into why this is failing (other than firewalls and permissions which have already been scoured)?

Kinda new to MySQL server. Are there logs I can review to determine exactly why it is failing?

Thanks in advance~