i have 2 table in my database access 1 is temporary and the second one is temporary2, how can i save all the data in temporary to temporary2? im using adodb.
try this code...
rs.Open "select * from temporary1", gcn
gcn.Execute "delete from temporary2"
If rs.RecordCount > 0 Then
While Not rs.EOF()
gcn.Execute "insert into temporary2(roll,name,address) values('" & rs!roll & "','" & rs!Name & "','" & rs!address & "')"
If rs.State = adStateOpen Then rs.Close
Set rs = Nothing
where gcn is the connection and rs is the recordset object respectively....replace these with your objects....
check out the statement which is marked as red...this is the sql statement you need to modify according to the fields you have in your tables....this statement will extract one row from temporary1 table and insert it to temporary2 table...
hope this helps....get me a feedback if this works out...
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...
I am writing a java program that needs to execute shell commands, so I wrote a function that would take the command to execute as a string (ie: "mkdir ~/Folder1") and execute that command with the shell. Here is the function:
Runtime run = Runtime.getRuntime();
Process pr = ...
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.