Computing.Net > Forums > Programming > inserting integers in VB

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

inserting integers in VB

Reply to Message Icon

Name: sunny
Date: October 10, 2004 at 01:03:10 Pacific
OS: xp
CPU/Ram: 256
Comment:

thank U SN. it is workning..
i have another problem .. iam getting errors when inserting integers
pls tell me how to insert into sql database
through VB..
insert into .. values("+i+")
here i is an int .. this syntax dosent work..

pls help me..

thank u



Sponsored Link
Ads by Google

Response Number 1
Name: Chi Happens
Date: October 11, 2004 at 07:13:08 Pacific
Reply:

You have to use VB's string concatenation symbol.

&

so you would write

"INSERT INTO MyDB (MyField) VALUES (" & i & ")"

Chi


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: inserting integers in VB

On Error in VB www.computing.net/answers/programming/on-error-in-vb/9139.html

Menus in vb www.computing.net/answers/programming/menus-in-vb/1662.html

insert statement in VB www.computing.net/answers/programming/insert-statement-in-vb/2433.html