>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
What about creating 3 CAs instead? One for each table. Solution.app has samples using parameters.
Update: View was in SQL server. I got it wrong. Create a single CA using builder, but I think this is not even for editing. Your select doesn't match view's fields so I'm not sure what you're doing.
Cetin