Forum — Unclosed quotation mark after the character string ''.

Re: Unclosed quotation mark after the character string ''.

null@example.com (charliebarnes) — Fri, 23 Feb 2024 10:09:40 +0000

Thanks Ben - I had a good look through all the data and couldn't see anything that might make Recorder fall over. I think you might be on the right lines though.

I've just had the same error on my laptop (but same backend) - interestingly this time its given me a random string of text instead of a blank. Adds weight I think to the "somethings not quite right" thinking ie somethings causing the generated SQL to be cut short.

Re: Unclosed quotation mark after the character string ''.

null@example.com (BDeed) — Wed, 17 Jan 2024 13:40:47 +0000

Hi Charlie, in all likelihood completely un-related but just on the off-chance...

I recently started running into this exact error on a series of bulk imports (Unclosed quotation mark after the character string ''.) unlike you i couldn't for the life of me figure out where it was coming from. Ultimately, i noticed that the csv was saved as "CSV UTF-8". I changed to standard "CSV" and i no longer received the error, the records went in fine with no apparent change to the data.

I assume there was something in there that i just couldn't see which got stripped out in the save.

Unclosed quotation mark after the character string ''.

null@example.com (charliebarnes) — Wed, 13 Dec 2023 12:57:17 +0000

I'm getting this error almost constantly now when adding individuals and organisations (simple ones, just a first name and last name). I've had a look at the query being put the server:

SELECT Organisation FROM Name WHERE Name_Key='

and have potentially narrowed it down to this line in the source in the procedure TfrmIndOrg.DisplayNames(const iNameList: TKeyList);:

SQL_IS_ORG = 'SELECT Organisation FROM Name WHERE Name_Key = ''%s''';

but this is where my expertise runs out. It doesn't seem to cause any problems. Hitting Continue and it's fine, but it's getting annoying :-)