Información para Programadores
Manual del sistema de gestión para Windows de EGA Futura
Herramientas

Información para Programadores

¿Puedo comercializar este sistema entre mis clientes?

Claro que sí.

En EGA Futura contamos con un programa para Partners, que puedes conocer aquí

¿Puedo ofrecer servicios de valor agregado?

Por supuesto que sí.

Nuestros partners cobran aproximadamente u$s 25 por hora de trabajo.

Los principales servicios que podrás ofrecer con:

  • Instalación
  • Capacitación de uso
  • Configuración de formularios pre-impresos
  • Creación de consultas en Microsoft Access
  • Desarrollo de aplicaciones complementarias
En EGA Futura recibimos unos 60.000 usuarios nuevos todos los años, y a los Partners con mejores calificaciones, les derivamos clientes de manera continua

¿Puedo programar aplicaciones que complementen el uso del sistema?

Claro que sí, nos encanta eso :)

No solamente contaras con nuestra ayuda para realizar consultas puntuales, sino que promocionaremos tu aplicación entre nuestra inmensa y creciente base de usuarios,

¿Cuentan con un AppStore?

Próximamente, lanzaremos un AppStore en donde podrás publicar y promocionar tus aplicaciones.

Información Técnica para programadores y técnicos

Desde aquí contestamos las preguntas más frecuentes que todos los programadores, developers y usuarios con un muy alto perfil técnico realizan de manera cotidiana

¿En qué lenguaje está programado StockBase POS?

Nuestro software de facturación para Windows, está programado en Visual Objects Microsoft C++.

¿Qué motor de Base de Datos utiliza el sistema?

El motor de bases de datos es DBF/CDX.

Estos archivos se pueden abrir con Microsoft Access, FoxBASE+, FoxPro, Visual FoxPro y editores de bases de datos como DBFManager.co

¿Es posible modificar los reportes, listados e informes?

El sistema no dispone de ninguna opción que internamente permita de manera simple hacer la modificación de reportes (nuestro ERP en la Nube si lo hace).

Como alternativa, se pueden crear consultas en Microsoft Access:

 

¿Dispone el software de facturación de un API o Web Service?

Nuestro Sistema de Gestión Comercial para Windows no dispone de un API o servicio web.

Quienes necesiten conectarse a la base de datos para realizar un proceso de lectura, deberán hacerlo accediendo directamente al grupo de archivos DBF.

Aquellos programadores que necesiten una integración más sólida mediante un API, pueden hacerlo con nuestro sistema ERP en la Nube, que sí dispone de ella

¿Donde podemos hacer preguntas?

Todos los programadores que deseen realizar preguntas ultra-tecnicas, pueden hacerlo desde este lugar: 

http://ayuda.EGAFutura.com/forum/86-partners-y-programadores

Formulas y Funciones de ReportPro

ReportPro es la tecnología utilizada para todos los reportes del sistema, tanto los listados de información, como así también todos los comprobantes de venta.

Aquí se encuentra la información de las fórmulas que podrás utilizar al modificar el diseño de los formularios pre-impresos.

Abs()

Propósito

To calculate the absolute value of a number

 

Sintaxis

Abs( <nNumber> )  nAbsValue

 

Argumento

<nNumber> is the number to determine the absolute value of

 

Retorna

Abs() Retorna the absolute value of <nNumber>.

AddressBlk()

Propósito

To format an address for printing

 

Sintaxis

AddressBlk( <cName>, <cAddress1>, <cAddress2>, <cCity>, <cState>, <cZip> )  cAddressString

 

Argumentos

<cName> The recipient's name

<cAddress1>  Address line 1

<cAddress2> Address line 2

<cCity> The city name

<cState> The state

<cZip> The zip code

 

Retorna

AddressBlk() creates an address block string based on the Argumentoos passed.  Blank Argumentoos are ignored.

Alltrim()

Propósito

To remove leading and trailing spaces from a character string

 

Sintaxis

Alltrim( <cString> )  cTrimString

 

Argumento

<cString> is the character string to trim spaces from

 

Retorna

