Thank you for the quick and informative reply.
We were trying to add additional locations to the IMINVLOC table after a batch of new items had been added to the database. The production manager discovered how to do this using MACOLA's input screens. We were curious because we had taken care not...
Hello forum members,
A client is using MACOLA ES 9.5.700. We sometimes use Microsoft ACCESS Update queries to make wholesale changes to certain fields such as prices or costs when there is no convenient method available using MACOLA screens. On occasion we have tried using Append queries to...
Hello SamW41,
We use Flexibility to do such things as:
1. Get a part number from an ACCESS database, enter it into the ItemMaster table, then construct the BOM for this item from information in an ACCESS table. We do this by using Sendkeys
to simulate a "phantom" user sending data to MACOLA...
We have some Flexibilty code behind a Bill Of Material module form (Product Structure File Maintenance). In that routine SendKey ("{enter}") works OK.
Jerzy
My client intends to continue the upgrade process up to the latest version. He wants to be sure his installation is stable with one version before going to the next higher version.
One thing that bothers us: when the Flexibilty client module is updated, the opening splash screen displays...
We have had trouble with the Visual Basic Sendkeys not working consistently in this application, so we bought
a routine several years ago from M8 Software that replaces the Visual basic Sendkeys with a routine called "SendKey".
This routine has worked flawlessly until the upgrade to Progression...
It would probably be more accurate to say that SendKeys
fails in some lines of code but appears to work in other places.
Tomorrow I'll try adding the "Wait" parameter = true to see if that helps.
Jerzy
A client has begun to bring his MACOLA installation more up to date and has upgraded from Progression 7.6.200 to 7.6.300. (Running MS SQL).
Flexibilty routines seem to start but the Sendkeys function
does not work. (The Flexibilty server and clients have been updated.)
Has anyone any ideas...
I have a client who recently upgraded from Pervasive SQL to MS SQL. It seems that fields in MACOLA tables that previously had empty strings denoting "no value" now are null. I have had to modify Flexibility routines to allow for the null values, and many of their Crystal Reports require...
I have got the routine to do what I desired (update the user_def_fld_5 when a license is required) by a modification of Andy Baldwin's suggestion. I could not get the postsave event to trigger, but I triggered the update query on the type1(order type) got-focus event.
This was suggested by...
Hello Andy,
The Postsave event does not seem to do anything: the only three events of the macform object that seem to work on my client's installation are the Initform, Save, and Close.
(I test by putting a message box in the event to see if it triggers). Putting the order number in a global...
I tried finding the macform.connifo.openadoconn object but could not: ConnInfo has 4 or 5 properties, but OpenADOConn is not among them. I looked at some of my ADO references and realized that the connection parameter is optional in the openrecordset method: if it is not specified, the active...
Hello NEmacGuy,
I think you might be on to something with your thought about the connection being used: I opened a new connection, rather than using the opened connection being used by macForm. I wasn't sure how to access the connection being used. This could explain the "locked-record"...
Hello Don,
That is what I'm doing: setting a global variable on an event triggered by an earlier field, then setting focus to the user defined field, then on the got-focus event trying to set the user defined field's value to the global value. Similar methods have worked on other Flexibility...
Thanks for your efforts, Don, in looking into this.
I get "Btrieve error 84" as the record-locking error message.
I continue to work on the other approach: having Flexibility update the value for the user defined field, but I cannot get the code to trigger on the got_focus event. I either get...
My client has certain products that need an export license
when shipped to certain counries. They want a message printed on the Pick Ticket when such a license is required with no user action required.
I have made routines that determine when such a license is required using Flexibility on the...
Hello Don,
I wasn't able to view the actual code, but I found an old listing and I think no parentheses are needed:
that is, try SendKeys "{ESC}"
the double quotes were used.
jerzy
Hello Don,
Try putting double quotes " around {ESC]-----
making it SENDKEYS("[ESC]"). I have a client using SENDKEYS in a Flex application and I will check their code later today to verify this, but it's worth a try.
jerzy
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.