Re: Vexing, un clear SQL error

Tim, I am also thinking about setting a semaphore at the start and end - but that seems like the wrong path because I can't believe the SQL server can only accomodate one operation from the entire database at a time. On Mon, Feb 20, 2017 at 12:57 PM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com>

Re: Vexing, un clear SQL error

Hi Tim, Yeah, I was wondering about that error code too. It hadn't occurred to me the problem could be the transit lag between the client the server but that would account for what I'm seeing. Interesting idea about the wrapper. Maybe I'll make a specific error handling method for these sorts of

Vexing, un clear SQL error

**Apologies for double posting - just noticed I neglected to add a subject. I need some help with this from some of you SQL gurus. Here's a simple look up function (Partner_get_name) that uses SQL: If ($partner_id>0) If ([PARTNERS]ID#$partner_id) Begin SQL SELECT Name_dba, Name_display,