SQL cursor results used in another cursor

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SQL cursor results used in another cursor

Message

27/08/2013 00:00:56

Thomas Ganss
Main Trend
Frankfurt, Allemagne

26/08/2013 14:54:41

Randy Waldman
Hoffer Companies
Houston, Texas, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: SQL cursor results used in another cursor

Versions des environnements

Visual FoxPro:

VFP 7 SP1

OS:

Windows 2000 SP4

Network:

Windows 2000 Server

Database:

Visual FoxPro

Application:

Desktop

Divers

Thread ID:

01581453

Message ID:

01581484

Vues:

>Hi. Note that I am a vfp7 user. This question is about using a sql to create a cursor and using that cursor in the 'From' of the very next sql. I can't get the syntax. Fox keeps prompting for that 'From' in the second sql. Any help is appreciated.
>
missing one oft the
lcCursName = "MySpecialTempCursor"
select ...
into cursor (lcCursName) nofilter
select ...
from (lcCursName) ?

Répondre

Fil

Voir

Click here to load this message in the networking platform