×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

IMLSMST_SQL and IMLSTRX_SQL

IMLSMST_SQL and IMLSTRX_SQL

IMLSMST_SQL and IMLSTRX_SQL

(OP)
Anyone know off-hand what the nature of these two tables relationship is? When you report production, which gets updated first?

I noticed that when production is reported in POP that the pop-up is in fact an IM form - it gives you the opportunity to enter the MFG Ser Lot code there. Doesn't look like this form is readily modified through Flexibility at all.

Any insight would be appreciated. It does not look like other tables are being hit during this process.

Thx

Ivan

RE: IMLSMST_SQL and IMLSTRX_SQL

IMLSMST is the lot/serial master, and by definition must be created first before a lot/serial transaction can be recorded (IMLSTRX).

In Progression, nearly all popup forms are modifiable with Flexibility. Open up the POP screen and click the Flexibility icon to open VBA. Then enter a transaction. When you get to the LS screen, hold down the shift key and double right click any field. Flexibility for the LS screen will open up in your VBA editor. You can then go write VBA code for whatever event(s) are available on that screen.

In terms of what tables are affected, check out SQL Delta. Great tool. You can take a copy of a database. Perform a transaction, then compare databases. It will show you table by table and field by field what the transaction did in the underlying SQL database. This is invaluable for me when writing Flex or .NET code. Very affordable too, $330 for a single user license. http://www.sqldelta.com/

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: IMLSMST_SQL and IMLSTRX_SQL

(OP)
Hey Don,

Thx for the input. That's awesome. I was starting to get distraught that we wouldn't be able to get at that screen. So if I write code in C# or VB .NET I can add the form to Progression as well, which could be very handy. We've done some nominal stuff in SharePoint but it really isn't what we need. I have a trial of SQL Delta, so I'll try that.

RE: IMLSMST_SQL and IMLSTRX_SQL

Don,
There is a way in flex to list each table that is updated on the "Save Event". Do you remember this code ?

RE: IMLSMST_SQL and IMLSTRX_SQL

Ivan,

Yeah VBA is cool but it has its limitations. We write stuff in .NET and call it from VBA if we need more functionality. That said you can create user forms in VBA as well. Maybe you can give me an idea of what you are trying to do?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: IMLSMST_SQL and IMLSTRX_SQL

I am unaware of the code in Flex to list each table updated. You can look at the DRMs - developer's reference manuals. They are a little dated but pretty good. I would use SQL delta personally.

If you find code like that I'd love to see it.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close