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