Sc_lookup(my_account, “SELECT account_type FROM account WHERE account_id = ‘ is not valid. OnValidate event to verify that accounts match the defined rules sc_lookup NO changes to the account fields - these are simple text fields - the user can type anything they want into them - restricted only by allowed characters WHERE account_type = ‘’ AND active = ‘Y’ĪJAX Event “transtype_onChange” on my data entry FORM (this sets the global variable)Ĭapture link on the data entry FORM (one for each account field- account1 & account2) I’ve taken a different approach … (it sure would be handy to know if I am doing things the ‘right’ way! - seems a little convoluted but it works)Ĭreated a GRID for lookup of each account (need one for each account field) with a where clause using a global variable SELECT "The OnLoadRecord event is not available when the orientation is defined as single record … " Have tried to reset the variable in every event - and have found that if I reset the variable then I don’t get a lookup list at all. 2.- I have a PDFReport application, but i can’t be able to locate the file on the lib folder. 1.- I try with scsetpdfname but this macro works on Grids only. ScripCase creates the prototypes and saves time of a developer to start. For information about the timing of events execution or other information, access the documentation of the desired event. Select the appropriate account (if Deposit account1 = “Income”, account2 = “bank” - but if Withdrawal account1 = “Bank” and account2 = “Expense”) I have a form, and I want on Update, to create a pdf and send it as attachment. ScriptCase will help you out with all the forms. Select a transaction type (for example “deposit” or “withdrawal”)ĭepending on the transaction type selected, change the lookup for account1 and account2 - so that only the accounts that have the same account_type are listed (for example - a deposit should use an “income” account and “bank” account - but a withdrawal should use a “Bank” account and “Expense” account) If I change one record then the next record that I look at, the fields are empty and the lookup is displaying the values selected the last time that i used it (Hope that makes sense). It does write the appropriate values to the database - but in SC, when I go back and look at the record later, those fields are empty. But - it is retaining the last value selected and I cannot figure out how/where to reset the value of those global variables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |