>I can't see anything wrong with your insert statement. It looks like your specifying 6 columns and 6 values. Maybe someone else can see the problem.
>
>>Hello Jonh
>>
>>Thanks to help me
>>
>>I'm getting to do my insert sql
>>But i'm having anothers problems
>>
>>my connection work fine but i have to write all fields of my table
>>
>>resp=SQLEXEC(nCONECTAR,[INSERT INTO cadcli (cod_cli, nome_cli, tel_cli, fax_cli, email_cli) VALUES (1, 'Anderson Reis Girardi', 3664579, 3664579, 'ander@net1.com.br')],'cartoes')
>>
>>If i use the followisg sintax the odbc driver shows me a message
>>
>>"Connectivity error:[TCX][MyODBC] Column count doesn't match value count."
>>
>>Do you can help me?
>>
>>Thanks
'[' and ']' should not be part of your statement. And I could count only 5 fields.
Hope it helps.
Oleg
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement