Comandos y funciones de visual foxpro

Solo disponible en BuenasTareas
  • Páginas : 13 (3139 palabras )
  • Descarga(s) : 0
  • Publicado : 14 de febrero de 2011
Leer documento completo
Vista previa del texto
CLEAR (Comando)
Libera de la memoria el elemento o los elementos especificados.
CLEAR [ALL | CLASS ClassName | CLASSLIB ClassLibraryName | DEBUG | DLLS [cAliasNameList]| EVENTS | FIELDS | GETS | MACROS | MEMORY | MENUS | POPUPS | PROGRAM | PROMPT | READ [ALL] | RESOURCES [FileName] | TYPEAHEAD | WINDOWS]
STORE (Comando)
Almacena datos en una variable, en una matriz o en unelemento de matriz.
STORE eExpression TO VarNameList | ArrayNameList-or- VarName | ArrayName = eExpression
USE (Comando)
Abre una tabla y sus archivos de índice asociados, o una vista SQL.
USE[[DatabaseName!]Table | SQLViewName | ?] [IN nWorkArea | cTableAlias] [ONLINE] [ADMIN] [AGAIN] [NOREQUERY
[nDataSessionNumber]] [NODATA] [INDEX IndexFileList | ? [ORDER [nIndexNumber | IDXFileName| [TAG] TagName [OF CDXFileName] [ASCENDING | DESCENDING]]]] [ALIAS cTableAlias] [EXCLUSIVE] [SHARED] [NOUPDATE] [CONNSTRING cConnectionString | (m.nStatementHandle) ]
INDEX (Comando)
Crea un archivo de índice para mostrar registros de tabla y tener acceso a los mismos en un orden lógico.
INDEX ON eExpression TO IDXFileName | TAG TagName [OF CDXFileName] [ COLLATE cCollateSequence ][OF CDXFileName] [FOR lExpression] [COMPACT] [ASCENDING | DESCENDING] [UNIQUE | CANDIDATE] [ADDITIVE]
APPEND (Comando)
Agrega uno o más registros nuevos al final de una tabla.
APPEND[BLANK] [IN nWorkArea | cTableAlias] [NOMENU]
SORT (Comando)
Ordena los registros de la tabla seleccionada actualmente y envía los registros ordenados a una tabla nueva.
SORT TO TableName ON FieldName1 [/A | /D][/C] [, FieldName2 [/A | /D] [/C] ...] [ASCENDING | DESCENDING] [Scope] [FOR lExpression1] [WHILE lExpression2] [FIELDS FieldNameList | FIELDS LIKE Skeleton
| FIELDS EXCEPT Skeleton] [NOOPTIMIZE]
BROWSE (Comando)
Abre la ventana Examinar y muestra los registros de la tabla actual o seleccionada.
BROWSE [FIELDS FieldList] [FONT cFontName [, nFontSize]] [STYLE cFontStyle] [FOR lExpression1[REST]] [FORMAT] [FREEZE FieldName] [KEY eExpression1 [, eExpression2]] [LAST | NOINIT] [LOCK nNumberOfFields] [LPARTITION] [NAME ObjectName] [NOAPPEND] [NOCAPTIONS] [NODELETE] [NOEDIT | NOMODIFY] [NOLGRID] [NORGRID] [NOLINK] [NOMENU] [NOOPTIMIZE] [NOREFRESH] [NORMAL] [NOWAIT] [PARTITION nColumnNumber [LEDIT] [REDIT]] [PREFERENCE PreferenceName] [SAVE] [TIMEOUT nSeconds] [TITLE cTitleText] [VALID[:F] lExpression2 [ERROR cMessageText]] [WHEN lExpression3] [WIDTH nFieldWidth] [WINDOW WindowName1] [IN [WINDOW] WindowName2 | IN SCREEN] [COLOR SCHEME nSchemeNumber]
MODIFY STRUCTURE(Comando)
Muestra el Diseñador de tablas para que pueda modificar la estructura de una tabla.
MODIFY STRUCTURE
CHANGE (Comando)
Muestra campos para edición.
CHANGE [FIELDS FieldList] [Scope] [FORlExpression1] [WHILE lExpression2] [FONT cFontName [, nFontSize]] [STYLE cFontStyle] [FREEZE FieldName] [KEY eExpression1 [, eExpression2]] [LAST | NOINIT] [LPARTITION] [NAME ObjectName] [NOAPPEND] [NOCAPTION] [NOCLEAR] [NODELETE] [NOEDIT | NOMODIFY] [NOLINK] [NOMENU] [NOOPTIMIZE] [NORMAL] [NOWAIT] [PARTITION nColumnNumber [LEDIT] [REDIT]] [PREFERENCE PreferenceName] [REST] [SAVE] [TIMEOUT nSeconds] [TITLEcTitleText] [VALID [:F] lExpression3 [ERROR cMessageText]] [WHEN lExpression4] [WIDTH nFieldWidth] [WINDOW WindowName1] [IN [WINDOW] WindowNam2 | IN SCREEN | IN MACDESKTOP]] [COLOR SCHEME nSchemeNumber | COLOR ColorPairList]
DELETE - SQL (Comando)
Marca los registros que se van a eliminar.
DELETE FROM [DatabaseName!]TableName
[WHERE FilterCondition1 [AND | OR FilterCondition2 ...]]
PACK(Comando)
Borra definitivamente todos los registros marcados para eliminar de la tabla actual y reduce el tamaño de un archivo memo asociado a la tabla.
PACK [MEMO] [DBF] [Tablename ] [IN nWorkarea | cTableAlias]
RECALL (Comando)
Quita la marca de los registros marcados para eliminación en la tabla seleccionada.
RECALL [Scope] [FOR lExpression1] [WHILE lExpression2] [NOOPTIMIZE] [IN nWorkArea |...
tracking img