Jump to content
Sign in to follow this  
carl9861

Using ExecuteSQL script step for multiple queries

Recommended Posts

I'm trying to prefix a unique serial number (generated in x1 MySQL table) with a text string (in another MySQL table) and zerofill the integer so that the VARCHAR is 13 characters in length - via the use of the ExecuteSQL script step.

In MySQL I can create the serial number (ID in serial table), get the LAST_INSERT_ID() in that table and then pass the value across to the second table

serial table;

serialID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

PRIMARY KEY (serialID)

products table;

serialID INT(9) UNSIGNED ZEROFILL NOT NULL

productID VARCHAR(13)

PRIMARY KEY (serialID)

Query example;

INSERT INTO serial (serialID) VALUES (NULL);

INSERT INTO products (serialID, productID) VALUES (LAST_INSERT_ID(), CONCAT('PROD',serialID));

Question: How can I re-create this using FP12?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.