Sql query not showing all the values

[usr123]

Hello,

i am working with Access forms, and on the form i am adding record in the sql server. Problem:

Sql query doesnt show all the values for the columns. My query has got 32 columns where as values it shows are up to 4-5 columns.
Is there any limit on ho wmany columns you could use in Sql through access? Am i missing something here?If i didnt make myself clear plz let me know and i will try again.
Below is the query in 'Add watch'. All fileds have values, but query is stopping randomely.

"INSERT INTO dbo_tb_qua_capability ( Ref_no,Received_date,Employee_number,Department_number,Ac_type,Description,Part_number,Throughput,ATA,Target_date,QIR_obs) values ('Q/C/09-9,'',2089,-1,'test,'test,'test,'test,'test','24/02/2010','test','test','24/

 

[jdraw]

Hello,

i am working with Access forms, and on the form i am adding record in the sql server. Problem:

Sql query doesnt show all the values for the columns. My query has got 32 columns where as values it shows are up to 4-5 columns.
Is there any limit on ho wmany columns you could use in Sql through access? Am i missing something here?If i didnt make myself clear plz let me know and i will try again.
Below is the query in 'Add watch'. All fileds have values, but query is stopping randomely.

"INSERT INTO dbo_tb_qua_capability ( Ref_no,Received_date,Employee_number,Department_number,Ac_type,Description,Part_number,Throughput,ATA,Target_date,QIR_obs) values ('Q/C/09-9,'',2089,-1,'test,'test,'test,'test,'test','24/02/2010','test','test','24/

You have some serious sql syntax issues with the use of single quotes. What did you expect ...'test,'test,... to do?

 

[MSAccessRookie]

Hello,

i am working with Access forms, and on the form i am adding record in the sql server. Problem:

Sql query doesnt show all the values for the columns. My query has got 32 columns where as values it shows are up to 4-5 columns.
Is there any limit on ho wmany columns you could use in Sql through access? Am i missing something here?If i didnt make myself clear plz let me know and i will try again.
Below is the query in 'Add watch'. All fileds have values, but query is stopping randomely.

"INSERT INTO dbo_tb_qua_capability ( Ref_no,Received_date,Employee_number,Department_number,Ac_type,Description,Part_number,Throughput,ATA,Target_date,QIR_obs) values ('Q/C/09-9,'',2089,-1,'test,'test,'test,'test,'test','24/02/2010','test','test','24/

Not only are there numerous instances of missing quotes "'", but there is also a "/" in the place of where I believe the Closing ")" should be. Each String VALUE needs to start AND end with quotes "'". Fix these errors, try again, and post the updated SQL code if it still does not work.