Please ignore my previous message on this subject - I was being a
plank...
Regards, Dave.
> -----Original Message-----
> From: Dave Page
> Sent: 09 September 2002 10:28
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Problem with braces in CREATE FUNCTION
>
>
> 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.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>
