How do I tell if a view is open at runtime? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How do I tell if a view is open at runtime?

Message

From

14/07/2000 00:22:31

Jess Banaga
Bizbox Inc.
Makati, Philippines

To

13/07/2000 23:20:40

Jimmy Ditta
Twin City Electronics
Monroe, Louisiana, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: How do I tell if a view is open at runtime?

Miscellaneous

Thread ID:

00392218

Message ID:

00392228

Views:

9

>What is the best way to tell if a view is open at runtime?
>
>I have the following code in the init of the form. (the view's name is of course "intrancust")
>

Simplified:

IF !USED('intrancust')
   USE intrancust IN 0 
ENDIF
SELECT intrancust
INDEX ON stocknum TAG stocknum  && it should not be "intrancust" because that's where your tags will be automatically placed.  And besides, your order name is descriptive.  

SET ORDER TO stocknum && instead of SET ORDER TO intrancust

Why not use the Data Environment instead?

JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."

Click here to load this message in the networking platform