Re: INTO TEMP clause

Vinay Gidwani writes: |> I figured out what I was doing wrong. |> Apparently it should be |> |> SELECT inventory.store_no, inventory.location, inventory.tag_id |> FROM inventory WHERE |> inventory.location NOT MATCHES "910-*" |> AND inventory.store_no IN |> (SELECT wave_schedule.store FROM wave_schedule |> WHERE wave_schedule.wave = wv_no) |> INTO TEMP invtemptab |> |> THE INTO TEMP clause should be in the end |> |> Vinay Also, you don't seem to have wv_no defined as a column or host variable. If you are using 4gl, and it is a 4gl variable, then the syntax is ok. Otherwise it would be a problem. Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney