0
What else can I help you with?
What Christmas song or hit has the initials CDBL?
Christmas don't be late from the film Alvin and the chipmunks!
What is the correct coding for converting a string to a double in visual basic 2010?
Dim i as double = CDbl("12")
Explain the need of built-in functions in Visual Basic List out the various built in functions that are available in the latest version?
The built in functions provided by Visual Basic offers a rich set of tools/short-cuts for manipulating strings, numbers, dates and time. Built in functions are important and useful as they cut down the effort and time, of writing the entire program all over again and again. Besides VB supports many mathematical or numeric functions that can make calculations very simple, as one just have to feed in the variables , and get the output after the function processes it. The various built in functions that are available in the latest version (VB-6) are: * Math Functions-Abs(vNumber), Atn(vNumber), Cos(vNumber), Exp(vPower) ,Hex(vNumber), Int(vNumber), Fix(vNumber), Log(vNumber), Oct(vNumber), Rnd(), Sgn(vNumber), Sin(vNumber), Sqr(vNumber), Tan(vNumber). * Conversion Functions-CBool(vVariant), Cbyte(vVariant), Ccur(vVariant), Cdate(vVariant), Cdbl(vVariant), Cint(vVariant), Clng(vVariant), Csng(vVariant), Cstr(vVariant). * String Functions--InStr(sString, sSubString), InStrRev(sString, sSubString), Lcase(sString), Left(sString, iLen), Len(sString), Ltrim(sString), Rtrim(sString), Trim(sString), Mid(sString, iStart, iLen), Replace(sString, sOld, sNew), Right(sString), Space(iLen), StrComp(sString1, sString2), String(iLen, sChar, iLen), StrReverse(sString), Ucase(sString), Asc(sString), Chr(iInteger) * Date and Time Functions-CDate(vVariant), Date(), DateAdd(sType, iInterval, tDate), DateDiff(tDate1, tDate2), DatePart(sType, tDate), DateSerial(iYear, iMonth, iDate), DateValue(vVariant), Day(tDate), FormatDateTime(tDate, iType), Hour(tDate), IsDate(vVariant), Minute(tDate), Month(tDate), MonthName(iMonth), Now(), Second(tDate0, Timer(), TimeSerial(iHour, iMinute, iSecond), TimeValue(tDate), Weekday(tDate), WeekdayName(iWeekDay), Year(tDate) * Array Functions--Array(vArg1, vArg2, …), IsArray(vVariant), Join(aArray), Lbound(aArray), Split(sString, sDelimiter), Ubound(aArray). * Misc. Functions-IsArray(variable), IsDate(variable), IsEmpty(variable), IsNull(variable), IsNumeric(variable), IsObject(variable), TypeName(variable), VarType(vVariant).
A Explain the need of built-in functions in Visual Basic List out the various built in functions that are 1 Explain architecture of Distributed Database systems?
A function that is built into an application and can be accessed by end-users.A function is similar to a normal procedure but the main purpose of the function is to accept a certain input from the user and return a value which is passed on to the main program to finish the execution. There are two types of functions, the built-in functions (or internal functions) and the functions created by the programmers. he general format of a function isFunctionName (arguments) The arguments are values that are passed on to the function.Built -in function are classified under following categories * Math Functions * Conversion Functions * String Functions * Date and Time Functions * Array Functions * Misc. FunctionsMath Functions * Abs(vNumber) - Returns the absolute value of a specified number * Atn(vNumber) - Returns the arctangent of a specified number * Cos(vNumber) - Returns the cosine of a specified number (angle) * Exp(vPower) - Returns e raised to a power * Hex(vNumber) - Returns the hexadecimal value of a specified number * Int(vNumber) - Returns the integer part of a specified number * Fix(vNumber) - Returns the integer part of a specified number * Log(vNumber) - Returns the natural logarithm of a specified number * Oct(vNumber) - Returns the octal value of a specified number * Rnd() - Returns a random number less than 1 but greater or equal to 0 * Sgn(vNumber) - Returns an integer that indicates the sign of a specified number * Sin(vNumber) - Returns the sine of a specified number (angle) * Sqr(vNumber) - Returns the square root of a specified number * Tan(vNumber) - Returns the tangent of a specified number (angle) Conversion Functions * CBool(vVariant) - Converts an expression to a variant of subtype Boolean * CByte(vVariant) - Converts an expression to a variant of subtype Byte * CCur(vVariant) - Converts an expression to a variant of subtype Currency * CDate(vVariant) - Converts a valid date and time expression to the variant of subtype Date * CDbl(vVariant) - Converts an expression to a variant of subtype Double * CInt(vVariant) - Converts an expression to a variant of subtype Integer * CLng(vVariant) - Converts an expression to a variant of subtype Long * CSng(vVariant) - Converts an expression to a variant of subtype Single * CStr(vVariant) - Converts an expression to a variant of subtype StringString Functions * InStr(sString, sSubString) - Returns the position of the first occurrence of one string within another. The search begins at the first character of the string * InStrRev(sString, sSubString) - Returns the position of the first occurrence of one string within another. The search begins at the last character of the string * LCase(sString) - Converts a specified string to lowercase * Left(sString, iLen) - Returns a specified number of characters from the left side of a string * Len(sString) - Returns the number of characters in a string * LTrim(sString) - Removes spaces on the left side of a string * RTrim(sString) - Removes spaces on the right side of a string * Trim(sString) - Removes spaces on both the left and the right side of a string * Mid(sString, iStart, iLen) - Returns a specified number of characters from a string * Replace(sString, sOld, sNew) - Replaces a specified part of a string with another string a specified number of times * Right(sString) - Returns a specified number of characters from the right side of a string * Space(iLen) - Returns a string that consists of a specified number of spaces * StrComp(sString1, sString2) - Compares two strings and returns a value that represents the result of the comparison * String(iLen, sChar, iLen) - Returns a string that contains a repeating character of a specified length * StrReverse(sString) - Reverses a string * UCase(sString) - Converts a specified string to uppercase * Asc(sString) - Converts the first letter in a string to ANSI code * Chr(iInteger) - Converts the specified ANSI code to a character Date and Time Functions * CDate(vVariant) - Converts a valid date and time expression to the variant of subtype Date * Date() - Returns the current system date * DateAdd(sType, iInterval, tDate) - Returns a date to which a specified time interval has been added * DateDiff(tDate1, tDate2) - Returns the number of intervals between two dates * DatePart(sType, tDate) - Returns the specified part of a given date * DateSerial(iYear, iMonth, iDate) - Returns the date for a specified year, month, and day * DateValue(vVariant) - Returns a date * Day(tDate) - Returns a number that represents the day of the month (between 1 and 31, inclusive) * FormatDateTime(tDate, iType) - Returns an expression formatted as a date or time * Hour(tDate) - Returns a number that represents the hour of the day (between 0 and 23, inclusive) * IsDate(vVariant) - Returns a Boolean value that indicates if the evaluated expression can be converted to a date * Minute(tDate) - Returns a number that represents the minute of the hour (between 0 and 59, inclusive) * Month(tDate) - Returns a number that represents the month of the year (between 1 and 12, inclusive) * MonthName(iMonth) - Returns the name of a specified month * Now() - Returns the current system date and time * Second(tDate0 - Returns a number that represents the second of the minute (between 0 and 59, inclusive) * Time() - Returns the current system time * Timer() - Returns the number of seconds since 12:00 AM * TimeSerial(iHour, iMinute, iSecond) - Returns the time for a specific hour, minute, and second * TimeValue(tDate) Returns a time * Weekday(tDate) - Returns a number that represents the day of the week (between 1 and 7, inclusive) * WeekdayName(iWeekDay) - Returns the weekday name of a specified day of the week * Year(tDate) - Returns a number that represents the yearArray Functions * Array(vArg1, vArg2, ...) - Returns a variant containing an array * IsArray(vVariant) - Returns a Boolean value that indicates whether a specified variable is an array * Join(aArray) - Returns a string that consists of a number of substrings in an array * LBound(aArray) - Returns the smallest subscript for the indicated dimension of an array * Split(sString, sDelimiter) - Returns a zero-based, one-dimensional array that contains a specified number of substrings * UBound(aArray) - Returns the largest subscript for the indicated dimension of an arrayMisc. Functions * IsArray(variable) - Returns True if the specified variable is an array * IsDate(variable) - Returns True if the specified variable can be converted to a date * IsEmpty(variable) - Returns True if the specified variable is Empty * IsNull(variable) - Returns True is the specified variable is Null * IsNumeric(variable) - Returns True if the specified variable can be converted to a number * IsObject(variable) - Returns True if the specified variable is an object * TypeName(variable) - Returns the type name of the specified variable * VarType(vVariant) - Returns the type code of the specified variable
What are some VBS commands?
VBS Commands A-Z A Abs(number) Absolute (positive) value of number .AppActivate Activate running command Array(el1,el2,el3) Add values to an Array variable Arguments.Item .Count and .length Asc(String) Return ASCII code for string AscB(String) Return Byte code for string AscW(String) Return Unicode code for string .BrowseForFolder Prompt the user to select a folder c Call subroutine (arguments) or subroutine arguments CBool(expression) Convert expression to Boolean (True/False) CByte(expression) Convert expression to Byte (0-255) CCur(expression) Convert expression to Currency (numeric) CDate(expression) Convert expression to Date CDbl(expression) Convert expression to Double (up to 1.79x10308) Chr(ChrCode) Return the string character for ChrCode (ASCII code) ChrB(ChrCode) Return the string character for ChrCode (Byte code) ChrW(ChrCode) Return the string character for ChrCode (Unicode/DBCS) CInt(expression) Convert expression to Integer .CreateObject Create a WSH automation object .CreateShortcut Create Shortcut cscript Run a VBScript .vbs file d Date() The current system date DateAdd Add a time interval to a Date DateDiff Return the time interval between two dates DatePart Return a unit of time from a date DateSerial Return a Date from a numeric Year, Month and Day DateValue Return a Date from a string expression Day(date) Return the day component of date (1-31) Dim Declare a new variable or array variable Do..Loop Repeat a block of statements Drives Drive Map .MapNetworkDrive - .Enum - .Remove e .Echo Echo text to screen, also StdOut.Write /.Popup End End a procedure or code block Environment Variables - Expand - .Delete/Remove Escape(String) Return only ASCII characters from a Unicode string. Eval(expr) Evaluate an expression .Exec Run a command Exp(n) Return e (base of natural logs) raised to a power n. Exit Exit a block of code immediately f FileSystemObject Work with Drives, Folders and Files Filter Produce an array by filtering an existing array Fix(number) Return the integer portion of a number (negative numbers round up) For...Next Repeat a block of statements a given number of times For Each... Loop through the items in a collection or array FormatCurrency Format a number with a currency symbol FormatNumber Format a number FormatPercent Format a number with a % symbol FormatDateTime Format a Date/Time value Function Define a function procedure g GetLocale() Return the Regional LocaleID .GetObject Get an Automation object Hex(number) Return the hex value of number Hour(time) Return the hour component of time i If..Then Conditionally execute a block of statements InputBox Prompt for user input InStr Find one string within another InStrRev Find one string within another, starting from the end Int(number) Return the integer portion of a number (negative numbers round down) IsArray(varname) Is varname an array? True/False IsDate(expression) Is expression a DateTime? True/False IsEmpty(expression) Is expression empty? True/False IsNull(expression) Is expression a DateTime? True/False IsNumeric(expression) Is expression a Numeric? True/False IsObject(expression) Is expression an object? True/False l LCase(String) Return String in lower case Left(String,len) Return the leftmost len characters of string LeftB(String,len) Return the leftmost len bytes of string Len(String) Return length of string in characters LenB(String) Return length of string in Bytes Log(number) Return natural log of number .LogEvent Log an item in the Event log LTrim(String) Remove any leading spaces from a string expression m .MapNetworkDrive Drive Map Mid Return a mid-section from a string Minute(time) Return the minute component of time Month(date) Return the month component of date MonthName Convert a month number to a descriptive Month MsgBox Display a dialogue box message Now() Return the current Date and Time o On Error Error handling Option Explicit Force all variables to be defined p .AddPrinterConn / .AddWindowsPrConn Add Printer connection .EnumPrinterConnections List Printer connections .SetDefaultPrinter Set default printer .RemovePrinterConnection Remove printer connection Private VarName Declare a local variable/array variable Public VarName Declare a public variable/array variable q .Quit Quit r Randomize(number) Initialise the random number generator .ReadLine Accept user text input ReDim Resize a dynamic array RegExp Regular expression search object .RegDelete Registry, delete .RegRead Registry, read .RegWrite Registry, write Replace Find and replace text Right(String,len) Return the rightmost len characters of string RightB(String,len) Return the rightmost len bytes of string RGB(Red,Green,Blue) Return a system color code Rnd Return a random number Round Round a number to n decimal places RTrim(String) Remove any trailing spaces from a string expression .Run a command s Second(time) Return the second component of time Select...Case Conditionally execute a block of statements .SendKeys Set variable = object Assign an object reference SetLocale(LocaleID) Set the Regional LocaleID Sgn(number) The sign of a number Shell.CurrentDirectory Retrieve or change the current directory Shortcut create .CreateShortcut .Sleep .SpecialFolders Path to Desktop,Start menu, Programs... Split Parse a string of delimited values into an array Sqr(number) Square root StrComp Compare two strings String Create a string with a single character repeated StrReverse Reverse a string Sub Start a subprocedure t Time() The current system time Timer() The number of seconds since midnight TimeSerial Construct a Time value from Hours, Minutes and seconds TimeValue Convert a string to a Time value Trim(String) Remove leading and trailing spaces from string u UBound Return the largest subscript for an array dimension UCase(String) Uppercase String UnEscape(Str) Return Unicode characters from an escaped ASCII string w Weekday Return the day of the week (1-7) WeekdayName Return the named day of the week While...Wend Conditionally repeat a block of statements With Assign multiple properties of an object wscript.Name Wscript properties: name, version, mode Year(date) Return the year component of date (1-12)
