-
Mar 2nd, 2021, 05:31 AM
#1
Thread Starter
Junior Member
How i insert rows in a table
This insert not insert nothing why?
Set rdoQry.ActiveConnection = cnMySql
Set rdoRS = rdoQry.OpenResultset(rdOpenKeyset, rdConcurRowVer)
Do Until rdoRS.EOF
insertQry.SQL = "INSERT INTO magazzino_media (codice_articolo,quantita,data_giacenza) VALUES ('" & rdoRS!codice_articolo & "', '" & rdoRS!q_art & "','" & Date & "')"
Debug.Print insertQry.SQL
Set insertQry.ActiveConnection = cnMySql
Set rdoRS1 = insertQry.OpenResultset(rdOpenKeyset, rdConcurRowVer)
rdoRS.MoveNext
Loop
-
Mar 2nd, 2021, 05:41 AM
#2
Thread Starter
Junior Member
Re: How i insert rows in a table
it insert only 6 rows of 30.000
-
Mar 2nd, 2021, 06:14 AM
#3
Re: How i insert rows in a table
You are not using ADO it seems??
Instead of taking the results of a previous query and do a lot of queries for the complete recordset you can also rewrite your "INSERT"
https://www.w3schools.com/sql/sql_in...nto_select.asp
-
Mar 2nd, 2021, 06:35 AM
#4
Thread Starter
Junior Member
Re: How i insert rows in a table
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|