Criar Procedure ou Functions no Executor de Sql
Citação de Kindrazki em 27 de maio de 2016, 14:19Criar Procedure ou Function no Executor de Sql
Exemplo:
[code]
psql:
CREATE PROCEDURE STR_POS
(PROCURAR Varchar(8192), ONDE Varchar(32765), OCORRENCIA Char(1))
RETURNS (RESULT Integer) AS
Declare Variable i Integer;
Declare Variable sTmp Varchar(32765);
BEGIN
i = 1;
while(i <= char_length(:ONDE))do
begin
sTmp = substring(:ONDE from i for char_length(:PROCURAR));
if(:sTmp = : PROCURAR)then
begin
RESULT = i;
if(:OCORRENCIA = 'P')then
begin
SUSPEND;
Exit;
end
end
i = i + 1;
end
SUSPEND;
END;
[/code]
Criar Procedure ou Function no Executor de Sql
Exemplo:
[code]
psql:
CREATE PROCEDURE STR_POS
(PROCURAR Varchar(8192), ONDE Varchar(32765), OCORRENCIA Char(1))
RETURNS (RESULT Integer) AS
Declare Variable i Integer;
Declare Variable sTmp Varchar(32765);
BEGIN
i = 1;
while(i <= char_length(:ONDE))do
begin
sTmp = substring(:ONDE from i for char_length(:PROCURAR));
if(:sTmp = : PROCURAR)then
begin
RESULT = i;
if(:OCORRENCIA = 'P')then
begin
SUSPEND;
Exit;
end
end
i = i + 1;
end
SUSPEND;
END;
[/code]