Alltrim() Retorna a character string with leading and trailing spaces removed.

Asc()

Propósito

To determine the ASCII value of a character

 

Sintaxis

Asc( <cCharacter> )  nNumber

 

Argumento

<cCharacter> is the character to determine the ASCII value of

 

Retorna

Asc() Retorna the ASCII value of  <cCharacter>.

At()

Propósito

To determine the position of a string within another string

 

Sintaxis

At( <cSearchFor>, <cSearchIn> )  nLocation

 

Argumento

<cSearchFor> is the character string to search for

<cSearchIn> is the character string to search

 

Retorna

At() Retorna a numeric indicating the location of <cSearchFor> within <cSearchIn>.  If <cSearchFor> is not found, At() Retorna 0.

AtNoCase()

Propósito

To determine the position of a string within another string without regard for case

 

Sintaxis

AtNoCase( <cSearchFor>, <cSearchIn> )  nLocation

 

Argumentos

<cSearchFor> is the character string to search for

<cSearchIn> is the character string to search

 

Retorna

AtNoCase() Retorna a numeric indicating the location of <cSearchFor> within <cSearchIn >.  If <cSearchFor > is not found, AtNoCase() Retorna 0.

AtLineNum()

Propósito

To determine the line number of a string within a multi-line string

 

Sintaxis

AtLineNum(<cSearchFor>, <cSearchIn> )  nNumber

 

Argumento

<cSearchFor> is the character string to search for

<cSearchIn> is the character string to search

 

Retorna

AtLineNum() Retorna a numeric indicating the line number of <cSearchFor> within <cSearchIn>.  If <cSearchFor> is not found, AtLineNum() Retorna 0.

AtLineNoCase()

Propósito

To determine the line number of a string within a multi-line string without regard for case

 

Sintaxis

AtLineNoCase(<cSearchFor>, <cSearchIn> )  nNumber

 

Argumentos

<cSearchFor> is the character string to search for

<cSearchIn> is the character string to search

 

Retorna

AtLineNoCase() Retorna a numeric indicating the line number of <cSearchFor> within <cSearchIn>.  If <cSearchFor> is not found, AtLineNoCase() Retorna 0.

CDOW()

Propósito

To convert a date value to a character day of the week

 

Sintaxis

CDOW( <dDate> )  cDayName

 

Argumento

<dDate> is the date to convert

 

Retorna

CDOW() Retorna the name of the day of the week as a character string.

Ceiling()

Propósito

To round a number up to the highest integer

 

Sintaxis

Ceiling( <nNumber> )  nRoundedNumber

 

Argumento

<nNumber> is the number to round

 

Retorna

Ceiling() Retorna <nNumber> rounded up to the next highest integer.

Chr()

Propósito

To convert a numeric to a character

 

Sintaxis

Chr( <nNumber> )  cCharacter

 

Argumento

<nNumber> is the ASCII number to convert to a character

 

Retorna

Chr() Retorna the character representation of <nNumber>.

CMonth()

Propósito

Convert a date to a character month name

 

Sintaxis

CMonth( <dDate> )  cMonth

 

Argumento

<dDate> is the date to convert.

 

Retorna

CMonth() Retorna the name of the month as a character string.

Cosine()

Propósito

To calculate the cosine of a number

 

Sintaxis

Cosine( <nAngle> )  nCosine

 

Argumento

<nAngle> is an angle in radians

 

Retorna

Cosine() Retorna the cosine of <nAngle>.

Cotangent()

Propósito

To calculate the cotangent of a number

 

Sintaxis

Cotangent(<nAngle> )  nCotangent

 

Argumento

<nAngle> is an angle in radians

 

Retorna

Cotangent() Retorna the cotangent of <nAngle>.

CTOD()

Propósito

To convert a character value to a date

 

Sintaxis

CTOD( <cDate> )  dDate

 

Argumento

<cDate> is a character string consisting of numbers representing month, day, and year digits separated by the "/" character.  <cDate> must be expressed as "mm/dd/yy" or "mm/dd/yyyy".

 

Retorna

