| Subject | Re: [ib-support] variable not updating in SP |
|---|---|
| Author | Peter Faulks |
| Post date | 2002-05-15T22:49:46Z |
On Wed, 15 May 2002 22:03:53 -0000 "csswa" <csswa@...> wrote:
Regards
> /* GET PRIMARY KEY FIELD NAME */Shouldn't it be SELECT... INTO... FROM... ?
> SELECT RDB$FIELD_NAME
> FROM RDB$INDEX_SEGMENTS
> WHERE RDB$INDEX_NAME =
> (
> SELECT RDB$INDEX_NAME
> FROM RDB$INDICES
> WHERE (RDB$INDEX_NAME STARTING WITH 'RDB$PRIMARY')
> AND (RDB$RELATION_NAME = :VAR_TABLENAME)
> )
> INTO :VAR_PKNAME; <----------*** VARIABLE NOT REFRESHING
Regards