| 
										
																	
											
																		| 
													
																				
														
																					| 
															
															 | 
																
																							
																	
																								|  |  
																	
																								|  |  
																	
																								| 
																			
																										
																				
																											| 
																														
																															| 
																						
																																	
																							
																																		| 
																									
																																				
																										
																																					| 
																												
																																							
																													
																																								| 
																															
																																										
																																
																																											| 
																																													
																																														| 
																																		
																																																
																																			
																																																	|  |  
																																			
																																																	| 
																																					
																																																			
																																						
																																																				| 
																																																						
																																																							| 
																																																									
																																																										
																																																											| 
	
																																																													
		
																																																														|  |  
		
																																																														| 
				
																																																																
					
																																																																	|  | 
																																																																			
																																																																			
																																																																			
																																																																			
																																																																				
																																																																					| 
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The query editor allows you to create a query by typing SQL code...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| WLanguage includes the "WL" keyword...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file). |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| This help page explains how to create an SQL query to filter records.... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| A delete query (corresponding SQL statement...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| For compatibility with the earlier versions of the Native SQL Server Connector (also called Native SQL Server Access), the connection can still be configured in WDSQSINS (supplied with the Native SQL Server Connector)...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Native SQL Server Connector (also known as Native SQL Server Access) license agreement... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| A query (typed in SQL code) can operate on different databases...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| An Update query (SQL UPDATE statement) is used to modify the records in a database file...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| WEBDEV allows you to create a PHP site that handles data files...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The SQL functions can be used to handle the ORACLE database, regardless of whether WDORAINS is used or not to configure the accessed database...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| This help page explains how to create a query with a calculation formula with the query editor.... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| To get an SSL certificate for IIS 7 (and later), the different steps are as follows:... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| This help page explains how to create a sort query with the query editor.... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| In SQL language, an external join is used to exclude or include file records with or without correspondences in the linked files...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables. |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The use of SQL functions to manipulate Informix data does not require importing the file structure into the analysis...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The use of SQL functions to handle Sybase data does not require importing the file structure into the analysis...... |  |  |  |  |  |  
																																																																							
																																																																								| 
							
																																																																										
								
																																																																											| 
																																																																													
																																																																														| 
										
																																																																																
											
																																																																																	|  |  
											
																																																																																	| 
													
																																																																																			
														
																																																																																				| 
																																																																																						
																																																																																							| The Native SQL Server Connector is used to:
	specify the input values during the call to a stored procedure.
	retrieve the output values after a call to a stored procedure.... |  |  |  |  |  |  |  |  |  |  
		
																																																																|  |  |  |  | 
																																							
																																							 |  |  
																																			
																																																			|  |  |  |  |  |  
																													
																																										|  |  |  |  
																							
																																				|  |  |  |  |  
																	
																										|  |  | 
															
															 |  |  |