, , ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

REV_SQL problem with 3.71 (None Specified)

At 12 MAR 1999 06:09:26AM Brian Braybrooke wrote:

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

At 12 MAR 1999 07:54AM Cameron Purdy wrote:

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

At 12 MAR 1999 09:36AM Don Miller wrote:

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.

At 19 MAR 1999 05:30AM Brian Braybrooke wrote:

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

At 22 MAR 1999 08:25AM Cameron Purdy wrote:

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

At 23 MAR 1999 11:33AM Brian Braybrooke wrote:

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...