CTOD() Retorna the date equivalent of <cDate>.

Day()

Propósito

To calculate the day of the month as a numeric value.

 

Sintaxis

Day( <dDate> )  nDay

 

Argumento

<dDate> is the date to convert.

 

Retorna

Day() Retorna a number in the range of 1 to 31 as a numeric value.

Descend()

Propósito

To create a descending order key value

 

Sintaxis

Descend( <cString> )  cInvertedValue

 

Argumento

<cString> is the string to calculate the descending value for

 

Retorna

Descend() Retorna an inverted <cString>.

DOW()

Propósito

Convert a date value to a numeric day of the week

 

Sintaxis

DOW( <dDate> )  nDay

 

Argumento

<dDate> is the date to convert.

 

Retorna

DOW() Retorna the day of the week as a number between 1 and 7.

DTOC()

Propósito

To convert a date value to a character string

 

Sintaxis

DTOC( <dDate> )  cDate

 

Argumento

<dDate> is the date value to convert

 

Retorna

DTOC Retorna a character string in the format "mm/dd/yy" that represents <dDate>.

DTOS()

Propósito

To convert a date value to a character string

 

Sintaxis

DTOS( <dDate> )  cDate

 

Argumento

<dDate> is the date value to convert

 

Retorna

DTOS Retorna a character string in the format "yyyymmdd" that represents <dDate>.

ElapsedTime()

Propósito

To calculate the interval between two times

 

Sintaxis

ElapsedTime( <cTime1>, <cTime2> )  cTimeDifference

 

Argumentos

<cTime1> is the starting time

<cTime2> is the ending time

 

Retorna

ElapsedTime() Retorna the amount of time that has elapsed from <cTime1> to <cTime2> as a time string in the format hh:mm:ss.

Empty()

Propósito

To determine if a field or variable contains a empty value

 

Sintaxis

Empty( <xValue> )  lResult

 

Argumento

<xValue> is the value to check and can be any data type.

 

Retorna

Empty() Retorna true if the value is empty; otherwise, it Retorna false.

GroupMembers()

Propósito

To determine the number of members in a grouping.

 

Sintaxis

GroupMembers( <nGroup> )  nNumber

 

Argumento

<nGroup> is the group to query.

 

Retorna

GroupMembers() Retorna the number of members in <nGroup> group as a numeric value.

HardCR()

Propósito

To replace all soft carriage Retorna (chr(141)) with hard carriage Retorna (chr(13))

 

Sintaxis

HardCR( <cString> )  cHardCRString

 

Argumento

<cString> is the string containing the soft carriage Retorna

 

Retorna

HardCR() Retorna a string where all soft carriage Retorna are replaced with hard carriage Retorna.

HoursBetween()

Propósito

To calculate the hours between two date/time values

 

Sintaxis

HoursBetween( <dDate1>, <cTime1>, <dDate2>, <cTime2>, <lWeekEnds> )  nNumber

 

Argumentos

<dDate1> The starting date

<cTime1> The starting time as character string formatted as "hh:mm:ss" (24 hour format)

<dDate2> The ending date

<cTime2> The ending time as character string formatted as "hh:mm:ss" (24 hour format)

<lWeekEnds>  A logical indicating whether or not to count weekends

 

Retorna

HoursBetween() Retorna the number of hours between <cTime1> on <dDate1> and <cTime2> on <dDate2>.  The first date/time value must be smaller of the two.

iif()

Propósito

To return the result of an expression based on a condition

 

Sintaxis

iif( <lCondition> , <expTrue> , <expFalse> )  xValue

 

Argumentos

<lCondition> is a logical expression to be evaluated.

<expTrue> is the value, of any data type, returned if <lCondition> is true.

<expFalse> is the value, of any data type, returned if <lCondition> is false.

 

Retorna

iif() Retorna the evaluation of <expTrue> if <lCondition> evaluates to true and <expFalse> if it evaluates to false.

Integer()

Propósito

To truncate a number with decimal digits to a whole number

 

Sintaxis

Integer( <nNumber> )  nInteger

 

Argumentos

