Archives
When you try restoring a SQL database, you may get an error message saying “Exclusive access can’t obtained, database is in use”. First, of course, stop all Syteline service, like IDO, Taskman. If it still doesn’t work, try the below to set it to single user mode Use Master Alter Database Database_Name SET SINGLE_USER With […]
SOLUTION #1 – This is to be used if you are UPGRADING from a previous SL7.0x version, and applying a Service Pack. This is NOT to be used if you are ONLY applying a Service Pack to the same SL7 version. Before you begin the upgrade, please review your Client Configuration Names go to Start>Programs>MAPICS>Tools>Client […]
In general, the variables you create will be specific to your application’s forms and fields. However, WinStudio supports one variable that will be of general use to form developers. The variable InitialCommand can be used to determine the initial behavior of a form. The syntax is as follows: InitialCommand(arg), where arg can be one […]
In Syteline, many key number like Customer#, Invoice# and such, they have prefix and fixed length. When key in the number, system can auto expand or auto fill the number based on its format, such as key in “C1”, it will expand to “C000001”. To get this auto expand function in a component field of […]
If you ever need to change the site name in Syteline, here are steps you should follow, 1) Backup all your database. 2) Log off all users. 3) Run the “Change Site” utility. 4) If Intranet Licensing has been implemented in this site, after running the Change Site Utility, the Intranet License option on the […]
Below is a pretty useful Form Script Function that can be used to send out email. You can trigger this by any event. PublicSub SendEmail() Dim EmailBody AsString Dim toAddress AsNew Net.Mail.MailAddress(ThisForm.PrimaryIDOCollection .GetCurrentObjectProperty("your_email_field")) Dim FromAddress AsNew Net.Mail.MailAddress("me@company.com", "Display Name") EmailBody = "Some text:" & ThisForm.PrimaryIDOCollection.GetCurrentObjectProperty("some_property") & vbNewLine _ & "Some more stuff: " & vbNewLine […]
When a Syteline form open in “filter in place” mode, you may want some of the fields already have frequently use value there. For example, you may want the warehouse field has default filter value of “Main”. To do that, it is pretty simple. In the form you want to set this up, add a […]
How to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box. Example: If Fat, Use range from C6:C7 If Skinny, Use range from D6:D7 You can direct put the IF statement in 2nd drop down validation, like =IF(Sheet1!$A$1="Fat", Sheet1!$C$6:$C$7, Sheet1!$D$6:$D$7)
Excel provides conditional formatting which allows you to change the color and other attributes of a cell based on the content of the cell. There is no way, unfortunately, to easily hide rows based on the value of a particular cell in a row. You can, however, achieve the same effect by using a macro […]
Open the component class “UserDefinedType”, go to validator, add one more parameter %2 to the UserDefinedTypeValue validator. Open the validator, make sure %2 is there. Then open the property of the validator. Open the Parameters screen Set %=Description in Set Prop/Var/Comp section. OK all the way back to save the change in Component Class. Now […]