Product:	MicroStation
	Version:	08.11.09.919
	Environment:	N\A
	Area:	Database
	Subarea:	VSQL

Problem

During execution of an SQL select statement from the VSQL Query builder, the following Informational message may occur:

No rows found.
If the table does not have a numeric field, uncheck the Dataset Mode toggle and re-execute.

Solution

Dataset mode and MSLINK column concerns aside, in this case it is prudent to check for access to the desired table by processing the same request via the SQL window. 

To do so the SQL window may be launched via the key-in SQL or launched with the SQL statement pre-embedded by executing the statement from the key-in window, prepended by the pipe symbol:

In cases where the SQL window is able to access table data via the desired SQL statement, it may be that an MS_TMP variable is set to an inaccessible location.

e.g. a directory which has been deleted or to which the user otherwise does not have access. 

Here, we check for the variable definition via the menu item Workspace > Settings > Configuration , and find it set to the value E:\tmp

In this case, the value points to a non-existent directory. 

Resolution thus could be to: 

- create the missing directory

- assign the value to an existing desired directory

- implement the default MicroStation value:  $(_USTN_LocalUserTempPath)

(end)

Original Author:

Nelson Hobdell