Skip to Content
Author's profile photo sujitha chandrasekar

Hi,Feature not supported: table variable cannot be compared: FIDCOUNT

I have a procedure for calculating a new column in tables.I want to use  loop for number of columns repeating with same values.

So I just tried with one variable to store  count of columns and then i used that table type count variable as a conditional variable in while loop.Now i got the error

Feature not supported: table variable cannot be compared.

Can anyone help me to resolve the error.

FIDCOUNT=select count(distinct FAMILY_ID) from family;

WHILE :outloop_count<:FIDCOUNT DO




Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.