Message 1 of 1
import data from Database to global table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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.
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.
my flexscript below:
Database.Connection con = Database.Connection("DBConnector1");
con.connect();
con.query("SELECT * FROM customers").cloneTo(Table("Customers"));
con.disconnect();