General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thank you Vladimir,
It worked fine after testing your code, is it possible to do with
SQL statment only ?
**********************************************************************
Paul,
Try this code
USE NewTable EXCL
ZAP
SELECT 0
USE mytable
SCAN
INSERT INTO NewTable (amount1) VALUES (mytable.Field)
SKIP
REPLACE amount2 WITH mytable.Field IN NewTable
ENDSCAN
>Hi all,
>
>I have mytable
>
>amount ( char. field) with 2 records
>10000
>20000
>
>to get newtable with 2 fields with 1 record
>
>newtable ( this table already exists with a structure)
>amount1 amount2
>10000 20000
>
>This is to transfert from mytable 2 records to newtable to get 1 record
>but 2 fields ( amount1 and amount2 ).
>
>TIA for who can help me out.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only