I'm wondering if anyone has a good, helpful location to bookmark for reference when various errors are encountered with FM.

Currently I am attempting to add a record to an FM table and am getting the following:

[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL

I am a very novice user of FM, so excuse me if this is an easy one for you gurus. The above record creation was in an attempt to insert values for only a portion of the columns, not all. My initial thought was that there was a "required" column that I was not including on the add. However this does not seem to be the case.

Here is my existing code:

...

'' Filemaker statement setup

Set cnnGetRowsFMPE = Server.CreateObject("ADODB.Connection")

cnnGetRowsFMPE.Open strConStrFMPE

Set objRSFMPE = server.createobject("ADODB.RecordSet")

objRSFMPE.Open "Pending_Escrow_Files", cnnGetRowsFMPE, adOpenKeyset, adLockPessimistic, adCmdTable

objRSFMPE.addnew

objRSFMPE("Property Name") = request("ProjectName")

objRSFMPE("Property Location") = request("ProjectAddress")

objRSFMPE("Lender Name") = request("Bank")

objRSFMPE.update -- THIS IS WHERE THE ERROR OCCURS --

theFMPEID = objRSFMPE("IDNum")

objRSFMPE.close

...

Thanks much,

-Jay

I have developed a code_error database file. It's attached.

code_error.zip

Thanks transpower, this will be great for future reference.