Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Functions Popular In PowerBuilder – PowerBuilder Library
April 9, 2021

Functions Popular In PowerBuilder

Functions Popular In PowerBuilder

Functions Popular In PowerBuilder
FunctionsDesctions
1. Data type functions
  Char :Convert bolb, integer, and string to characters and return
  Dec :Converts the contents of a string to a decimal number and returns
  Double :Converts the contents of a string to a Double and returns
  Integer :Converts the contents of a string to an integer and returns
  Long :Returns the contents of a string by converting it to a Long
  Real :Returns the contents of a string by mistake
  Date :Only the Date value is retrieved from the DateTime read from the database.
  DateTime :Convert Date or Time value to DateTime value and return
  IsDate :Checks whether the specified string has a valid date value
  IsNull :Check whether the passed factor is null
  IsNumber :Check if the specified string has a numeric value
  IsTime :Checks whether the specified string has a Time value
  String :Opens a string in the specified format
  Time :Retrieves only the Time value from the DateTime read from the database.
2. Date, week and time functions
  Day :Get a date
  DayName :Find the day of the week
  DayNumber :Express the day of the week as a number (1 for Sunday)
  DaysAfter :Calculates N days before and after on the specified date.
  Hour :Find the poem of a given time
  Minute :Find the minutes of a given time
  Month :Find the month of a given time
  Now :Get the PC’s system time
  RelativeDate :Calculates the date n days after the given date.
  RelativeTime :Find the time after n seconds based on the given time
  Second :Returns the seconds of a given time
  Today :Get the PC’s system date
  Year :Returns the year value of a given date
3. Number function
  Abs :Get the absolute value of a number
  Ceiling :Returns the smallest integer greater than or equal to a specified number
  Cos :Find the cosine of a given angle
  Exp :Find the value of e raised to the power of number
  Fact :Find the factorial (4! = 4* 3* 2* 1)
  Int :Discard decimal point and return to nearest integer
  Log :Returns the natural logarithm of a specified number
  LogTen :Returns the base 10 logarithm of a specified number
  Max :Return the larger value of the two hands
  Min :Return the smallest value of the two
  Mod :Returns the remainder of dividing two numbers
  Pi :3.14159…
  Rand :Generate random numbers
  Randomize :Initialize random number generation
  Round :Round a number to the specified number of digits
  Sign :Determining the sign of a number (positive: 1 negative: -1 0: 0)
  Sin :Returns the sine of a given angle
  Sqrt :Returns the positive square root
  Tan :Returns the tangent of a given value
  Truncate :Drop decimal point and return integer
4. Print function
  Print :Print a string in the current font
  PrintBitmap :Print bitmap image in designated print space
  PrintCancel :Cancel printing
  PrintClose :Send current page to printer and end printing
  PringDefineFont :Font designation when printing
  PrintLine :Draws a line at the specified location with the specified thickness
  PrintOpen :Start print job, assign print number
  PrintOval :Draws an ellipse at the specified location with the specified thickness
  PrintPage :Send the current page to the printer and set a new page
  PrintRect :Draws a rectangle with the specified thickness at the specified location.
  PrintRoundRect :Draw a square with rounded corners at the specified position and with the specified thickness.
  PrintSend :Send to the specified character string printer
  PrintSetFont :Specify the font for the current print job
  PrintSetSpacing :Specify the width between lines
  PrintSetUp :Calling the Printer Setting Dialog
  PrintText :Print the specified character at the specified position
  PrintWidth :The width of the specified string in the current font
  PrintX :X coordinate of cursor
  PrintY :Y coordinate of the cursor
5. String processing function
  Asc :Returns the Ascii value of the first character of a string
  Char :Returns the character corresponding to the given Ascii value
  Fill :Create a string by repeating the specified character
  Left :Returns the number of characters from the beginning of the string to the specified number.
  LeftTrim :Remove spaces from beginning of string
  Len :Return string length
  Lower :Return uppercase letters in the given string to lowercase letters
  Mid :Specify the start and end positions in the given string and return only a certain part of the string
  Pos :Return the position of a given string in another string
  Replace :Convert part of a string to another string
  Right :Returns a specified number of characters from the end of a string
  RightTrim :Remove spaces at the end of a string
  Space :Get an empty string with a specified length
  Trim :Remove spaces from the beginning and end of a string
  Upper :Return lowercase letters in the specified string to uppercase letters
