Re: About Updating a Record in adodb
 

ur code is

"Insert Into Deliver (scode, pcode, quantity, unit, amount, pcarrier, pterms, drnumber, date) Values ('" + Combo1.Text + "','" + Combo2.Text + "'," + Text1.Text + "," + Text2.Text + "," + Text3.Text + "," + Text4.Text + "," + Text5.Text + "," + Text6.Text + "," + Text7.Text + ")"

I assume scode, pcode, unit, pcarrier, pterms, drnumber, date are Text fields
and quantity, amount are Numeric fields
hence

"Insert Into Deliver (scode, pcode, quantity, unit, amount, pcarrier, pterms, drnumber, date) Values ('" + Combo1.Text + "','" + Combo2.Text + "'," + Text1.Text + ",'" + Text2.Text + "'," + Text3.Text + ",'" + Text4.Text + "','" + Text5.Text + "','" + Text6.Text + "','" + Text7.Text + "')"

also remove the
, cn, adOpenKeyset, adLockPessimistic
in the insert statement.

Regards
Shaik Akthar

Re: About Updating a Record in adodb
 

syntax error in inert into

Re: About Updating a Record in adodb
 

what is the datatype of the field 'date' in your database and is it MS-Access Database?

Re: About Updating a Record in adodb
 

just once give me all the fields with their datatypes with which they exist in the database in the table Deliver

Re: About Updating a Record in adodb
 

the date is Date/time and the rest is text

Re: About Updating a Record in adodb
 

If the database is MS-Access u have to use a # for date field.
It goes like this. replace the query with this one.

"Insert Into Deliver (scode, pcode, quantity, unit, amount, pcarrier, pterms, drnumber, date) Values ('" + Combo1.Text + "','" + Combo2.Text + "'," + Text1.Text + ",'" + Text2.Text + "'," + Text3.Text + ",'" + Text4.Text + "','" + Text5.Text + "','" + Text6.Text + "',#" + Text7.Text + "#)"

Re: About Updating a Record in adodb
 

still having a error

synthax error in insert into, how can i upload my files here? can u fix it?

Re: About Updating a Record in adodb
 

just zip the access database file and the vbform.

Click on Reply to Thread button. do not post in quick reply.
below the reply box u can find the button for attachments. there u select the zip file and upload it.

Re: About Updating a Record in adodb
 

i have enclosed a screenshot of the reply screen

Re: About Updating a Record in adodb
 

here it is!