Hi,
The new CREATE FUNCTION syntax looks like: CREATE FUNCTION
public.autoinc1() RETURNS trigger AS 'autoinc' { LANGUAGE 'c' VOLATILE
};
How do I execute such a statement through ADO/ODBC without the ODBC
driver giving the following error (I've tried \{ and {{)?:
STATEMENT ERROR: func=copy_statement_with_parameters, desc='', errnum=1,
errmsg='ODBC escape convert error'
------------------------------------------------------------
hdbc=130904072, stmt=129337000, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=4, statement='CREATE FUNCTION
public.autoinc1() RETURNS trigger AS 'autoinc' { LANGUAGE 'c' VOLATILE
};'
stmt_with_params='(NULL)'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
cursor_name='SQL_CUR07B586A8'
----------------QResult Info
-------------------------------
CONN ERROR: func=copy_statement_with_parameters, desc='', errnum=0,
errmsg='(NULL)'
------------------------------------------------------------
henv=129312544, conn=130904072, status=1, num_stmts=16
sock=129367224, stmts=129367832, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1124, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=130763568, buffer_out=130780304
buffer_filled_in=1, buffer_filled_out=0, buffer_read_in=1
Regards, Dave.
