The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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
1114610
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...
7.3k35107
accept rate: 31%

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:

×13
×4

question asked: 03 Dec '15, 16:36

question was seen: 573 times

last updated: 06 Dec '15, 09:49