6. System and environment functions
  Clipboard :Get the contents of the windows clipboard
  GetApplication :Get the handle of the current application
  CommandParm :If there is a specified parameter when running the application, the value is calculated.
  GetEnvironment :Get information such as the system’s operating system and processor
  Handle :Used to call Windows SDK function
  Post :Insert a message for the specified window at the end of the message queue
  ProfileInt :Retrieves numeric value from the specified profile
  ProfileString :Retrieves a character string from the specified profile
  Restart :Stop script execution, close all windows, disconnect after database commit, and run the application again
  Run :Run the specified application
  Send :Send messages sequentially to the specified window
  SetProfileString :Save the specified profile value
  ShowHelp :You can read the help file and use it in the PowerBuilder application.
  SignalError :System error occurs at the application level
  Yeild :Allows you to check whether a message from another object or application has occurred in the loop.
7. Time processing function
  CPU :Returns the CPU time from the start of the currently running PowerBuilder application to the present
  Idle :Calls the Idle event when the specified time elapses without any input by the user.
  Timer :Timer event call by designating a timer at regular intervals in the designated window
8. Array processing function
  LowerBound :The lower bounds of the specified array
  UpperBound :The upper boundary of the specified array
9. Bolb related functions
  Blob       :Convert or copy text data to blob data
  BlobEdit   :Copy data supported by PB to blob variable
  BlobMid    :Returns the Nth character in a blob data string
  Len        :Length of string
10. DDE client function
  CloseChannel :Closes the channel of the DDE server application opened with the OpenChannel function.
  ExecRemote :Requests the server application to execute a command.
  GetDataDDE :It receives new data from the connected server application.
  GetDataDDEOrigin :It receives the original data from the connected server application.
  GetRemote :Request data from the server application.
  OpenChannel :Open the DDE server application.
  RespondRemote :It tells the server if the command or data has been accepted by the client.
  SetRemote :Let the server application set the specified value.
  StartHotLink :Start a connection with the server application.
  StopHotLink :Terminates the connection to the server application.
11. DDE Server Function
  GetCommandDDE :Get the command sent by the client application.
  GetCommandDDEOrigin :Find out which client application sent the command.
  GetDataDDE :Get the data sent by the client application.
  GetDataDDEOrigin :Find out which client application sent data.
  RespondRemote :It tells the client if the command or data has been accepted by the server.
  SetDataDDE :Send data to the client application.
  StartServerDDE :Make PowerBuilder run as a server.
  StopServerDDE :Stop PowerBuilder from running as a server.
12. File Handling Function
  FileClose :Close file
  FileDelete :Delete files
  FileExists :Presence/absence of file
  FileLength :File length
  FileOpen :Open file
  FileRead :Read file
  FileSeek :Move location in file
  FileWrite :Write to file
  GetFileOpenName :Open file open common dialog
  GetFileSaveName :Open file saving common dialog
13. Library Function
  LibraryCreate :Library creation
  LibraryDelete :Delete library
  LibrarDirectory :Get a list of all objects in the pb library file.
  LibraryExport :Export all objects in the library file.
  LibraryImport :Imports objects from the designated library file.
14. MAPI function
  mailAddress :Gives an address to a mail message or displays a list of addresses.
  mailDELETEMessage :Delete the mail message.
  mailGetMessages :Retrieves the id of the message.
  mailHandle :Retrieves the internal mail system handle.
  mailLogOff :Terminate the session with the messaging system.
  mailLogOn :Start a session with the messaging system.
  mailReadMessage :Read mail messages.
  mailRecipientDetails :Shows the address information of the designated recipient.
  mailResolveRecipient :Determine unclear recipient names.
  mailSaveMessage :Create a new message in the user inbox or replace an existing message.
  mailSend :Send a mail message.
15. Other functions
  Beep :Beeps for a set time (in seconds)
  DBHandle :DBMS handle return
  IsValid :Check if the specified window is open
  KeyDown :Check if the user pressed a specific key
  MesseageBox :Message box output
  PixelsToUnits :Convert Pixel to PowerBuilder’s Unit
  RGB :Returning a Long value representing a specific color
  SetNull :Null regardless of type of variable
  SetPointer :Convert the mouse pointer to a specified shape
  TypeOf :Determining the type of object Checkbox, Picture of RadioButton, etc..
  UnitsToPixels :Convert PowerBuilder’s Unit to Pixel

Good Luck!

Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x