<nNumber> is the decimal number to convert to an integer

 

Retorna

Integer() Retorna <nNumber> truncated to an integer.

IsAlpha()

Propósito

To determine if the first character of a string is alphabetic

 

Sintaxis

IsAlpha( <cString> )  lLogical

 

Argumentos

<cString> is the string to test

 

Retorna

IsAlpha() Retorna TRUE if the first character in <cString> is an alphabetic (A-Z, a-z) character.

IsBetween()

Propósito

To determine if a number is between two other numbers

 

Sintaxis

IsBetween( <nTestNumber>, <nLowerLimit>, <nUpperLimit> )  lLogical

 

Argumentos

<nTestNumber> is the number to test

<nLowerLimit> is the lower limit to test against

<nUpperLimit> is the upper limit to test against

 

Retorna

IsBetween() Retorna TRUE if <nTestNumber> is between <nLowerLimit> and <nUpperLimit>.

IsDigit()

Propósito

To determine if the first character of a string is a numeric digit

 

Sintaxis

IsDigit( <cString> )  lLogical

 

Argumentos

<cString> is the string to test

 

Retorna

IsDigit() Retorna TRUE if the first character in <cString> is a digit (0-9).

IsLower()

Propósito

To determine if the first character of a string is lower case

 

Sintaxis

IsLower( <cString> )  lLogical

 

Argumentos

<cString> is the string to test

 

Retorna

IsLower() Retorna TRUE if the first character in <cString> is lower case (a-z).

IsUpper()

Propósito

To determine if the first character of a string is upper case

 

Sintaxis

IsUpper( <cString> )  lLogical

 

Argumento

<cString> is the string to test

 

Retorna

IsUpper() Retorna TRUE if the first character in <cString> is upper case (A-Z).

Left()

Propósito

To extract a substring beginning with the first character in a string

 

Sintaxis

Left( <cString> , <nCharacters> )  cSubString

 

Argumentos

<cString> is a character string from which to extract characters.

<nCharacters> is number of characters to extract beginning with the leftmost character.

 

Retorna

Left() Retorna a substring of <nCharacters> from <cString> starting at the leftmost character.

Len()

Propósito

To calculate the length of a character string

 

Sintaxis

Len( <cString> )  nLength

 

Argumento

<cString> is the character string to determine the length of

 

Retorna

Len() Retorna the length (in characters) of <cString>.

Log()

Propósito

To calculate the natural logarithm of a number

 

Sintaxis

Log( <nNumber> )  nLogarithm

 

Argumento

<nNumber> is a number greater than 0

 

Retorna

Log() Retorna the natural logarithm of <nNumber>.

Lower()

Propósito

To convert upper case characters to lower case

 

Sintaxis

Lower( <cString> )  cLowerCase

 

Argumento

<cString> is the string to convert to lower case.

 

Retorna

Lower() Retorna the lower cased equivalent of <cString>.

LTrim()

Propósito

To remove leading spaces from a character string

 

Sintaxis

LTrim( <cString> )  cTrimmed

 

Argumento

<cString> is the character string to trim.

 

Retorna

LTrim() Retorna <cString> without leading spaces

Max()

Propósito

To determine the larger of two numeric or date values

 

Sintaxis

Max( <dnValue1> , <dnValue2> )  dnMaxValue

 

Argumento

<dnValue1> and <dnValue2> are the date or numeric values to compare.  They must be the same data type.

 

Retorna

Max() Retorna the maximum value of <dnValue1> and <dnValue2>.

MakeDate()

Propósito

To create a date from three numerics representing a year, month and day.

 

Sintaxis

MakeDate( <nYear> , <nMonth>, <nDay> )  dDate

 

Argumentos

<nYear> is the year of the new date

<nMonth> is the month of the new date

<nDay> is the day of the new date

 

Retorna

MakeDate() Retorna a date that represents <nYear>, <nMonth> and <nDay>.

MakeTime()

Propósito

To create a time string from three numerics representing hours, minutes and seconds.

 

Sintaxis

MakeTime( <nHours> , <nMinutes>, <nSeconds> )  cTime

 

