The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hi,

I am using Version 16.0.0.2043 of SAP SQL Anywhere - Ultralite for windows mobile platform (.NET framework).

When I execute:

SELECT RAND();

I get an error that the function is unknown. All the documentation indicates that this is supported in ultralite.

Is there a reason why this function would not work?

Thank you for any help! Paula

asked 03 Dec '15, 16:36

Paula's gravatar image

Paula
1113610
accept rate: 0%

Hi Paula!

I'm curious what you would like to use this for, and whether you think we should support it.

(04 Dec '15, 16:50) Tim McClements
Comment Text Removed

The new feature announced in Version 12 was for the UltraLiteJ implementation (ie. a Java Ultralite runtime)

For non-Java UltraLite platforms (ie. Windows Mobile Classic in your case) there appears not to have ever been a RAND() function. As such the documented expection is backwards and I'll get that looked into.

permanent link

answered 04 Dec '15, 13:52

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
6.2k2890
accept rate: 30%

Thanks for the answer!

(04 Dec '15, 14:07) Paula
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×12
×4

question asked: 03 Dec '15, 16:36

question was seen: 497 times

last updated: 06 Dec '15, 09:49