{ This is an automatically generated lazarus resource file } LazarusResources.Add('TIngaveVerbruik','FORMDATA',[ 'TPF0'#15'TIngaveVerbruik'#14'IngaveVerbruik'#14'OldCreateOrder'#8#6'Height'#3 +#3#2#16'HorizontalOffset'#3'6'#2#14'VerticalOffset'#3#230#0#5'Width'#3'C'#2#0 +#15'TWisaRPCHandler'#11'StartIngave'#9'OnExecute'#7#18'StartIngaveExecute'#7 +'Options'#11#14'jroArrayParams'#0#9'ParamDefs'#14#1#4'Name'#6#10'HoofdGroep' +#8'DataType'#7#8'jtNumber'#0#1#4'Name'#6#12'Klantengroep'#8'DataType'#7#8'jt' +'Number'#0#1#4'Name'#6#8'Artikels'#8'DataType'#7#7'jtArray'#0#1#4'Name'#6#5 +'Datum'#0#1#4'Name'#6#8'HeleWeek'#8'DataType'#7#9'jtBoolean'#0#0#4'left'#2'0' +#3'top'#2#24#0#0#16'TWisaWebDatabase'#6'DBWisa'#9'Connected'#8#11'LoginPromp' +'t'#8#14'KeepConnection'#8#11'Transaction'#7#6'TRWisa'#4'left'#3#240#0#3'top' +#2#24#0#0#13'TWisaWebQuery'#13'QMainGroupIDs'#8'Database'#7#6'DBWisa'#11'Tra' +'nsaction'#7#6'TRWisa'#8'ReadOnly'#9#11'SQL.Strings'#1#6#6'Select'#6#8' MG_' +'ID,'#6#8' DB_ID,'#6#21' DB_TargetGroupI_FK,'#6#21' UD_TargetGroupI_FK,'#6 +#21' DB_TargetGroupA_FK,'#6#21' UD_TargetGroupA_FK,'#6#19' UD_DetailBook_' +'FK,'#6#14' OS_LastYear,'#6#14' OS_LastMonth'#6#0#6#4'from'#6#15'UsersDeta' +'ilBook'#6'2left join DetailBook on (DB_ID = UD_DetailBook_FK)'#6'0left join' +' MainGroup on (MG_ID = DB_MainGroup_FK)'#6'Nleft join DetailbookClosed on (' +'(OS_DetailBook_FK = DB_ID) and (OS_Type = ''3''))'#6#5'where'#6'&(UD_Users_' +'FK = :UID) AND (MG_ID=:MGID)'#6#0#0#6'Params'#14#1#8'DataType'#7#9'ftUnknow' +'n'#4'Name'#6#3'UID'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'ftUnkno' +'wn'#4'Name'#6#4'MGID'#9'ParamType'#7#9'ptUnknown'#0#0#4'left'#3#136#0#3'top' +#2#24#0#0#19'TWisaWebTransaction'#6'TRWisa'#6'Active'#8#6'Action'#7#6'caNone' +#8'Database'#7#6'DBWisa'#4'left'#3#240#0#3'top'#2'P'#0#0#13'TWisaWebQuery'#11 +'QKlantgroep'#8'Database'#7#6'DBWisa'#11'Transaction'#7#6'TRWisa'#8'ReadOnly' +#8#11'SQL.Strings'#1#6#6'SELECT'#6#7' IG_ID'#6#4'from'#6#15' TargetGroupIG' +#6'3 left join IdenGroup on (IG_ID = GRI_IdenGroup_FK)'#6#5'where'#6#29' (' +'GRI_TargetGroup_FK = :GID)'#6#19' AND (IG_ID=:KGID)'#0#6'Params'#14#1#8'Da' +'taType'#7#9'ftUnknown'#4'Name'#6#3'GID'#9'ParamType'#7#9'ptUnknown'#0#1#8'D' +'ataType'#7#9'ftUnknown'#4'Name'#6#4'KGID'#9'ParamType'#7#9'ptUnknown'#0#0#4 +'left'#3#136#0#3'top'#2'P'#0#0#13'TWisaWebQuery'#10'Qartikelen'#8'ReadOnly'#8 +#11'SQL.Strings'#1#6#6'Select'#6#27' COUNT (AR_ID) as TheCount'#6#4'from'#6 +#15' TargetGroupAR'#6'/ left join Article on (AR_ID = GRA_Article_FK)'#6#5 +'where'#6#27' (GRA_TargetGroup_FK = %d)'#6#21' AND (AR_ID in (%s))'#6#0#0#6 +'Params'#14#0#4'left'#3#136#0#3'top'#3#128#0#0#0#13'TWisaWebQuery'#9'QVerbru' +'ik'#8'ReadOnly'#8#11'SQL.Strings'#1#6#6'Select'#6'S ID_Name, ID_FirstName,' +' CS_ID, DY_Article_FK, DY_Date, DY_Qty, DY_CreatedBy, DY_ID'#6#4'from'#6#13 +' IdenGroupCS'#6'5 left join IdenDetail on (CS_ID = IGC_IdenDetail_FK)'#6 +'< left join Identification on (ID_ID = CS_Identification_FK)'#6'6 left jo' +'in CommDay on ((DY_DetailBook_FK = :DBID) and'#6'N (DY_IdenDetail_FK = CS_' +'ID) and (DY_Date between :Begindatum and :Einddatum))'#6#5'where'#6#27' (IG' +'C_IdenGroup_FK = :KGID)'#6#21' and (CS_Block = ''-'')'#0#6'Params'#14#1#8'D' +'ataType'#7#9'ftUnknown'#4'Name'#6#4'DBID'#9'ParamType'#7#9'ptUnknown'#0#1#8 +'DataType'#7#9'ftUnknown'#4'Name'#6#10'Begindatum'#9'ParamType'#7#9'ptUnknow' +'n'#0#1#8'DataType'#7#9'ftUnknown'#4'Name'#6#9'Einddatum'#9'ParamType'#7#9'p' +'tUnknown'#0#1#8'DataType'#7#9'ftUnknown'#4'Name'#6#4'KGID'#9'ParamType'#7#9 +'ptUnknown'#0#0#4'left'#3#136#0#3'top'#3#184#0#0#0#13'TWisaWebQuery'#12'QArt' +'ikelData'#8'Database'#7#6'DBWisa'#11'Transaction'#7#6'TRWisa'#8'ReadOnly'#8 +#11'SQL.Strings'#1#6#6'SELECT'#6') AR_ID, AR_CODE, AR_LOCK, AL_DESCRIPTION' +#6#4'FROM'#6#9' ARTICLE'#6' LEFT JOIN DOSSIER ON (DS_ID=1)'#6'] LEFT JOI' +'N ARTICLENAME ON (AL_ARTICLE_FK=AR_ID) AND (AL_LANGUAGE_FKP=DS_LANGUAGEREPO' +'RTS_FKP)'#6#5'WHERE'#6#15' AR_ID IN (%s)'#0#6'Params'#14#0#4'left'#3#136#0 +#3'top'#3#240#0#0#0#13'TWisaWebQuery'#12'QingaveModel'#8'ReadOnly'#8#11'SQL.' +'Strings'#1#6#6'SELECT'#6#19' J_JOBTYPE, J_MEMO'#6#4'FROM'#6#9' JOBDATA'#6 +#5'WHERE'#6''' (J_JOBID=:JobID) and (J_TYPERECORD=0)'#0#6'Params'#14#1#8'Da' +'taType'#7#9'ftUnknown'#4'Name'#6#5'JobID'#9'ParamType'#7#9'ptUnknown'#0#0#4 +'left'#3#136#0#3'top'#3'`'#1#0#0#13'TWisaWebQuery'#14'QInsertJobData'#8'Data' +'base'#7#6'DBWisa'#11'Transaction'#7#6'TRWisa'#8'ReadOnly'#8#11'SQL.Strings' +#1#6#19'INSERT INTO JOBDATA'#6'. (J_ID,J_JOBTYPE,J_JOBID,J_TYPERECORD,J_MEM' +'O)'#6#6'VALUES'#6'C (GEN_ID(GEN_JOBDATA,1),:J_JOBTYPE,:J_JOBID,:J_TYPERECO' +'RD,:J_MEMO)'#6#0#0#6'Params'#14#1#8'DataType'#7#9'ftUnknown'#4'Name'#6#9'J_' +'JOBTYPE'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'ftUnknown'#4'Name' +#6#7'J_JOBID'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'ftUnknown'#4'N' +'ame'#6#12'J_TYPERECORD'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'ftU' +'nknown'#4'Name'#6#6'J_MEMO'#9'ParamType'#7#9'ptUnknown'#0#0#4'left'#3#136#0 +#3'top'#3'('#1#0#0#15'TWisaRPCHandler'#14'GetIngaveModel'#9'OnExecute'#7#21 ,'GetIngaveModelExecute'#7'Options'#11#14'jroArrayParams'#0#9'ParamDefs'#14#1 +#4'Name'#6#5'JobID'#8'DataType'#7#8'jtNumber'#0#0#4'left'#2'0'#3'top'#2'P'#0 +#0#15'TWisaRPCHandler'#14'EditIngaveData'#9'OnExecute'#7#21'EditIngaveDataEx' +'ecute'#7'Options'#11#14'jroArrayParams'#0#9'ParamDefs'#14#1#4'Name'#6#4'Dat' +'a'#8'DataType'#7#8'jtObject'#0#0#4'left'#2'0'#3'top'#3#144#0#0#0#15'TWisaRP' +'CHandler'#13'GetIngaveData'#9'OnExecute'#7#20'GetIngaveDataExecute'#7'Optio' +'ns'#11#14'jroArrayParams'#0#9'ParamDefs'#14#1#4'Name'#6#5'JobID'#8'DataType' +#7#8'jtNumber'#0#0#4'left'#2'0'#3'top'#3#200#0#0#0#13'TWisaWebQuery'#11'QIng' +'aveData'#8'ReadOnly'#8#11'SQL.Strings'#1#6#6'SELECT'#6#7' J_ID,'#6#12' J_' +'JOBTYPE,'#6#8' J_MEMO'#6#4'FROM'#6#9' JOBDATA'#6#5'WHERE'#6#18' (J_JOBID' +'=:JobID)'#6#22' AND (J_TYPERECORD=1)'#6#8'ORDER BY'#6#6' J_ID'#0#6'Params' +#14#1#8'DataType'#7#9'ftUnknown'#4'Name'#6#5'JobID'#9'ParamType'#7#9'ptUnkno' +'wn'#0#0#4'left'#3#136#0#3'top'#3#152#1#0#0#15'TWisaRPCHandler'#8'CleanJob'#9 +'OnExecute'#7#15'CleanJobExecute'#7'Options'#11#14'jroArrayParams'#0#9'Param' +'Defs'#14#1#4'Name'#6#5'JobID'#8'DataType'#7#8'jtNumber'#0#0#4'left'#2'1'#3 +'top'#3#0#1#0#0#13'TWisaWebQuery'#9'QCleanJob'#8'ReadOnly'#8#11'SQL.Strings' +#1#6')DELETE FROM JOBID WHERE (J_JOBID=:JobID);'#0#6'Params'#14#1#8'DataType' +#7#9'ftUnknown'#4'Name'#6#5'JobID'#9'ParamType'#7#9'ptUnknown'#0#0#4'left'#3 +#27#1#3'top'#3#191#0#0#0#15'TWisaRPCHandler'#10'ProcessJob'#9'OnExecute'#7#17 +'ProcessJobExecute'#7'Options'#11#14'jroArrayParams'#0#9'ParamDefs'#14#1#4'N' +'ame'#6#5'JobID'#8'DataType'#7#8'jtNumber'#0#0#4'left'#2'0'#3'top'#3'@'#1#0#0 +#13'TWisaWebQuery'#20'QGetIngaveDataRecord'#8'ReadOnly'#8#11'SQL.Strings'#1#6 +#6'SELECT'#6#7' J_ID,'#6#12' J_JOBTYPE,'#6#8' J_MEMO'#6#4'FROM'#6#9' JOB' +'DATA'#6#5'WHERE'#6#12' (J_ID=:ID)'#6#22' AND (J_TYPERECORD=1)'#6#0#0#6'Pa' +'rams'#14#1#8'DataType'#7#9'ftUnknown'#4'Name'#6#2'ID'#9'ParamType'#7#9'ptUn' +'known'#0#0#4'left'#3#24#1#3'top'#3#8#1#0#0#13'TWisaWebQuery'#14'QUpdateJobD' +'ata'#8'Database'#7#6'DBWisa'#11'Transaction'#7#6'TRWisa'#8'ReadOnly'#8#11'S' +'QL.Strings'#1#6#18'UPDATE JOBDATA SET'#6#25' J_BOOLEAN1=:J_BOOLEAN1,'#6#16 +' J_MEMO=:J_MEMO'#6#5'WHERE'#6#12' (J_ID=:ID)'#6#0#0#6'Params'#14#1#8'Data' +'Type'#7#9'ftUnknown'#4'Name'#6#10'J_BOOLEAN1'#9'ParamType'#7#9'ptUnknown'#0 +#1#8'DataType'#7#9'ftUnknown'#4'Name'#6#6'J_MEMO'#9'ParamType'#7#9'ptUnknown' +#0#1#8'DataType'#7#9'ftUnknown'#4'Name'#6#2'ID'#9'ParamType'#7#9'ptUnknown'#0 +#0#4'left'#3#24#1#3'top'#3'H'#1#0#0#13'TWisaWebQuery'#13'QModifiedData'#8'Re' +'adOnly'#8#11'SQL.Strings'#1#6#6'SELECT'#6#7' J_ID,'#6#12' J_JOBTYPE,'#6#8 +' J_MEMO'#6#4'FROM'#6#9' JOBDATA'#6#5'WHERE'#6#18' (J_JOBID=:JobID)'#6#22 +' AND (J_TYPERECORD=1)'#6#22' AND (J_BOOLEAN1=''+'')'#6#0#0#6'Params'#14#1 +#8'DataType'#7#9'ftUnknown'#4'Name'#6#5'JobID'#9'ParamType'#7#9'ptUnknown'#0 +#0#4'left'#3#27#1#3'top'#3#136#1#0#0#13'TWisaWebQuery'#14'QInsertCommDay'#8 +'ReadOnly'#8#11'SQL.Strings'#1#6#21'INSERT INTO COMMDAY ('#6#8' DY_ID,'#6#15 +' DY_CHANGEDBY,'#6#15' DY_CHANGEDON,'#6#19' DY_DETAILBOOK_FK,'#6#19' DY_' +'IDENDETAIL_FK,'#6#16' DY_ARTICLE_FK,'#6#10' DY_DATE,'#6#9' DY_QTY,'#6#15 +' DY_CREATEDON,'#6#14' DY_CREATEDBY'#6#1')'#6#8'VALUES ('#6#9' :DY_ID,'#6 +#16' :DY_CHANGEDBY,'#6#8' ''NOW'','#6#20' :DY_DETAILBOOK_FK,'#6#20' :DY_' +'IDENDETAIL_FK,'#6#17' :DY_ARTICLE_FK,'#6#11' :DY_DATE,'#6#10' :DY_QTY,'#6 +#8' ''NOW'','#6#15' :DY_CREATEDBY'#6#1')'#0#6'Params'#14#1#8'DataType'#7#9 +'ftUnknown'#4'Name'#6#5'DY_ID'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7 +#9'ftUnknown'#4'Name'#6#12'DY_CHANGEDBY'#9'ParamType'#7#9'ptUnknown'#0#1#8'D' +'ataType'#7#9'ftUnknown'#4'Name'#6#16'DY_DETAILBOOK_FK'#9'ParamType'#7#9'ptU' +'nknown'#0#1#8'DataType'#7#9'ftUnknown'#4'Name'#6#16'DY_IDENDETAIL_FK'#9'Par' +'amType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'ftUnknown'#4'Name'#6#13'DY_ARTIC' +'LE_FK'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'ftUnknown'#4'Name'#6 +#7'DY_DATE'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'ftUnknown'#4'Nam' +'e'#6#6'DY_QTY'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'ftUnknown'#4 +'Name'#6#12'DY_CREATEDBY'#9'ParamType'#7#9'ptUnknown'#0#0#4'left'#3#16#1#3't' +'op'#3#200#1#0#0#13'TWisaWebQuery'#14'QDeleteCommDay'#8'ReadOnly'#8#11'SQL.S' +'trings'#1#6'%DELETE FROM COMMDAY WHERE (DY_ID=:ID)'#0#6'Params'#14#1#8'Data' +'Type'#7#9'ftUnknown'#4'Name'#6#2'ID'#9'ParamType'#7#9'ptUnknown'#0#0#4'left' +#3#185#1#3'top'#3#246#0#0#0#13'TWisaWebQuery'#14'QUpdateCommDay'#8'ReadOnly' +#8#11'SQL.Strings'#1#6#18'UPDATE COMMDAY SET'#6#22' DY_CHANGEDON=''NOW'' ,' +#6#30' DY_CHANGEDBY=:DY_CHANGEDBY ,'#6#16' DY_QTY=:DY_QTY'#6#5'WHERE'#6#16 +' (DY_ID=:DY_ID)'#6#0#6#0#0#6'Params'#14#1#8'DataType'#7#9'ftUnknown'#4'Nam' +'e'#6#12'DY_CHANGEDBY'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'ftUnk' +'nown'#4'Name'#6#6'DY_QTY'#9'ParamType'#7#9'ptUnknown'#0#1#8'DataType'#7#9'f' +'tUnknown'#4'Name'#6#5'DY_ID'#9'ParamType'#7#9'ptUnknown'#0#0#4'left'#3#185#1 ,#3'top'#3'5'#1#0#0#0 ]);