• advertisement_alt
  • advertisement_alt
  • advertisement_alt
ricardo80

erro ao executar search_path

2 posts in this topic

Boa tarde, eu to tentando só dar um set search path no banco(Postgres), e ele me retorna essa mensagem...não sei se estou fazendo do modo correto

Error in the SQL code of <_SOURCE_xxx_3> query. Unable to initialize the query.

Unexpected word: search_path

Error detected row 1, column 5:

SET >>>>search_path<<<< TO emp01,public

e o código que eu to usando é isso

wComando is string = "SET search_path TO %1,public"

wComando = StringBuild(wComando,PU_Schema)

xxx is Data Source



IF HExecuteSQLQuery(xxx, wComando) THEN

    HFreeQuery(xxx)

    RESULT True

ELSE

    Info(ErrorInfo())

    HFreeQuery(xxx)

    RESULT False

END

como posso fazer isso?

 

Share this post


Link to post
Share on other sites

Olá, para execução desse tipo de comando utilize a seguinte sintaxe

HExecuteSQLQuery(xxx, suaconexao, hQueryWithoutCorrection, wComando)
2 people like this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now