>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only