| 
										
																	
											
																		| 
													
																				
														
																					| 
															
															 | 
																
																							
																	
																								|  |  
																	
																								|  |  
																	
																								| 
																			
																										
																				
																											| 
																														
																															| 
																						
																																	
																							
																																		| 
																									
																																				
																										
																																					| 
																												
																																							
																													
																																								| 
																															
																																										
																																
																																											| 
																																													
																																														| 
																																		
																																																
																																			
																																																	|  |  
																																			
																																																	| 
																																					
																																																			
																																						
																																																				| 
																																																						
																																																							| 
																																																									
																																																										
																																																											| 
	
																																																													
		
																																																														|  |  
		
																																																														| 
				
																																																																
					
																																																																	|  | 
																																																																			
																																																																			
																																																																			
																																																																			
																																																																				
																																																																					| 
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| 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), view or query to an XML file. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Table controls allow you to display and/or enter data...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The advanced types of WLanguage are as follows... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Creates a text file containing the server logs between two given dates. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The hScheduleMaterializedView type is used to programmatically manage a task for recalculating the data of a scheduled materialized view on an HFSQL server. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Creates a text file containing the server logs between two given dates. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The Organizer control is used to display and handle organizers...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The HFSQL Control Center is used to manage the HFSQL Client/Server servers and the HFSQL Client/Server databases...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Calculates the difference between two dates and times. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| This page explains how to program Table controls based on a data file...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Configures the isolation mode of transactions for a connection to an HFSQL server. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The remote HFSQL administrator proposes a full management of the HFSQL Client/Server databases...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Configures the isolation mode of transactions for a connection to an HFSQL server. |  |  |  |  |  |  |  |  |  |  
		
																																																																|  |  |  |  | 
																																							
																																							 |  |  
																																			
																																																			|  |  |  |  |  |  
																													
																																										|  |  |  |  
																							
																																				|  |  |  |  |  
																	
																										|  |  | 
															
															 |  |  |