GetQMFObjectInfo()


" "

short GetQMFObjectInfo(BSTR OwnerAndName, short Type, short Time, VARIANT* Value)

Description

This function returns information about a QMF object (a form, query or procedure).

Parameters

Name Description
OwnerAndName A string containing the object for which you want to retrieve information, in owner.name format. For example, John.Query2.
Value

A pointer to a VARIANT in which the result is stored.

  • For RSI_TIMESUSED, the result is a short (variant type VT_I2).
  • For RSI_TIMESRUN, the result is a short (variant type VT_I2).
  • For RSI_TIMESCANCELLED, the result is a short (variant type VT_I2).
  • For RSI_LEVEL, the result is a short (variant type VT_I2).
  • For RSI_RESTRICTED, the result is a Boolean (variant type VT_BOOLEAN).
  • For all others, the result is a string (variant type VT_BSTR).

Initialize the VARIANT before calling this function. Visual Basic does this automatically. Visual C++ programmers should call VariantInit().

Note:
Due to a bug in Microsoft Excel 7.0 and Microsoft Access 7.0 (and possibly other 32-bit Microsoft products that use Visual Basic for Applications), string data in Variant variables received from QMF for Windows may not be translated from Unicode (used by OLE) to ANSI (used by VBA). When this occurs, only the first character of the string is displayed. To remedy this problem, set the variable equal to an empty string before you call the QMF for Windows function that uses the variable.
Type

Use the following to specify the type of information to get:

0 (RSI_COMMENT) -- Comment
1 (RSI_LEVEL) -- Level
2 (RSI_TYPE) -- Type
3 (RSI_SUBTYPE) -- Sub type
4 (RSI_RESTRICTED) -- Restricted
5 (RSI_MODEL) -- Model
6 (RSI_TIMESUSED) -- Number of times used
7 (RSI_TIMESRUN) -- Number of times run
8 (RSI_TIMESCANCELED) -- Number of times canceled
9 (RSI_DATE) -- Date first used, last used, or last modified
10 (RSI_TIME) -- Time first used, last used, or last modified
1 (RSI_USERID) -- User ID first used, last used, or last modified
12 (RSI_SQLID) -- SQL ID first used, last used, or last modified
13 (RSI_ENVIRONMENT) -- Environment first used, last used, or last modified
14 (RSI_MODE) -- Mode first used, last used, or last modified
15 (RSI_COMMAND) -- Command first used, last used, or last modified

Time

Specifies first used, last used, or last modified:

0 (RST_FIRSTUSED) -- First used
1 (RST_LASTUSED) -- Last used
2 (RST_LASTMODIFIED) -- Last modified

Return Value

The return value will be zero, if successful and non-zero if unsuccessful. If the return value is non-zero, you can call GetLastErrorString(), GetLastErrorType(), GetLastSQLCode(), GetLastSQLError(), or GetLastSQLState() to get additional error information.