🚀 go-pugleaf

HELP!!

DDE Question:

I have a VFP DDE server set up using DDE to process SQL queries.
All is OK, except for when I need to send a UDF call as part of
a query.

When sending the DDE request, I get errors if I try to send
characters like quotes("), single quote ('), brackets ([]),
or even a caret (^) to delimit strings inside an item.

I've tried sending a backslash escape character before the
offending character but to no avail.

For example, to send a single quote, I've tried all of these, with
the same error message:

  String        Error
--------        --------------------------------
   '            DMLERR_INVALIDPARAMETER
   \'           DMLERR_INVALIDPARAMETER
   \\'          DMLERR_INVALIDPARAMETER
   ''           DMLERR_INVALIDPARAMETER




Here is an example of the code creating this problem:

C++ side:
   strcpy(cpQuery, "SELECT UDF('ACCESS') FROM CDR.DBF") ;
   hRetData = DdeClientTransaction((unsigned char*)cpQuery,
       strlen(cpQuery) + 1,
       hConv,
       hszTopic2,
       CF_TEXT,
       XTYP_REQUEST,
       TIMEOUT_ASYNC,
       NULL);



Any thoughts??