API - Query

In this topic: Hide

 

Query Methods

Parameter Type Description Remarks
ActivateSubroutine(IQaSubroutine* pSubroutine_); short    
AddFeatFilter(BSTR filter_, BSTR value_); long     
AddFeatureToFeatListByKeys(BSTR featureKeyLabel_, BSTR routineKeyLabel_); long     
AddFeatureToFeatureList(IQaFeature* feature_); long     
AddRoutineToQuery(BSTR keyLabel_); long     
AddSampFilter(BSTR filter_, BSTR value_); long     
AddSampleToSampList(IQaSample* sample_); long     
AddSampleToSampListByKey(BSTR keyLabel_); long     
ClearFeatFilters(); long     
ClearRoutFilters(); long     
ClearSampFilters(); long     
CreateFeature(BSTR label, [optional] variant routineKeyLabel_); IQaFeature*        
CreateRoutine(BSTR label_, eHandedness hand_, IQaFilters* keyFilters_); IQaRoutine*        
CreateSample(BSTR label, [optional] variant routineKeyLabel_); IQaSample*         
CreateSMIHole(BSTR label, double x, double y, double z, double i, double j, double k, double dia, [optional] variant routineKeyLabel_); IQaFeature*        
CreateSMIPoint(BSTR label, double x, double y, double z, double i, double j, double k, [optional] variant routineKeyLabel_); IQaFeature*        
CreateSMISlot(BSTR label, double x, double y, double z, double i, double j, double k, double len, double wid, [optional] variant routineKeyLabel_); IQaFeature*        
Delete(); long     
DeviationType(eDeviationSmiType smiType, eDeviationCharacteristicType chrType); eDeviationType     
DeviationType(eDeviationSmiType smiType, eDeviationCharacteristicType chrType, eDeviationType newType); void     
GetDataSourceFeatsFiltersByPos(short pos); IQaQueryFilter*    
GetDataSourceFeatsFiltersCount(); long     
GetDataSourceLabel(); BSTR       
GetDataSourceSampFiltersByPos(short pos); IQaQueryFilter*    
GetDataSourceSampFiltersCount(); long     
GetFeature(BSTR featureLabel); IQaFeature*        
GetFeaturebyPos(long pos); IQaFeature*        
GetFeatureCount(); long     
GetFeatureListCount(); long     
GetFeatureListFeatByPos(long pos_); IQaFeature*        
GetRoutineByName(BSTR keyLabel_); IQaRoutine*        
GetRoutineByPos(long pos); IQaRoutine*        
GetRoutineCount(); long     
GetSample(BSTR sampleLabel); IQaSample*         
GetSamplebyPos(long pos); IQaSample*         
GetSampleCount(); long     
GetSampleListCount(); long     
GetSampleListKeyLabelByPos(long pos_); BSTR       
GetSampleListSampByPos(long pos_); IQaSample*         
GetSubroutineByName(BSTR keyLabel_); IQaSubroutine*     
GetSubroutineByPos(long pos_); IQaSubroutine*     
GetSubroutineCount(); long     
IsLoaded(); boolean    
Load(); boolean    
LoadSubroutineByFilter(BSTR filter_, BSTR value_); long     
MakeFeatureList(); long     
MakeSampleList(); long     
Refresh(); long     
RemoveFeatFilter(BSTR label_, BSTR value_);  long     
RemoveRoutFilter(BSTR label_, BSTR value_);  long     
RemoveRoutineFromQuery(BSTR keyLabel_); long     
RemoveSampFilter(BSTR label_, BSTR value_);  long     
SetActiveSample(BSTR label_); BOOL       
UnLoadSubroutines(); long     
Update(); long     

Query Properties

