Customer - Appointments / YN
0.0 0.0 1000 1 1 N Y 5000 Y - 2007/06/03 14:32:03.666 Quickvet MSACCESS ODBC Quickvet -1 Encrypted EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER-1 STREAM_RESULTSY USE_POOLINGN Filter rowsSelect valuesY Filter rowsDummy (do nothing)Y Select valuesAdd sequenceY Table inputAdd constantsY Add constantsFilter rowsY Add sequence Sequence Y 1 none APPOINTID N SEQ_ Y 1 1 9999999 550 112 Y Dummy (do nothing) Dummy Y 1 none 356 226 Y Filter rows FilterRows N 1 none Select values Dummy (do nothing) N DATE >= constantDate2008/01/01 00:00:00.000-1-1N 353 113 Y Select values SelectValues Y 1 none SCHEDULE -2 -2 AccountNumber CLIENTID -2 -2 PetNumbers PATIENTID -2 -2 DATE -2 -2 TIME -2 -2 Reason -2 -2 Duration -2 -2 Information -2 -2 445 110 Y Table input TableInput Y 1 none Quickvet SELECT [Appt No] , Client , Pet , Reason , Duration , Information , AccountNumber , PetNumbers , [DATE] , [TIME] FROM Sched_1 0 N N 129 113 Y Add constants Constant Y 1 none SCHEDULE String 1 -1 -1 254 112 Y