you should uses a function for this
example, in update call sqlupdate()
in this function write on database
RDDINFO(RDDI_EXECUTE, "UPDATE country SET " + cField + " = " +
cNewValue + " WHERE CODE = " + cCode)
do you got?
Best regards
Fernando Athayde
________________________________
De: Itamar Lins <itamarl...@gmail.com>
Para: harbour@harbour-project.org
Enviadas: Quarta-feira, 3 de Março de 2010 9:53:49
Assunto: [Harbour] Re: RDDSQL Question.
Hi!
Thanks for response.
But if I for example use:
My Browse() function and modify a field?
Because I change only in temporary cache query.
How to proceed for commit?
Best regards,
Itamar M. Lins Jr.
Em 3/3/2010 09:38, Mindaugas Kavaliauskas escreveu:
> Hi,
>
>
> Itamar Lins wrote:
>> Can you create examples of creating,
>
> RDDINFO( RDDI_EXECUTE, "CREATE TABLE test (id int, txt char(20))")
>
>> adding,
>
> RDDINFO( RDDI_EXECUTE, "INSERT INTO test (id,txt) VALUES(1,'abc'), (2,
> 'def'))")
>
>> modifying fields of the tables via rddsql.
>
> RDDINFO( RDDI_EXECUTE, "UPDATE test SET txt='ghi' WHERE id=1")
>
>
>> For tables mdb via ado and other if possible.
>
> Sorry, I know nothing about .mdb and ado, but above should work for MySql.
>
>
> Regards,
> Mindaugas
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour
____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour
