FiveTech Software tech support forums

Posted: **Thu Jul 14, 2022 9:06 am**

Hi,

I try:


.
.
.
    oCn := FW_OpenAdoConnection( aCredentials, .t. )
.
.
.

cSql:="INSERT INTO Smp_Test (SELECT PR_Sifra, PR_Naziv FROM Smp_Partneri)"
oCn:Execute( cSql )

i am getting an error:

Error ADODB.Connection/0 S_OK: EXECUTE
Parameter :
[ 1] = C INSERT INTO Smp_Test (SELECT PR_Sifra, PR_Naziv FROM Smp_Partneri)

Please Help

Posted: **Thu Jul 14, 2022 12:16 pm**

Make sure that Smp_Test has only two fields of the same type as PR_Sifra and PR_Naziv

If the instead, has more fields that you don't want to fill, then put

Code: Select all | Expand


cSql:="INSERT INTO Smp_Test (PR_Sifra,PR_Naziv) (SELECT PR_Sifra, PR_Naziv FROM Smp_Partneri)"
oCn:Execute( cSql )

Posted: **Thu Jul 14, 2022 12:49 pm**

Thank you

FiveTech Software tech support forums

SQL Insert into... Select...

SQL Insert into... Select...

Re: SQL Insert into... Select...

Re: SQL Insert into... Select...