Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I could use a bit of help here.
>
>I want to copy fields from one table to another. I get a syntax error on the insert into line of my code. I don't think that it is recognizing the name of the table.
>
>Here is my code.
>
>close tables all
>use newmen in 0
>use counttbl in 0
>go top
>scan
> INSERT INTO counttbl (Num,priority,last,first,sex,act,act_length,act_date,; status,trans_num,trans_type,comments1,comments2,;
> add_date,prog_code,trans_stud,new_stud,ret_stud,;
> late_ret_stud,off_stud,temp_stud)
> VALUES (newmen.Num,newmen.priority,newmen.last,newmen.first,"m",newmen.act,newmen.act_length,newmen.act_date,newmen.status,;
> newmen.trans_num,newmen.trans_type,newmen.comments1,newmen.comments2,newmen.add_date,newmen.prog_code,;
> newmen.tran_stud,"y","n","n","n","n")
>endscan
>
>
>Help would be most appreciated. Thanks
Won't "APPEND FROM" or "COPY TO" suite your needs? They could do in one line of code what your doing up there.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement