SQL 7.0 Random function, does not work like SQL 6.5 Random function 
Author Message
 SQL 7.0 Random function, does not work like SQL 6.5 Random function

We use the rand() function in our application login routine against a 6.5
database, in testing our migration to 7.0, we have found out the random
function in 7.0 does not behave exactly the same as in 6.5, trying the
following query from iSql against both a 6.5 database and a 7.0 database
returns different values - this behaviour "breaks" our application. Does
anyone else have any expierence using the random function?? Could you
provide some insight??




 BEGIN

  SET NOCOUNT ON

  SET NOCOUNT OFF
 END

        Tom Boyce
        Enterprise Project Manager
        National Institutes of Health, Center for Information Technology
        301-594-2666



Sun, 28 Apr 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Reading Random Access Files - need function for QBASIC CVI and CVS Functions

2. Random Functions with PL/SQL

3. Is there any RANDOM functions in PL/SQL?

4. Is a C Printf like function exists with SQL 6.5 or SQL 7.0

5. Equivalent User Defined Function in SQL Server 7.0 or 6.5

6. Generating Random Numbers in SQL Server 6.5 Stored Procedure

7. Random Function

8. Random number function?

9. Autonumber - Random VBA function

10. function for creating random id

11. Random Function

12. VERY strange bug in Random access file function.


 
Powered by phpBB® Forum Software