Argumentos

<nHours> is the hour of the new time

<nMinutes> is the minutes of the new time

<nSeconds> is the seconds of the new time

 

Retorna

MakeTime() Retorna a string in the format "hh:mm:ss".

MemoLine()

Propósito

To extract a line of text from a multi-line string

 

Sintaxis

MemoLine( <cString> , <nLineLength>, <nLineNumber>, <nTabSize>, <lWrap> )  cText

 

Argumentos

<cString> is the string to extract the line of text from

<nLineLength> is the default line length in characters

<nLineNumber> is the line number to extract

<nTabSize> is the tab size in characters

<lWrap> is TRUE to turn on word wrap, FALSE to turn it off

 

Retorna

MemoLine() Retorna the <nLineNumber> line of text if it exists in <cString>.

MemoTran()

Propósito

To replace carriage return and linefeed characters with a character that can be displayed

 

Sintaxis

MemoTran( <cString> , <cHardCR>, <cSoftCR> )  cText

 

Argumentos

<cString> is the string that contains the carriage return and linefeed characters

<cHardCR> is the character to replace hard carriage Retorna with

<cSoftCR> is the character to replace soft carriage Retorna with

 

Retorna

MemoTran() Retorna a string with the carriage Retorna and linefeeds replaced

Min()

Propósito

To determine the smaller of two numeric or date values

 

Sintaxis

Min( <dnValue1> , <dnValue2> )  dnMinValue

 

Argumento

<dnValue1> and <dnValue2> are the date or numeric values to compare.  They must be the same data type.

 

Retorna

Min() Retorna the minimum value of <dnValue1> and <dnValue2>.

MLCount()

Propósito

To determine the number of lines in a string

 

Sintaxis

MLCount( <cString> , <nLineLength>,  <nTabSize>, <lWrap> )  cText

 

Argumentos

<cString> is the string to determine the number of lines for

<nLineLength> is the default line length in characters

<nTabSize> is the tab size in characters

<lWrap> is TRUE to turn on word wrap, FALSE to turn it off

 

Retorna

MLCount() Retorna the number of lines in <cString>.

Modulus()

Propósito

To determine the remainder of a division operation

 

Sintaxis

Modulus( <nDividend> , <nDivisor> )  nRemainder

 

Argumentos

<nDividend> The dividend of the division operation

<nDivisor> The divisor of the division operation

 

Retorna

Modulus() Retorna the remainder of <nDividend> divided by <nDivisor>.

MinutesBetween()

Propósito

To determine the number of minutes between two date/time values.

 

Sintaxis

MinutesBetween( <dDate1>, <cTime1>, <dDate2>, <cTime2>, <lWeekEnds> )  nNumber

 

Argumento

<dDate1> The starting date

<cTime1> The starting time as character string formatted as "hh:mm:ss" (24 hour format)

<dDate2> The ending date

<cTime2> The ending time as character string formatted as "hh:mm:ss" (24 hour format)

<lWeekEnds> A logical indicating whether or not to count weekends.

 

Retorna

MinutesBetween() Retorna the number of minutes between <cTime1> on <dDate1> and <cTime2> on <dDate2>.  The first date/time value must be the smaller of the two.

Month()

Propósito

To convert a date value to a month number

 

Sintaxis

Month( <dDate> )  nMonth

 

Argumento

<dDate> is the date to convert.

 

Retorna

Month() Retorna a numeric value in the range of 1 to 12 representing the month of <dDate>.

Num2CDOW()

Propósito

To convert a numeric day number to a character day of the week string

 

Sintaxis

Num2CDOW( <nDay> )  cDayName

 

Argumento

<nDay> is the number (1-7) to convert into the day name

 

Retorna

Num2CDOW() Retorna a character day name.

Num2CMonth()

Propósito

To convert a numeric month number to a character month name

 

Sintaxis

Num2CMonth( <nMonth> )  cMonthName

 

Argumento

<nMonth> is the number (1-12) to convert into the month name

 

Retorna

Num2CMonth() Retorna a character month name.

NumTrim()

Propósito