Parameter Type Description Remarks
DataSourceConnectString; BSTR     
DataSourceDatabaseName; BSTR     
DataSourceFeatSelectionsType; eFeatureFilterSelectionType    
DataSourceFeatureFilterLabel; BSTR     
DataSourceFeaturesFilter; VARIANT     
DataSourceFeaturesFilterType; eFeatureFilterType             
DataSourcePassword; BSTR     
DataSourceRoutineCode; BSTR     
DataSourceRoutineLabel; BSTR     
DataSourceSampleFilterLabel; BSTR     
DataSourceSamplesAfterDateTime; DATE     
DataSourceSamplesBeforeDateTime; DATE     
DataSourceSamplesBeforeDays; long     
DataSourceSamplesBeforeHours; long     
DataSourceSamplesBeforeMinutes; long     
DataSourceSamplesBeforeTime; DATE     
DataSourceSamplesCutOffDate; DATE     
DataSourceSamplesCutOffDateType; eSampleCutoffDateType          
DataSourceSamplesCutOffDays; long     
DataSourceSamplesDuringBeginType; eSampleDuringType              
DataSourceSamplesDuringMinusCount; long     
DataSourceSamplesDuringMinusType; eSampleDuringType              
DataSourceSamplesDuringPeriodCount; long     
DataSourceSamplesDuringPeriodType; eSampleDuringType              
DataSourceSamplesFilters; VARIANT     
DataSourceSamplesFilterType; eSampleFilterType              
DataSourceSamplesLast; long     
DataSourceSamplesLoadLikeQuery; BSTR     
DataSourceSamplesLoadOrder; eSampleOrder                   
DataSourceSamplesOrder; eSampleOrder                   
DataSourceSamplesQueryDate;    DATE     
DataSourceSamplesSkip; long     
DataSourceSamplesSortOrder; eSampleOrder                   
DataSourceSamplesType; eSampleType                    
DataSourceSamplesUseQueryDate; BOOL     
DataSourceUserName; BSTR     
Label; BSTR     
ManagedConnection;             BSTR     
OracleConnectString; BSTR     
OracleFeaturesFilter; VARIANT     
OracleFeaturesFilterType; eFeatureFilterType             
OraclePassword; BSTR     
OracleRoutineLabel; BSTR     
OracleSamplesAfterDateTime; DATE     
OracleSamplesBeforeDateTime; DATE     
OracleSamplesBeforeDays; long     
OracleSamplesBeforeHours; long     
OracleSamplesBeforeMinutes; long     
OracleSamplesBeforeTime; DATE     
OracleSamplesDuringBeginType; eSampleDuringType              
OracleSamplesDuringMinusCount; long     
OracleSamplesDuringMinusType; eSampleDuringType              
OracleSamplesDuringPeriodCount; long     
OracleSamplesDuringPeriodType; eSampleDuringType              
OracleSamplesFilters; VARIANT     
OracleSamplesFilterType; eSampleFilterType              
OracleSamplesLast; long     
OracleSamplesLoadOrder; eSampleOrder                   
OracleSamplesOrder; eSampleOrder                   
OracleSamplesSkip; long     
OracleSamplesSortOrder; eSampleOrder                   
OracleSamplesType; eSampleType                    
OracleUserName; BSTR     
QueryType; eQueryType                     
SQLServerConnectString; BSTR     
SQLServerDatabaseName; BSTR     
SQLServerFeaturesFilter; VARIANT     
SQLServerFeaturesFilterType; eFeatureFilterType             
SQLServerPassword; BSTR     
SQLServerRoutineLabel; BSTR     
SQLServerSamplesAfterDateTime; DATE     
SQLServerSamplesBeforeDateTime; DATE     
SQLServerSamplesBeforeDays; long     
SQLServerSamplesBeforeHours; long     
SQLServerSamplesBeforeMinutes; long     
SQLServerSamplesBeforeTime; DATE     
SQLServerSamplesDuringBeginType; eSampleDuringType              
SQLServerSamplesDuringMinusCount; long     
SQLServerSamplesDuringMinusType; eSampleDuringType              
SQLServerSamplesDuringPeriodCount; long     
SQLServerSamplesDuringPeriodType; eSampleDuringType              
SQLServerSamplesFilters; VARIANT     
SQLServerSamplesFilterType; eSampleFilterType              
SQLServerSamplesLast; long     
SQLServerSamplesLoadOrder; eSampleOrder                   
SQLServerSamplesOrder; eSampleOrder                   
SQLServerSamplesSkip; long     
SQLServerSamplesSortOrder; eSampleOrder                   
SQLServerSamplesType; eSampleType                    
SQLServerUserName; BSTR     
SubGroupSize; long     

