Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor adapter and View
Message
 
À
25/05/2005 04:00:59
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01017384
Message ID:
01017731
Vues:
20
Hi Cetin,

Thank You for this reply.
I have created my SQL View with a SELECT like this:
*********
SELECT dbo.commondata_.descrn AS commdescr, dbo.register_.*, dbo.commondata_.type AS commtype, dbo.counter_.tipo AS countype, dbo.counter_.descr AS coundescr
FROM dbo.commondata_
INNER JOIN dbo.register_ ON dbo.commondata_.code = dbo.register_.type
INNER JOIN dbo.counter_ ON dbo.register_.codcnt = dbo.counter_.code
WHERE (dbo.commondata_.type = 15) AND (dbo.counter_.type = 'A')
*********
commondata_, register_ and counter_ are SQL Tables.

When I create a cursor with a table, i.e I enter:
1)in the 'cursorschema' Property CODE C(3), DESCR C(30), TYPE C(1)
2)in 'SelectCmd' Select counter_.CODE, counter_.DESCR, counter_.TYPE From counter_

If I need to create a CA for the View as about, what is the correct Select and the correct Cursorschema that I must enter?

Can You help me?

Best Regards
Gaetano
Nino
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform