Base Table Name of View - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Base Table Name of View

Message

07/06/2001 14:19:16

Doug Ringley
Raleigh, Caroline du Nord, États-Unis

07/06/2001 14:09:05

Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Base Table Name of View

Divers

Thread ID:

00516515

Message ID:

00516522

Vues:

Renoir,

Here's a kludge to accomplish the first item.

use
lcProp = .property
lcProp = AllTrim(SubStr(lcProp, AT(' from ', Lower(lcProp)) +5))
lcTable = Left(lcProp, AT(Space(1), lcProp))

It's clumsy, but it's something. ;)

>Is there a way to determine in code the name of the table a view is based on? ...and what if a view is based on a view which is based on a table? Can I still get the original base table name? Thanks!
>
>Regards, Renoir

Répondre

Fil

Voir

Click here to load this message in the networking platform