PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Increment Line No in HFSQL
Increment Line No in HFSQL
Iniciado por guest, 07,nov. 2016 06:13 - No hay respuesta
Publicado el 07,noviembre 2016 - 06:13
Hi
We have a table with approx 10,000 records in it which we need to partially copy into another existing table. As part of the copy process we need to allocate a line number to each record we copy. I would prefer to do this using SQL Insert if at all possible but I can't find any way to make the line number increment.

Is this possible or do I need to revert to code to do it?

Thanks

David