Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SELECT argument not defined
1,358 views
Skip to first unread message
Kenneth McCall
May 12, 2000, 3:00:00 AM5/12/00
to
In a simple datawindow that contains 4 elements (primary key) from a
large table
ie. case,date,id,type. When I include a where clause I get the error
message
"An argument used in the SELECT is not defined. When I view the syntax
everything
is correct:
SELECT "TABLE"."CASE",
"TABLE"."DATE",
"TABLE"."ID",
"TABLE"."TYPE"
FROM "TABLE"
WHERE "TABLE"."ID" = :ID
large table
ie. case,date,id,type. When I include a where clause I get the error
message
"An argument used in the SELECT is not defined. When I view the syntax
everything
is correct:
SELECT "TABLE"."CASE",
"TABLE"."DATE",
"TABLE"."ID",
"TABLE"."TYPE"
FROM "TABLE"
WHERE "TABLE"."ID" = :ID
Any help would be appreciated
TIA
Ken
John J. Brutin
May 12, 2000, 3:00:00 AM5/12/00
to
Have you defined under the menu Design> Retrieval Arguments the 'ID' at the
end of your where clause? You need to define it before placing it in the
clause.
end of your where clause? You need to define it before placing it in the
clause.
Kenneth McCall <she...@bellatlantic.net> wrote in message
news:391BE10D...@bellatlantic.net...
Kenneth McCall
May 12, 2000, 3:00:00 AM5/12/00
to
"John J. Brutin" wrote:
Thanks for the reply, will give it a shot.
0 new messages