Im trying to understand how CA works, and I'm trying to make tests with CA using a simple Form, so I can understand how it works before build some kind of CA Class for real applications.

I created a Form and in the DE I added a new CA base class using the Builder.

But I havent discovered how to don't load data to the CA (cursor), when I run the form, then it asks for a value for the SELECT command...

Where in the form or CA or DE should I put a variable, so it doenst ask for the value...,
or what should I do to pass an inital value of -1 to the variable in the CA ?

...and later if I want to requery the data, where I should put the variable the variable that CA could use ?


SelectCmd = select Bancos.CODIGO_BANCO, Bancos.CONTA_C, Bancos.BANCO, Bancos.AGENCIA, Bancos.APELIDO
from Bancos WHERE CODIGO_BANCO = ?CODIGOX

DataSource = sqlstringconnect([dsn=Vitoria;uid=sa;pwd=sa;trusted_connection=no;])

KeyFieldList = CODIGO_BANCO

UpdateNameList = CODIGO_BANCO Bancos.CODIGO_BANCO, CONTA_C Bancos.CONTA_C, BANCO Bancos.BANCO, AGENCIA Bancos.AGENCIA, APELIDO Bancos.APELIDO

UpdatableFieldList = CONTA_C, BANCO, AGENCIA, APELIDO


Could someone explain-me how to make this in CA ?

Thanks In Advance

Peter