{{tag>category:"None Specified" author:"Brian Braybrooke" author:"Cameron Purdy" author:"Don Miller"}}

[[https://www.revelation.com/the-works|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: ===
 
 
<QUOTE>
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
</QUOTE>
----

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

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

</QUOTE>

----

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

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

</QUOTE>

----

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

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

</QUOTE>

----

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

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

</QUOTE>

----

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

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

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=57A4242C14E4C75E85256732003D4A2B|View this thread on the Works forum...]]