Retorna the number passed as a left-trimmed string

 

Sintaxis

NumTrim( <nNumber> )  cString

 

Argumento

<nNumber> is the number to convert to a string

 

Retorna

NumTrim() Retorna the value <nNumber> as a left-trimmed string.

OccursIn()

Propósito

To determine how many time one string occurs in another

 

Sintaxis

OccursIn( <cSearchFor>, <cSearchIn> )  nTimes

 

Argumentos

<cSearchFor> is the string to search for

<cSearchIn> is the string to search

 

Retorna

OccursIn() Retorna the number of times <cSearchFor> occurs in <cSearchIn>.

Pad()

Propósito

To pad character, date and numeric values with spaces

 

Sintaxis

PadC( <xValue> , <nLength>, <cPadChar> )  cPaddedString

PadL( <xValue> , <nLength>, <cPadChar> )  cPaddedString

PadR( <xValue> , <nLength>, <cPadChar> )  cPaddedString

 

Argumentos

<xValue> is the character, date or numeric value to pad

<nLength> is the length of the string to return

<cPadChar> is the character to pad with

 

Retorna

PadC() Retorna <xValue> as a character string of length <nLength> centered between <cPadChar>.  PadL() Retorna <xValue> as a character string of length <nLength> padded with <cPadChar> on the left side. PadR() Retorna <xValue> as a character string of length <nLength> padded with <cPadChar> on the right side.

Power()

Propósito

To raise a number by a power

 

Sintaxis

Power( <nNumber>, <nExponent> )  nTimes

 

Argumentos

<nNumber> is the base number

<nExponent> is the power to raise the base number by

 

Retorna

Power() Retorna <nNumber> raised to the power of <nExponent>.

PgCount()

Propósito

To retrieve the ReportPro page count.

 

Sintaxis

PgCount()  nCount

 

Retorna

PgCount() Retorna the internal ReportPro page number count.  This function will only return a meaningful value if the "Support Total Page Count" option is set in the Report Configuration dialog.

PgNo()

Propósito

To retrieve the ReportPro page number

 

Sintaxis

PgNo()  nPage

 

Retorna

PgNo() Retorna the internal ReportPro page number.

Properize()

Propósito

To change the first character of each word in a string to upper case

 

Sintaxis

Properize( <cString> )  cProperString

 

Argumento

<cString> is the string to modify

 

Retorna

Properize() Retorna <cString> with the first character of each word in uppercase.

Rand()

Propósito

To retrieve a random number between 0 and 1

 

Sintaxis

Rand( <nSeedNumber> )  nRandomNumber

 

Argumentos

<nSeedNumber> is a number used to seed the random number generator

 

Retorna

Rand() Retorna a random number.

RAt()

Propósito

To retrieve the last position of one string within another

 

Sintaxis

RAt( <cSearchFor>, <cSearchIn> )  nLocation

 

Argumentos

<cSearchFor> is the string to search for

<cSearchIn> is the string to search

 

Retorna

RAt() Retorna the last location of <cSearchFor> in <cSearchIn>.

Replicate()

Propósito

To create a string by repeating another string

 

Sintaxis

Replicate( <cString>, <nTimes> )  cNewString

 

Argumentos

<cString> is the string to repeat

<nTimes> is the number of times to repeat <cString>

 

Retorna

Replicate() Retorna <cString> repeated <nTimes>.

Right()

Propósito

To retrieve a substring beginning with the rightmost character

 

Sintaxis

Right( <cString> , <nCount> )  cSubString

 

Argumentos

<cString> is the character string from which to extract characters.

<nCount> is the number of characters to return.

 

Retorna

Right() Retorna the rightmost <nCount> characters of <cString>.

Round()

Propósito

To return a numeric value rounded to a specified number of digits.

 

Sintaxis

Round( <nNumber> , <nDecimals> )  nRounded

 

Argumentos

<nNumber> is the numeric value to round.

<nDecimals> is the number of decimals places to retain.

 

Retorna

Round() Retorna a numeric value rounded to <nDecimals> decimals.

RpEOF()

