Hi,
Im sure this is mightly easy, but it just escapes me. I can do this with Access in my sleep, but I need to do it in SQL instead.
Can anyone explain to me how to connect to a SQL Db and manipulate the records, be it from reading them into a list or combo, to saving changes back to the Db.
I have added an Adodc control and added the settings required. All I need to know is the syntax in regards to opening/connecting to the Db and opening and reading the information from the tables held within the Db.
Mm think that makes sense.
I would use the help function but some muppet forgot to install it and I cannot get access to the CD's until next week.
Many thanks in advance
VRIT
Im sure this is mightly easy, but it just escapes me. I can do this with Access in my sleep, but I need to do it in SQL instead.
Can anyone explain to me how to connect to a SQL Db and manipulate the records, be it from reading them into a list or combo, to saving changes back to the Db.
I have added an Adodc control and added the settings required. All I need to know is the syntax in regards to opening/connecting to the Db and opening and reading the information from the tables held within the Db.
Mm think that makes sense.
I would use the help function but some muppet forgot to install it and I cannot get access to the CD's until next week.
Many thanks in advance
VRIT