| 
										
																	
											
																		| 
													
																				
														
																					| 
															
															 | 
																
																							
																	
																								|  |  
																	
																								|  |  
																	
																								| 
																			
																										
																				
																											| 
																														
																															| 
																						
																																	
																							
																																		| 
																									
																																				
																										
																																					| 
																												
																																							
																													
																																								| 
																															
																																										
																																
																																											| 
																																													
																																														| 
																																		
																																																
																																			
																																																	|  |  
																																			
																																																	| 
																																					
																																																			
																																						
																																																				| 
																																																						
																																																							| 
																																																									
																																																										
																																																											| 
	
																																																													
		
																																																														|  |  
		
																																																														| 
				
																																																																
					
																																																																	| 
						
						 | 
							
																																																																			
								
																																																																				| 
										
																																																																						
											
																																																																							| 
																																																																									
																																																																										| Resultados de la búsqueda |  | 
												
												 |  |  
								
																																																																				|  |  
								
																																																																				|  |  
								
																																																																				|  |  
								
																																																																				|  |  | 
						
						 |  |  |  
																																																									
																																																										
																																																											| 
	
																																																													
		
																																																														|  |  
		
																																																														| 
				
																																																																
					
																																																																	|  | 
																																																																			
																																																																			
																																																																			
																																																																			
																																																																				
																																																																					| 
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Two types of directories can be configured when creating the executable... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The analysis is used to define the structure of data files used by the project... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Sets the position on the previous record of a file according to a browse item. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Sets the position on the previous record of the data file according to a browse item. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Sets the position on the last record of a data file according to a browse item. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Closes either a data file or all data files opened by the current user: all corresponding physical data files are closed for the current user. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Returns the list of files: analysis in progress. of analyses in progress (case of projects with multiple analyses).specific analysis recognized by the HFSQL engine. available for connection via a Native Connector or an OLE DB driver.for a group of files defined in the data model editor.
 |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Unlocks a file that was locked by the same program with HNoModif. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| This feature is used to signal that a data file cannot be modified after writing... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Describes a file item programmatically. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Unlocks a record locked by: HLockRecNum,a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
 |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Reads a record in a file according to a given record number. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Convierte el contenido de la Record actual en cadena (en un archivo de datos, vista HFSQL, consulta, etc.). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Defines and enables a filter on a data file, view or query. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Deletes a record from a data file (query or view). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exporta los registros de una tabla (HFSQL u OLE DB), vista o consulta a una tabla JSON. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Returns the list of data file bindings (Merise type) present: in the current analysis,  Versiones 2024 y posteriores in ongoing analyses (case of projects with multiple analyses). New in SaaS in ongoing analyses (case of projects with multiple analyses).in ongoing analyses (case of projects with multiple analyses). Novedad versión 2024 in ongoing analyses (case of projects with multiple analyses).in a specific analysis.
 |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Adds or modifies a trigger on an HFSQL data file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Restores the previously saved context of a file (function HSavePosition): recording in progress, filter, playback pointers. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Checks whether the current record corresponds to the current filter or search. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Sets the position on the first record of a data file according to the specified browse item. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Returns the full path of the directory of HFSQL data files specified by the user when installing the application. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Sets the position on the next data file record according to a browse item. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Deletes a previously created view. This function uses the former view mechanism. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Initializes: one or all variables of file items with their default values. one or all items of a Record variable with their default values. 
 |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of the HFSQL data files and for all the other types of accesses (Native, OLE DB, ... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Returns the approximate position of current record in the data file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Used to check whether a lock error occurred. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Deletes all records from a data file, an HFSQL view or a query. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Adds or modifies a trigger on an HFSQL data file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Stores the current file context (current record, filter, pointers). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Temporarily disables the filter on a data file (view or query). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Unlocks the records of a data file: locked by HLockFile. individually locked by a locking read function.
 |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Describes a link between two data files programmatically. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Devuelve la lista de artículos: encontrada en un fichero de datos ( una consulta o una vista) conocido por el motor HFSQL. Los archivos de datos definidos por las funciones HDeclare, HDeclareExternal y HDescribeFile se tienen en cuenta.encontrado en una variable Record. 
 |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Un trigger es un procedimiento WLanguage llamado automáticamente por el motor HFSQL cada vez que se realiza una modificación (adición, eliminación, modificación, ...) en un registro de un archivo de datos. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Returns the content of the current record (in a file, a view or a query, ...). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Crea una vista HFSQL. Esta función utiliza el anterior mecanismo de vistas.
 |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The analysis proposes two types of Unicode items... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Sets the position on the last record of a data file according to a browse item. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Describes a full-text index of data file created programmatically. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Sets the position on a record, based on the approximate position of one of its items. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Returns the list of stop words used by a full-text index. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Returns the list of assignments for the data files handled by the current application, which means the list of physical files corresponding to the files described in the analysis. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |  |  |  |  |  |  |  |  |  |  
		
																																																																|  |  |  |  | 
																																							
																																							 |  |  
																																			
																																																			|  |  |  |  |  |  
																													
																																										|  |  |  |  
																							
																																				|  |  |  |  |  
																	
																										|  |  | 
															
															 |  |  |