Propósito

To return a logical indicating if ReportPro has reached the end of the report.

 

Sintaxis

RpEOF()  lEOF

 

Retorna

RpEOF() Retorna TRUE if ReportPro has finished processing all records in the report.

RpSQLCol()

Propósito

To retrieve a SQL column value by column position number.

 

Sintaxis

RpSQLCol( <nColumn> )  xColumnValue

 

Argumento

<nColumn> is the number of the column to retrieve

 

Retorna

RpSQLCol() Retorna the value of the column that occupies the <nColumn> position in the SQL select statement.

Sec2Days()

Propósito

To convert seconds to days

 

Sintaxis

Sec2Days( <nSeconds> )  nDays

 

Argumento

<nSeconds> is the number of seconds to convert to days

 

Retorna

Sec2Days() Retorna <nSeconds> converted to days.

Sine()

Propósito

To calculate the sine of a number

 

Sintaxis

Sine( <nAngle> )  nSine

 

Argumento

<nAngle> is the angle in radians

 

Retorna

Sine() Retorna the sine of <nAngle>.

Space()

Propósito

To return a string of spaces

 

Sintaxis

Space( <nCount>)  cString

 

Argumento

<nCount> is the number of spaces to return.

 

Retorna

Space() Retorna a string of <nCount> spaces.

SqRt()

Propósito

To calculate the square root of a positive number

 

Sintaxis

SqRt( <nNumber> )  nRoot

 

Argumento

<nNumber> is the positive number to calculate the square root of

 

Retorna

SqRt() Retorna the square root of <nNumber>.

Str()

Propósito

To convert a numeric expression to a character string

 

Sintaxis

Str( <nNumber> , <nLength> , <nDecimals> )  cNumber

 

Argumentos

<nNumber> is the numeric value to convert

<nLength> is the length of string to return including decimals and decimal point

<nDecimals> number of decimals to return

 

Retorna

Str() Retorna <nNumber> formatted as a character string.

StrTran()

Propósito

To search and replace characters in a string

 

Sintaxis

StrTran( <cSearchFor> , <cSearchIn> , <cReplaceWith>, <nStart>, <nCount> )  cNewString

 

Argumentos

<cSearchFor> is the character string to search for

<cSearchIn> is the character string to search

<cReplaceWith> is the character string to replace <cSearchFor> with

<nStart> is the first occurrence of <cSearchFor> to replace

<nCount> is the number of replacements to make

 

Retorna

StrTran() Retorna <cSearchIn> where <cSearchFor> is replaced with <cReplaceWith>.

Stuff()

Propósito

To insert and delete characters from a string

 

Sintaxis

Stuff( <cString> , <nStart> , <nDelete>, <cInsert> )  cModifiedString

 

Argumentos

<cString> is the character string to modify

<nStart> is the character position where the delete/insert begins

<nDelete> is the number of characters to delete

<cInsert> is the character string to insert at <nStart>

 

Retorna

Stuff () Retorna <cString> with characters deleted or inserted at <nStart>.

SubStr()

Propósito

To extract a substring from a character string

 

Sintaxis

SubStr( <cString> , <nStart> , <nCount> )  cSubString

 

Argumentos

<cString> is the character string in which to extract a substring

<nStart> is the starting position in <cString>

<nCount> is the number of characters to extract

 

Retorna

SubStr() Retorna a substring of <cString>.

Tangent()

Propósito

To calculate the tangent of a number

 

Sintaxis

Tangent( <nAngle> )  nTangent

 

Argumento

<nAngle> is the angle in radians

 

Retorna

Tangent() Retorna the tangent of <nAngle>.

Time()

Propósito

To retrieve the system time

 

Sintaxis

Time()  cTimeString

 

Retorna

Time() Retorna the system time as a character string in the form "hh:mm:ss".

Today()

Propósito

To retrieve the computer clock date.

 

Sintaxis

Today()  dSystemDate

 

Retorna

Today() Retorna the system clock date as a date value.

Trim()

Propósito

To remove the trailing spaces from a string

 

Sintaxis

