开发者

SQL error using sqlanywhere php API sasql_query()

开发者 https://www.devze.com 2023-04-11 00:09 出处:网络
I\'m having problem executing a specific query using php API from sqlanywhere 12. It only happens with SET OPTION query.

I'm having problem executing a specific query using php API from sqlanywhere 12.

It only happens with SET OPTION query.

<?php
    // setup omitted for clarity here
    $result = sasql_query( $conn, "SET OPTION PUBLIC.AjusteFuso = '0'" );
    // clean up omitted for clarity here
?>

I receive the following exception:开发者_运维问答

 AjusteFuso' is an unknown option SET OPTION PUBLIC.AjusteFuso = '0'

But this is not true, it is known option in my database!

1 - others select/update/delete/insert works normal as expected.

2 - SET OPTION works ok if i test it using sybase central.

This same query was working normal using sql anywhere 9 with sybase_query() old API.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号