Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor adapter and View
Message
 
To
25/05/2005 04:00:59
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01017384
Message ID:
01017731
Views:
18
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform