VB6 recordset.updat e , field selective update (Beginers Q)

[mmanojkumar]

Sir,
I have a recordset "ADODC_path.rec ordset" which takes input from two tables
When the field values are put into the textboxes and then edited and updated back into the tables, using the following codes, everything works fine.

"select * from path,Station where path.StationCode=Station.StationCode and path.traincode=" & Text2.Text

Two tables Station(fields: StationCode and StationName) and
Path(fields: StationCode ,TrainCode ,RouteOrder)

The following code for table updation works well

   With Adodc_path.Recordset
                .AddNew
                .Fields("path.stationcode") = rs.Fields("stationCode")
                .Fields("TrainCode") = Text2.Text
                .Update  'this updates the recordset,tables etc.
            End With

The above code only updates the path table,( and thats what is required). This code is put in (ADD )button

I need to put the .update command in another command button(save) so that the editing can be cancelled using CANCEL button.
There comes the problem:
When I issue the Adodc_path.Reco rdset.update command, it updates both tables.
How can I update a set of selected fields only (but all rows)in one table,even if multiple tables are given in adcmdText query.

Kindly help.

With regards
M.Manoj

[willakawill]

Hi. This works by letting go of the idea that you have to do everyting with one sql statement.
In your code you are doing only one of 3 things:
1. updating path table where stationcode equals something
2. updating station table where stationcode equals something
3. updating both tables where stationcode equals something

You can write a separate sql statement for each of these three scenarios and call the one you need as you need it.

You don't need a recordset object to update a table or tables. Just a well put together sql statement.

[mmanojkumar]

Hi,
Thank you

Kindly clarify

1) How to issue seperate SQL commands to recordset object. I know the update command in SQL but dont know how to execute them in VB6.
2)How can we do it without recordset object.

regards
M.Manoj

[willakawill]

Use the execute method of the connection object

con.Execute "sql update statement here"

[mmanojkumar]

Hi,
Thanks , it is working

regards
M.Manoj