How to using a variable in a database connection

[rtm_e]

Hi...
i am a newbie in VB Programming

right now i am tryng to make a simple programme that will connect VB with an Access Database

Can i use a variable inside connection sintax..?

Something like this....

What i want to do is accessing field NmPeg that suppose to use programming like...

DE.rsPegawai!NmPeg

But how do i use a variable x, like...

x = NmPeg
DE.rsPegawai!x

i'll try many times but always fail...
Please tell me the correct syntax...

Thanks

[kb.net]

Hi,

Use rsPegawai(x)

[debasisdas]

If you are trying to store value retrived from database then try to use

x=DE.rsPegawai!NmPeg

[rtm_e]

Hi,

Use rsPegawai(x)

Thanks man... Problem solved... :-)

[Hamidshah]

Hi
if u found any thing usefull. then tell me also.
Shah
E & T Department
Islamabad
Pakistan

[kb.net]

Hi,

The pro. way of doing it is using the index of the field for ex: rsPegawai(1)

[rtm_e]

Hi,

The pro. way of doing it is using the index of the field for ex: rsPegawai(1)

===========
cant u help me with my problem in
http://www.daniweb.com/forums/showthread.php?p=463636&posted=1#post463636 ....?

[rtm_e]

If you are trying to store value retrived from database then try to use

x=DE.rsPegawai!NmPeg

With that statement, wich record will be store in x value??
Assume that i have a lot of record in field NmPeg

[debasisdas]

the variable will store the first reord from the NmPeg field of your recordset . But for that you need to use movefirst of the recordset.