SQL Insert into... Select...

[mtajkov]

Hi,

I try:

Code: Select all  Expand view

.
.
.
    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

[cmsoft]

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 view

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

[mtajkov]

Thank you