dbimporttable() command is not returning any values

Question

question

Aravind D asked Nov 22, '19 Phil BoBo edited Nov 22, '19

dbimporttable() command is not returning any values

HI, @phil.bobo @Joshua S @Matthew Gillespie

I am using db commands in custom code to get tables from database i want to import values from database table "user_details" to GlobalTable1.

I am Trying to use dbimporttable command . However, after 'dbimporttable' is executed, no tables are imported to GlobalTable1.I am not sure what I missed. I don't want to use dbconnector that is available in flex-sim I am using only codes to get the result

I have attached the picture with this

Thank you for your help much in advance.

db

dbimportable.png (92.7 KiB)

Answer 1 · 2019-11-22T15:49:29Z

Phil BoBo answered Nov 22, '19 Phil BoBo edited Nov 22, '19

You can use the Database Connector tool to simply configure the connection and then use the FlexScript Database API commands to query it directly with code.

If you use the Database Connector, you can connect directly to your MySQL database. If you use the deprecated db...() commands, then you need to configure an OBDC data source in Windows that connects to your database, and then connect to that ODBC data source. That's a big unnecessary pain. Don't use the global commands that start with db...(). They are old and don't work well. Just use the Database Connector.

question