How to know if current SELECT() is a table or a view? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to know if current SELECT() is a table or a view?

Message

From

21/07/1999 20:02:15

Bob Archer
Tampa, Florida, United States

To

21/07/1999 16:16:22

Eric Crespin
Pc Plus Inc.
Montréal, Quebec, Canada

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: How to know if current SELECT() is a table or a view?

Miscellaneous

Thread ID:

00244334

Message ID:

00244476

Views:

15

>Is there a way to know if the current select() is a table or a view and if there is uncommitted changes in it?
>
>thanks
>eric.

Use CURSORGETPROP('SourceType')

Returns:

1 – Specifies that the data source is a local SQL view.
2 – Specifies that the data source is a remote SQL view.
3 – Specifies that the data source is a table.

BOb

Click here to load this message in the networking platform