Trim( <cString> )  cTrimmedString

 

Argumento

<cString> is the string to remove the spaces from

 

Retorna

Trim() Retorna <cString> with the rightmost spaces removed.

Upper()

Propósito

To convert lower case characters to upper case

 

Sintaxis

Upper( <cString>)  cUpperString

 

Argumento

<cString> is the character string to convert

 

Retorna

Upper() Retorna a copy of <cString> with all alphabetic characters converted to uppercase.

Val()

Propósito

To convert a character number to numeric type

 

Sintaxis

Val( <cNumber>)  nNumber

 

Argumentos

<cNumber> is the character string to convert.

 

Retorna

Val() Retorna <cNumber> converted to a numeric value including decimal digits

Year()

Propósito

To retrieve the year from a date

 

Sintaxis

Year( <dDate>)  nYear

 

Argumentos

<dDate> is the date to determine the year from

 

Retorna

Year() Retorna the year of the specified date

Busca aquí lo que necesites :)

Busqueda soporte tecnico

Ingresa tu pregunta, y accederás de manera instantánea a miles de preguntas y respuestas sobre nuestro software de gestión. 

Todo lo que necesites saber, lo encontrarás aquí. 

Continúa aprendiendo

# 1
Estamos en el Puesto 1 en Softonic desde hace media década ininterrumpida
24x7
Desde nuestra comunidad ofrecemos soporte técnico todos los días
+60.000
Más de sesenta mil empresas instalan nuestro software todos los años
1994
Desde hace más de 20 años potenciamos a las PyMEs de Iberoamérica

¿Este software incluye soporte técnico gratuito?

Claro que sí.

Ofrecemos soporte gratis en todas las ediciones de nuestro sistema para empresas. Para conocer las diferentes alternativas de soporte visita este link.

Todas las preguntas realizadas en nuestra plataforma de Soporte Técnico 24/7 se responden siempre en el mismo día, usualmente en horas.

¿Para qué países funciona este software?

Este sistema de gestión empresarial funciona según las reglamentaciones fiscales de España, México, Colombia, Chile, Argentina y el resto de los países de América Latina.

Si tu empresa está en otro país, re recomendamos usar nuestro software ERP en la nube.

¿Puedo ejecutar el sistema en dispositivos móviles o desde Internet?

StockBase POS funciona en Windowx XP, Windows Vista, Windows 7, Windows 8, Windows 10 y Windows Server solamente.

Para empresas con 10 o más usuarios tenemos un ERP en la nube que funciona también en Linux, Mac, iPhone, iPad, y Android.

¿Desde dónde puedo descargar la última versión?

Para descargar la última versión de nuestro sistema de gestión empresarial para Windows, pulsa aquí.

Ya he descargado el programa... ¿Cómo obtengo una licencia?

Para obtener una licencia para las Ediciones Gratis o Power del software, sigue las instrucciones detalladas en este lugar.

El programa instalador es el mismo para ambas ediciones.

No me llega la licencia por correo de la Edición Gratis... ¿Qué hago?

Si ya has completado el formulario para obtener la Edición Gratis de StockBase POS, y luego de esperar al menos 12 minutos tu licencia no llega:

Verifica tu carpeta de spam.

Si aun así no llega, te recomendamos volver a completar el formulario con una dirección de correo distinta.

¿Cuáles son las diferencias entre la Edición Gratis y la Edición Power?

En este cuadro comparativo podrás ver las diferencias entre
ambas ediciones del sistema.

¿Qué incluye la Licencia Perpetua de la Edición Power?

Entre varias ventajas, esta licencia no vence nunca, tiene
acceso a soporte técnico sin cargo, y a actualizaciones del sistema gratis de por vida.

Para ver todas las otras características incluidas, dale clic aquí.

Necesitas hacer una pregunta?
Si luego de navegar por toda nuestra documentación técnica y
tutoriales necesitas hacer una consulta concreta, estamos aquí para
responderte.

Desde nuestra comunidad de soporte técnico 24/7, nuestros
expertos responderán a tus preguntas puntuales.
Realizar una pregunta ahora