-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I get error "missing ".." at end of SQL expression"
...
> Can someone help please
The problems appear to be in your declare block:
> curTrackList char(15) ALIAS for $1;
> sliceFile varchar ALIAS for $2;
> lmfpLimit integer ALIAS for $3
Y
Puneet Paul <[EMAIL PROTECTED]> writes:
> DECLARE
> curTrackList char(15) ALIAS for $1;
> sliceFile varchar ALIAS for $2;
> lmfpLimit integer ALIAS for $3
> mTrackDet RECORD;
If that's an accurate copy of your function, then the problem is likely
the lack of a semicolon on
I should play with your code, but I'm lazy.
1) lmfpLimit integer ALIAS for $3
is missing the trailing ";"
lmfpLimit integer ALIAS for $3;
2) VARCHAR variables need a length
curId varchar;
should be
curId varchar(100);
3) I have not seen this style of declaration, where the argum
