Hi,

I don't think that the rev_sql procedure has been fully fixed for 3.71.

In 3.5 (the version that it used to work in) rev_sql normalised multivalued fields.

I have tried it with the lastest download and rev_sql is storing the delimiters for multivalued fields and not normalising.

Am I doing anything wrong ?

Has the calling list changed ?

Regards

            Brian Braybrooke

Hi Brian,

Make sure the fields are set as multi-value in the dictionary.

REV_SQL itself has not changed. The regression was in the OPEN statement ($RTP9).

Cameron Purdy

Revelation Software

Cam …

I misspoke. The problem is not in SQL, it is in QBF. When you initialize the query, you can enter criteria in the non-protected and symbolic fields, but not in protected DBTABLE entities.

Thanks

Don Miller

C3 Inc.

Thanks Cam,

I have made sure the fields are mutli valued and tried some more tests. 3.5 and 3.71 are producing the same results.

When I used the old version of 3.5 from a backup, the table that I was using had a lot less data ie less than 1,000 records. When I tried it with the new version, the table had more data - over 4,000 records.

The problem I'm getting with the REV_SQL seems to be with the size of the table .

With 1000 ish records the data is normalised.

With 4,000 + records the the data dosn't seem to be normalising.

Any suggestions ?

Regards Brian

Brian,

Very odd. Do you check for any error (Get_Status)?

I'd like to see if we can reproduce the problem here. Is there any way we could get the data that you are using?

Cameron Purdy

Revelation Software

Problem Solved !

I have been using my poor old C drive to carry out the tests. It turns out there was very little space on the drive. I repeated the tests off of the server and it works fine !

I didn't get any errors though with Get_Status.

Sorry for any confusion.

Brian

View this thread on the Works forum...