Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Posting-Version: version B 2.10.1 6/24/83; site phoenix.UUCP Path: utzoo!watmath!clyde!burl!ulysses!mhuxl!houxm!hogpc!pegasus!phoenix!bogie From: bogie@phoenix.UUCP Newsgroups: att.ingres,net.lang.c Subject: Re: EQUEL/C preprocessor bug Message-ID: <754@phoenix.UUCP> Date: Wed, 30-May-84 08:48:11 EDT Article-I.D.: phoenix.754 Posted: Wed May 30 08:48:11 1984 Date-Received: Fri, 1-Jun-84 08:43:48 EDT References: <651@abnjh.UUCP> Organization: AT&T Information Systems, Lincroft NJ Lines: 19 i believe the solution to your problem is to deactivate variable substition on tr in p.tr [i'm assuming you have declared a c variable called tr - there is where the problem lies] the retrieve statement would then read: ## retrieve (seq=1+max(int1(right(p.#tr,2)))) problem is that equel will do variable substition on database, relation, and field names if a variable has been defined to ingres with that name (## type cvar - type declaration). rona r.j.kopp 201-576-6315 phoenix!bogie [pegasus!phoenix!bogie]