import data from Database to global table

import data from Database to global table

nguyenthanhnam2310
Contributor Contributor
68 Views
0 Replies
Message 1 of 1

import data from Database to global table

nguyenthanhnam2310
Contributor
Contributor

I export from the table to sql server is fine but when I tried to import back, the data is nothing like the picture attached. 

nguyenthanhnam2310_0-1778293389298.png

I look up the example in the doc and use the cloneTo() and it happen.

from my sql is still have data, so why I got this result in global table and how I can avoid that.

nguyenthanhnam2310_1-1778293587079.png

nguyenthanhnam2310_2-1778293606951.png

 my flexscript below: 
Database.Connection con = Database.Connection("DBConnector1");

con.connect();

con.query("SELECT * FROM customers").cloneTo(Table("Customers"));

con.disconnect();

0 Likes
69 Views
0 Replies
Replies (0)