DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

About Updating a Record in adodb

« First

•

Join Date: Aug 2008

Posts: 302

Reputation: aktharshaik is an unknown quantity at this point

Solved Threads: 36

aktharshaik aktharshaik is offline

Offline

Posting Whiz

Re: About Updating a Record in adodb

#21

Dec 2nd, 2008

All the fields in the Deliver table are Text except for the Date Field.

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
"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 + "#)"
"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 + "#)"

Regards
Shaik Akthar

•

Join Date: Jul 2008

Posts: 161

Reputation: ryan311 has a little shameless behaviour in the past

Solved Threads: 1

ryan311

Offline

Junior Poster

Re: About Updating a Record in adodb

#22

Dec 2nd, 2008

cn.execute "insert into? right?

•

Join Date: Aug 2008

Posts: 302

Reputation: aktharshaik is an unknown quantity at this point

Solved Threads: 36

aktharshaik aktharshaik is offline

Offline

Posting Whiz

Re: About Updating a Record in adodb

#23

Dec 2nd, 2008

Hey Got the problem.

Actually the field with the name "date" is actually a reserved keyword.

just put square brackets around that field in the query.

her it is

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
"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 + "#)"
"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 + "#)"

Regards
Shaik Akthar

•

Join Date: Aug 2008

Posts: 302

Reputation: aktharshaik is an unknown quantity at this point

Solved Threads: 36

aktharshaik aktharshaik is offline

Offline

Posting Whiz

Re: About Updating a Record in adodb

#24

Dec 2nd, 2008

a better suggestion is change the name of the field in every table with the fieldname "date" as "mdate" or "edate" or "ddate" or anything else , other than the spelling "date"

Regards
Shaik Akthar

•

Join Date: Jul 2008

Posts: 161

Reputation: ryan311 has a little shameless behaviour in the past

Solved Threads: 1

ryan311

Offline

Junior Poster

Re: About Updating a Record in adodb

#25

Dec 2nd, 2008

thank you so much shaik akthar it helps a lot of me thanks! god bless u!

•

Join Date: Aug 2008

Posts: 302

Reputation: aktharshaik is an unknown quantity at this point

Solved Threads: 36

aktharshaik aktharshaik is offline

Offline

Posting Whiz

Re: About Updating a Record in adodb

#26

Dec 2nd, 2008

If ur problem is solved then Mark the thread as solved, b'cos it may help even the others to search for similar problem and those threads having the notation of solved.

Regards
Shaik Akthar