question

Aravind D avatar image
0 Likes"
Aravind D asked Phil BoBo edited

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)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Phil BoBo avatar image
2 Likes"
Phil BoBo answered Phil BoBo edited

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.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Related Questions

DBConnector using codes