Query Enumerators

Types - eQueryType

Parameters Help String Description Remarks
eQueryAccess, MS Access                     
eQueryAccessODBC, Access/ODBC (obsolete)        
eQueryApi API                           
eQueryODBC, ODBC (obsolete)               
eQueryOracle, Oracle                        
eQueryPersOracle, Personal Oracle (obsolete)    
eQueryQuantum, Quantum (obsolete)            
eQuerySQLServer, SQL Server                    
eQueryUndefined = 0, Undefined                     

Sample Types - eSampleType

Parameters Help String Description Remarks
eSampleAll, All Sample               
eSampleDuring, During Timeframe         
eSampleLast, Last 'n' Sample          
eSampleList, Only Selected Samples    
eSampleNone = 0, No Sample                
eSamplePrevious, Previous Timeframe       
eSampleQuery Query Samples            
eSampleSince, Since Date/Time          

Sample Order Types - eSampleOrder

Parameters Help String Description Remarks
eSampleOrderDate = 1, Date           
eSampleOrderDesc, Description    
eSampleOrderFilter Filter         
eSampleOrderLabel, Label          
eSampleOrderSeq, Sequence       
eSampleOrderSer, Serial         

Feature Filter Selection Types - eFeatureFilterSelectionType

Parameters Help String Description Remarks
eAllFeaturesAsFiltered, Only Features that match at least 1 specifier    
eListOfFeatures, Only Features that match all specifiers          
eNoFeatures = -1, No filtering (All Features)                      
eQueryFeatures Only Features from active subroutine             
eSubroutineFeatures, Only Features selected from list                 

Feature Filter Types - eFeatureFilterType

Parameters Help String Description Remarks
eFeatureFilterAll Only Features that match all specifiers          
eFeatureFilterNone = 0, No filtering (All Features)                      
eFeatureFilterOne, Only Features that match at least 1 specifier    

Sample Filter Types - eSampleFilterType

Parameters Help String Description Remarks
eSampleFilterNone = 0, No filtering (All Samples)                      
eSampleFilterOne, Only Samples that match at least 1 specifier    
eSampleFilterAll Only Samples that match all specifiers          

Routine Filter Types - eRoutineFilterType

Parameters Help String Description Remarks
eRoutineFilterAll Only Routines that match all specifiers          
eRoutineFilterNone = 0, No filtering (All Routines)                      
eRoutineFilterOne, Only Routines that match at least 1 specifier    

Sample During Types - eSampleDuringType

Parameters Help String Description Remarks
eSampleDuringDay = 1, Day      
eSampleDuringMonth, Month    
eSampleDuringWeek, Week     
eSampleDuringYear Year     

Sample Cutoff Date Type - eSampleCutoffDateType

Parameters Help String Description Remarks
eAbsolute, Absolute     
eNoCutoff, No Cutoff    
eRelative Relative     

Deviation Characteristic Type - eDeviationCharacteristicType

Parameters Help String Description Remarks
e_chrAngle, Angle          
e_chrAzi, Azimuth        
e_chrDia, Diameter       
e_chrDist, Distance       
e_chrFlush, Flush          
e_chrGap, Gap            
e_chrHor, Horizon        
e_chrLen, Length         
e_chrNor = 66, Normal         
e_chrP, Primary        
e_chrPol, Polar          
e_chrPos = 0, Position       
e_chrRadius, Radius         
e_chrS, Secondary      
e_chrSig = 36, Significant    
e_chrT, Tertiary       
e_chrTol Toleranced     
e_chrWid, Width          
e_chrX, X              
e_chrY, Y              
e_chrZ, Z              

Deviation SMI Type - eDeviationSmiType

Parameters Help String Description Remarks
e_smiDist, Distance     
e_smiFlush, Flush        
e_smiGap Gap          
e_smiHole, Hole         
e_smiMid, Midpoint     
e_smiNon = 0, Non          
e_smiRef, Reference    
e_smiSlot, Slot         
e_smiSurf, Surface      
e_smiVar, Variance     

Deviation Type - eDeviationType

Parameters Help String Description Remarks
e_DevCar,         Car       
e_DevOffset       Offset    
e_DevVector  = 1, Vector