Visual Fox Pro 9

[timjhan]

Plz help me with this one im new.
i want to insert values in my table using the values in other table but it doesn't work.
heres my code
qryinssub = "INSERT INTO section_load(sec_id,subj_id)VALUES('sec01',(";
+ "SELECT subj_id FROM subjects WHERE level_id = lvl01))"
SQLEXEC(gnhandler,qryinssub)
plz HELP.

 

[SkipVought]

Do a Debug.Print qryinssub, and determines if that string works in a query.

 

[PHV]

What about this ?
qryinssub = "INSERT INTO section_load(sec_id,subj_id) SELECT 'sec01',subj_id FROM subjects WHERE level_id='lvl01'"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886