Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

VBScript macro in the Function Definition

7 views
Skip to first unread message

Daniel

unread,
Dec 10, 2004, 2:43:48 PM12/10/04
to
Hi all,
I am using PD 10 to model a Postgresql 7.4 database.
I would like to know if it is possible to have the following
vb script in a Function Definition.

Create or replace function
.vbscript (%FUNC%)
vs_code = ScriptInputArray(0)
if (instr(vs_code, "_") > 0) then
ScriptResult = vs_code & "suffix"
else
ScriptResult = vs_code
end if
.endvbscript
... my code
End;

My attempts failed. The 2 lines with ".vbscript" and
".endvbscript" are gone but the rest of the vbs code
remains.

If it is possible, please tell me what I am doing wrong.
Thanks in advance,
Daniel

0 new messages