| id | lang | string |
|---|
| 64304 | 0 | update t_TopUser set TopUser_No = :TopUser_No, User_Code = :User_Code, TopUser_Bargain = :TopUser_Bargain, TopUser_Count = :TopUser_Count, ModDate = getdate() where TopUser_Code = :TopUser_Code |
| 64305 | 0 | update t_TopDept set DelFlag = 1, ModDate = getdate() where TopDept_Code = :TopDept_Code |
| 64306 | 0 | select t_TopDept.*, Company_Name from t_TopDept Inner join t_Company on t_TopDept.Company_Code = t_Company.Company_Code where t_TopDept.DelFlag = 0 |
| 64307 | 0 | and TopDept_Code = :TopDept_Code |
| 64308 | 0 | insert into t_TopDept (TopDept_Code, TopDept_No, Company_Code, TopDept_Bargain, TopDept_Count, Delflag, ModDate) values (:TopDept_Code, :TopDept_No, :Company_Code, :TopDept_Bargain, :TopDept_Count, 0, getdate()) |
| 64309 | 0 | update t_TopDept set TopDept_No = :TopDept_No, Company_Code = :Company_Code, TopDept_Bargain = :TopDept_Bargain, TopDept_Count = :TopDept_Count, ModDate = getdate() where TopDept_Code = :TopDept_Code |
| 64320 | 0 | insert into t_AttSet (AttSet_Code, AttSet_Name, AttSet_StartTime, AttSet_EndTime, AttSet_Memo, AttSet_Flag, DelFlag, InDate, ModDate, NewDate )values (:AttSet_Code, :AttSet_Name, :AttSet_StartTime, :AttSet_EndTime, :AttSet_Memo, :AttSet_Flag, 0, getdate(), getdate(), getdate()) |
| 64321 | 0 | update t_AttSet set AttSet_Name = :AttSet_Name, AttSet_StartTime = :AttSet_StartTime, AttSet_EndTime = :AttSet_EndTime, AttSet_Memo = :AttSet_Memo, AttSet_Flag = :AttSet_Flag, ModDate = getdate() where AttSet_Code = :AttSet_Code |
| 64322 | 0 | select U.User_Name, C.Company_Name, U.User_Code as User_Code, C.Company_Code, A.* from (t_User AS U INNER JOIN t_Company as C ON U.Company_Code = C.Company_Code) left join (select * from t_AttPlan where AttPlan_Month = '%s') as A ON U.User_Code = A.User_Code where U.TrashFlag = 0 and U.DelFlag = 0 |
| 64323 | 0 | insert into t_AttPlan (AttPlan_Code, User_Code, AttPlan_Month, Day1, Day2, Day3, Day4, Day5, Day6, Day7, Day8, Day9, Day10, Day11, Day12, Day13, Day14, Day15, Day16, Day17, Day18, Day19, Day20, Day21, Day22, Day23, Day24, Day25, Day26, Day27, Day28, Day29, Day30, Day31, DelFlag, InDate, ModDate )values (:AttPlan_Code, :User_Code, :AttPlan_Month, :Day1, :Day2, :Day3, :Day4, :Day5, :Day6, :Day7, :Day8, :Day9, :Day10, :Day11, :Day12, :Day13, :Day14, :Day15, :Day16, :Day17, :Day18, :Day19, :Day20, :Day21, :Day22, :Day23, :Day24, :Day25, :Day26, :Day27, :Day28, :Day29, :Day30, :Day31, 0, getdate(), getdate()) |
| 64324 | 0 | update t_AttPlan set User_Code = :User_Code, AttPlan_Month = :AttPlan_Month, Day1 = :Day1, Day2 = :Day2, Day3 = :Day3, Day4 = :Day4, Day5 = :Day5, Day6 = :Day6, Day7 = :Day7, Day8 = :Day8, Day9 = :Day9, Day10 = :Day10, Day11 = :Day11, Day12 = :Day12, Day13 = :Day13, Day14 = :Day14, Day15 = :Day15, Day16 = :Day16, Day17 = :Day17, Day18 = :Day18, Day19 = :Day19, Day20 = :Day20, Day21 = :Day21, Day22 = :Day22, Day23 = :Day23, Day24 = :Day24, Day25 = :Day25, Day26 = :Day26, Day27 = :Day27, Day28 = :Day28, Day29 = :Day29, Day30 = :Day30, Day31 = :Day31, ModDate = getdate() where AttPlan_Code = :AttPlan_Code |
| 64325 | 0 | select R.Realty_No, R.Realty_Trade, R.Realty_Building, W.WorkBook_Name, R.Realty_State, R.Realty_Chamber, R.Realty_Floor, R.Realty_Code, R.User_Code, U.User_Name, U.Company_Code, CP.Company_Name, A2.Area_Name as City_Name, A2.Area_Code, R.WorkBook_Code, R.Indate from (((t_Realty AS R INNER JOIN t_WorkBook W on R.WorkBook_Code = W.WorkBook_Code) inner join t_Area A2 on W.District_Code = A2.Area_Code) INNER JOIN t_User AS U ON R.User_Code = U.User_Code) INNER JOIN t_Company AS CP ON U.Company_Code = CP.Company_Code where R.DelFlag = 0 |
| 64326 | 0 | select C.Client_No, C.Client_Name, C.Client_Trade, C.Client_District, C.Client_Street, C.Client_State, C.Client_Code, U.User_Name, CP.Company_Name, C.InDate, C.Client_Tel from (t_Client AS C INNER JOIN t_User AS U ON C.User_Code = U.User_Code) INNER JOIN t_Company AS CP ON U.Company_Code = CP.Company_Code where C.DelFlag = 0 |
| 64327 | 0 | update t_Document set Delflag = 1, ModDate = getdate() where Document_Code = :Document_Code |
| 64328 | 0 | select * from t_Document where Delflag = 0 |
| 64329 | 0 | and Document_Code = :Document_Code |
| 64330 | 0 | Insert into t_Document(Document_Code, Document_PCode, Document_Name, Document_Content, Document_Type, Document_FileType, Document_Group, Document_InUser, Document_MoUser, DelFlag, InDate, ModDate, NewDate, Document_Team ) Values(:Document_Code, :Document_PCode, :Document_Name, :Document_Content, :Document_Type, :Document_FileType, :Document_Group, :Document_InUser, :Document_MoUser, 0, getdate(), getdate(), getdate(), :Document_Team ) |
| 64331 | 0 | update t_Document set Document_PCode = :Document_PCode, Document_Name = :Document_Name, Document_Content = :Document_Content, Document_Type = :Document_Type, Document_Group = :Document_Group, Document_FileType = :Document_FileType, Document_InUser = :Document_InUser, Document_MoUser = :Document_MoUser, ModDate = getdate(), Document_Team = :Document_Team where Document_Code = :Document_Code |
| 64332 | 0 | update t_TopUser set DelFlag = 1, ModDate = getdate() where TopUser_Code = :TopUser_Code |
| 64333 | 0 | select t_TopUser.*, (Company_Name + '.' + User_Name) as UserName from t_TopUser Inner join t_User on t_TopUser.User_Code = t_User.User_Code inner join t_Company On t_User.Company_Code = t_Company.Company_Code where t_TopUser.DelFlag = 0 |
| 64334 | 0 | and TopUser_Code = :TopUser_Code |
| 64335 | 0 | insert into t_TopUser (TopUser_Code, TopUser_No, User_Code, TopUser_Bargain, TopUser_Count, Delflag, ModDate) values (:TopUser_Code, :TopUser_No, :User_Code, :TopUser_Bargain, :TopUser_Count, 0, getdate()) |
| 64336 | 0 | LEFT JOIN (SELECT t_Contract.User_Code, SUM(Contract_FeeOwner) AS FO, SUM(Contract_FeeOwnerAct) AS FC FROM t_ContractComm LEFT JOIN t_Contract ON t_ContractComm.Contract_Code = t_Contract.Contract_Code WHERE t_Contract.DelFlag = 0 AND ContractComm_Comment = '房源' AND %0:s GROUP BY t_Contract.User_Code, Contract_Trade) R1 ON R1.User_Code = U.User_Code LEFT JOIN (SELECT t_Contract.User_Code, SUM(Contract_FeeClient) AS FO, SUM(Contract_FeeClientAct) AS FC FROM t_ContractComm LEFT JOIN t_Contract ON t_ContractComm.Contract_Code = t_Contract.Contract_Code WHERE t_Contract.DelFlag = 0 AND ContractComm_Comment = '客源' AND %0:s GROUP BY t_Contract.User_Code, Contract_Trade) R2 ON R2.User_Code = U.User_Code |
| 64337 | 0 | LEFT JOIN (SELECT t_Contract.Company_Code, SUM(Contract_FeeOwner) AS FO, SUM(Contract_FeeOwnerAct) AS FC FROM t_ContractComm LEFT JOIN t_Contract ON t_ContractComm.Contract_Code = t_Contract.Contract_Code WHERE t_Contract.DelFlag = 0 AND ContractComm_Comment = '房源' AND %0:s GROUP BY t_Contract.Company_Code, Contract_Trade) R1 ON R1.Company_Code = C.Company_Code LEFT JOIN (SELECT t_Contract.Company_Code, SUM(Contract_FeeOwner) AS FO, SUM(Contract_FeeOwnerAct) AS FC FROM t_ContractComm LEFT JOIN t_Contract ON t_ContractComm.Contract_Code = t_Contract.Contract_Code WHERE t_Contract.DelFlag = 0 AND ContractComm_Comment = '客源' AND %0:s GROUP BY t_Contract.Company_Code, Contract_Trade) R2 ON R2.Company_Code = C.Company_Code |
| 64338 | 0 | LEFT JOIN (SELECT t_Contract.User_Code, Sum(Contract_Price * ContractComm_Rate) AS RC FROM t_ContractComm LEFT JOIN t_Contract ON t_ContractComm.Contract_Code = t_Contract.Contract_Code WHERE t_Contract.DelFlag = 0 %1:s GROUP BY t_Contract.User_Code, Contract_Trade) R%0:d ON R%0:d.User_Code = U.User_Code |
| 64339 | 0 | LEFT JOIN (SELECT t_Contract.Company_Code, Sum(Contract_Price * ContractComm_Rate) AS RC FROM t_ContractComm LEFT JOIN t_Contract ON t_ContractComm.Contract_Code = t_Contract.Contract_Code WHERE t_Contract.DelFlag = 0 %1:s GROUP BY t_Contract.Company_Code, Contract_Trade) R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64340 | 0 | SELECT SysData_Name AS [银行], R1.RC AS [商业贷款], R2.RC AS [公积金贷款] FROM t_SysData LEFT JOIN (SELECT Contract_MortBank, SUM(Contract_MortMoney) AS RC FROM t_Contract WHERE DelFlag = 0 AND %s GROUP BY Contract_MortBank) R1 ON R1.Contract_MortBank = SysData_Name LEFT JOIN (SELECT Contract_MortBankG, SUM(Contract_MortMoneyG) AS RC FROM t_Contract WHERE DelFlag = 0 AND %s GROUP BY Contract_MortBankG) R2 ON R2.Contract_MortBankG = SysData_Name WHERE SysData_Type = 'BS' AND RTRIM(SysData_Name) <> '' |
| 64341 | 0 | LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Att WHERE TrashFlag = 0 %1:s GROUP BY User_Code) as R%0:d ON R%0:d.User_Code = U.User_Code |
| 64342 | 0 | LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_Att INNER JOIN t_User ON t_Att.User_Code = t_User.User_Code WHERE t_Att.TrashFlag = 0 %1:s GROUP BY t_User.Company_CODE) as R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64343 | 0 | LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Log WHERE DelFlag = 0 %1:s GROUP BY User_Code) as R%0:d ON R%0:d.User_Code = U.User_Code |
| 64344 | 0 | LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_Log INNER JOIN t_User ON t_Log.User_Code = t_User.User_Code WHERE t_Log.DelFlag = 0 %1:s GROUP BY t_User.Company_CODE) as R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64345 | 0 | LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Realty WHERE TrashFlag = 1 AND DelFlag = 0 %1:s GROUP BY USER_CODE) as R%0:d ON R%0:d.User_Code = U.User_Code |
| 64346 | 0 | LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_Realty INNER JOIN t_User ON t_Realty.User_Code = t_User.User_Code WHERE t_Realty.TrashFlag = 1 AND t_Realty.DelFlag = 0 %1:s GROUP BY t_User.Company_CODE) as R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64347 | 0 | LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Client WHERE TrashFlag = 1 AND DelFlag = 0 %1:s GROUP BY USER_CODE) as R%0:d ON R%0:d.User_Code = U.User_Code |
| 64348 | 0 | LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_Client INNER JOIN t_User ON t_Client.User_Code = t_User.User_Code WHERE t_Client.TrashFlag = 1 AND t_Client.DelFlag = 0 %1:s GROUP BY t_User.Company_CODE) as R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64349 | 0 | update t_AttSet set DelFlag = 1, ModDate = getdate() where AttSet_code = :AttSet_Code |
| 64350 | 0 | select * from t_AttSet where delflag = 0 |
| 64351 | 0 | and AttSet_Code = :AttSet_Code |
| 64352 | 0 | LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Realty WHERE TrashFlag = 0 %1:s GROUP BY USER_CODE) as R%0:d ON R%0:d.User_Code = U.User_Code |
| 64353 | 0 | LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_Realty INNER JOIN t_User ON t_Realty.User_Code = t_User.User_Code WHERE t_Realty.TrashFlag = 0 %1:s GROUP BY t_User.Company_CODE) as R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64354 | 0 | LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_RealtyFollow WHERE TrashFlag = 0 %1:s GROUP BY User_Code) as R%0:d ON R%0:d.User_Code = U.User_Code |
| 64355 | 0 | LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_RealtyFollow INNER JOIN t_User ON t_RealtyFollow.User_Code = t_User.User_Code WHERE t_RealtyFollow.TrashFlag = 0 %1:s GROUP BY t_User.Company_Code) as R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64356 | 0 | LEFT JOIN (SELECT W%0:d.District_Code, Count(*) AS RC FROM t_Realty R%0:d INNER JOIN t_WorkBook W%0:d on R%0:d.WorkBook_Code = W%0:d.WorkBook_Code WHERE R%0:d.TrashFlag = 0 %1:s GROUP BY W%0:d.District_Code) R%0:d ON R%0:d.District_Code = A.Area_Code |
| 64357 | 0 | LEFT JOIN (SELECT User_Allot, COUNT(*) AS RC FROM t_FolTask WHERE FolTask_Type = %0:s AND TrashFlag = 0 AND %1:s GROUP BY User_Allot) R1 ON R1.User_Allot = U.User_Code LEFT JOIN (SELECT User_Perform, COUNT(*) AS RC FROM t_FolTask WHERE FolTask_Type = %0:s AND TrashFlag = 0 AND %2:s GROUP BY User_Perform) R2 ON R2.User_Perform = U.User_Code LEFT JOIN (SELECT User_Complete, COUNT(*) AS RC FROM t_FolTask WHERE FolTask_Type = %0:s AND TrashFlag = 0 AND FolTask_Complete = 1 AND %3:s GROUP BY User_Complete) R3 ON R3.User_Complete = U.User_Code |
| 64358 | 0 | LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_FolTask LEFT JOIN t_User U1 ON t_FolTask.User_Allot = U1.User_Code WHERE FolTask_Type = %0:s AND t_FolTask.TrashFlag = 0 AND %1:s GROUP BY U1.Company_Code) R1 ON R1.Company_Code = C.Company_Code LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_FolTask LEFT JOIN t_User U2 ON t_FolTask.User_Perform = U2.User_Code WHERE FolTask_Type = %0:s AND t_FolTask.TrashFlag = 0 AND %2:s GROUP BY U2.Company_Code) R2 ON R2.Company_Code = C.Company_Code LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_FolTask LEFT JOIN t_User U3 ON t_FolTask.User_Complete = U3.User_Code WHERE FolTask_Type = %0:s AND t_FolTask.TrashFlag = 0 AND FolTask_Complete = 1 AND %3:s GROUP BY U3.Company_Code) R3 ON R3.Company_Code = C.Company_Code |
| 64359 | 0 | LEFT JOIN (SELECT t_Realty.User_Code, COUNT(*) AS RC FROM t_Advert LEFT JOIN t_Realty ON t_Advert.Realty_Code = t_Realty.Realty_Code WHERE t_Advert.TrashFlag = 0 GROUP BY t_Realty.User_Code) R%0:d ON R%0:d.User_Code = U.User_Code |
| 64360 | 0 | LEFT JOIN (SELECT t_User.Company_Code, COUNT(*) AS RC FROM t_Advert LEFT JOIN t_Realty ON t_Advert.Realty_Code = t_Realty.Realty_Code LEFT JOIN t_User ON t_Realty.User_Code = t_User.User_Code WHERE t_Advert.TrashFlag = 0 GROUP BY t_User.Company_Code) R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64361 | 0 | LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Realty WHERE TrashFlag = 0 AND Realty_Trade = '0' AND %0:s GROUP BY USER_CODE) R5 ON R5.User_Code = U.User_Code LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Realty WHERE TrashFlag = 0 AND Realty_Trade = '1' AND %0:s GROUP BY USER_CODE) R6 ON R6.User_Code = U.User_Code LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Realty WHERE TrashFlag = 0 AND Realty_Trade = '2' AND %0:S GROUP BY USER_CODE) R7 ON R7.User_Code = U.User_Code LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_RealtyFollow WHERE TrashFlag = 0 AND %1:s GROUP BY User_Code) R8 ON R8.User_Code = U.User_Code LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_RealtyFollow WHERE TrashFlag = 0 AND Follow_Mode = '看房' AND %1:s GROUP BY User_Code) R9 ON R9.User_Code = U.User_Code LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Client WHERE TrashFlag = 0 AND Client_Trade = '0' AND %2:s GROUP BY USER_CODE) R10 ON R10.User_Code = U.User_Code LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Client WHERE TrashFlag = 0 AND Client_Trade = '1' AND %2:s GROUP BY USER_CODE) R11 ON R11.User_Code = U.User_Code LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Client WHERE TrashFlag = 0 AND Client_Trade = '2' AND %2:s GROUP BY USER_CODE) R12 ON R12.User_Code = U.User_Code LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_ClientFollow WHERE TrashFlag = 0 AND %3:s GROUP BY User_Code) AS R13 ON R13.User_Code = U.User_Code LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_ClientFollow WHERE TrashFlag = 0 AND t_ClientFollow.Follow_Mode = '看房' AND %3:s GROUP BY User_Code) AS R14 ON R14.User_Code = U.User_Code |
| 64362 | 0 | LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_Client WHERE TrashFlag = 0 %1:s GROUP BY USER_CODE) as R%0:d ON R%0:d.User_Code = U.User_Code |
| 64363 | 0 | LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_Client INNER JOIN t_User ON t_Client.User_Code = t_User.User_Code WHERE t_Client.TrashFlag = 0 %1:s GROUP BY t_User.Company_Code) as R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64364 | 0 | LEFT JOIN (SELECT User_Code, COUNT(*) AS RC FROM t_ClientFollow WHERE TrashFlag = 0 %1:s GROUP BY User_Code) as R%0:d ON R%0:d.User_Code = U.User_Code |
| 64365 | 0 | LEFT JOIN (SELECT Company_Code, COUNT(*) AS RC FROM t_ClientFollow INNER JOIN t_User ON t_ClientFollow.User_Code = t_User.User_Code WHERE t_ClientFollow.TrashFlag = 0 %1:s GROUP BY t_User.Company_CODE) as R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64366 | 0 | LEFT OUTER JOIN (SELECT m.User_Code, SUM(ContractComm_Rate) AS RC, SUM(Contract_FeeTotal * ContractComm_Rate) AS RF, SUM(Contract_FeeTotalAct * ContractComm_Rate) AS RA FROM t_ContractComm m LEFT JOIN t_Contract c ON m.Contract_Code = c.Contract_Code WHERE m.DelFlag = 0 AND c.DelFlag = 0 %1:s GROUP BY m.User_Code, c.Contract_Trade) R%0:d ON R%0:d.User_Code = U.User_Code |
| 64367 | 0 | LEFT OUTER JOIN (SELECT m.Company_Code, SUM(ContractComm_Rate) AS RC, SUM(Contract_FeeTotal * ContractComm_Rate) AS RF, SUM(Contract_FeeTotalAct * ContractComm_Rate) AS RA FROM t_ContractComm m LEFT JOIN t_Contract c ON m.Contract_Code = c.Contract_Code WHERE m.DelFlag = 0 AND c.DelFlag = 0 %1:s GROUP BY m.Company_Code, c.Contract_Trade) R%0:d ON R%0:d.Company_Code = C.Company_Code |
| 64368 | 0 | Y |
| 64369 | 0 | Pie |
| 64370 | 0 | Bar |
| 64371 | 0 | Angle |
| 64372 | 0 | Where U.TrashFlag = 0 AND U.User_Sales = 1 AND U.User_Status <> '离职' |
| 64373 | 0 | Where C.TrashFlag = 0 |
| 64374 | 0 | Where A.DelFlag = 0 AND Area_Type = 'B' |
| 64375 | 0 | C.Company_No |
| 64376 | 0 | C.Company_No, U.User_No |
| 64377 | 0 | A.Area_No |
| 64378 | 0 | C.Company_Name AS 部门 |
| 64379 | 0 | U.User_Name AS 员工 |
| 64380 | 0 | A.Area_Name AS 城区 |
| 64381 | 0 | FROM t_User U LEFT JOIN t_Company C ON U.Company_Code = C.Company_Code |
| 64382 | 0 | FROM t_Company C |
| 64383 | 0 | FROM t_Area A |
| 64384 | 0 | Chairs |
| 64385 | 0 | Standard |
| 64386 | 0 | Functions |
| 64387 | 0 | 8 |
| 64388 | 0 | Add |
| 64389 | 0 | Subtract |
| 64390 | 0 | Multiply |
| 64391 | 0 | Divide |
| 64392 | 0 | High |
| 64393 | 0 | Low |
| 64394 | 0 | Average |
| 64395 | 0 | Arial |
| 64396 | 0 | Pointer size must be greater than zero |
| 64397 | 0 | Function Period should be >= 0 |
| 64398 | 0 | Other |
| 64399 | 0 | X |
| 64400 | 0 | Series.ParentChart is not myself! |
| 64401 | 0 | Line |
| 64402 | 0 | Point |
| 64403 | 0 | Area |
| 64404 | 0 | Bar |
| 64405 | 0 | Horiz. Bar |
| 64406 | 0 | Pie |
| 64407 | 0 | Fast Line |
| 64408 | 0 | Rotation |
| 64409 | 0 | Cars |
| 64410 | 0 | Phones |
| 64411 | 0 | Tables |
| 64412 | 0 | Monitors |
| 64413 | 0 | Lamps |
| 64414 | 0 | Keyboards |
| 64415 | 0 | Bikes |
| 64416 | 0 | Labels Separation % must be greater than 0 |
| 64417 | 0 | Axis increment must be >= 0 |
| 64418 | 0 | Axis Minimum Value must be <= Maximum |
| 64419 | 0 | Axis Maximum Value must be >= Minimum |
| 64420 | 0 | Axis Logarithmic Base should be >= 2 |
| 64421 | 0 | MaxPointsPerPage must be >= 0 |
| 64422 | 0 | 3D effect percent must be between %d and %d |
| 64423 | 0 | Circular Series dependences are not allowed |
| 64424 | 0 | Bar Width Percent must be between 1 and 100 |
| 64425 | 0 | Bar Offset Percent must be between -100% and 100% |
| 64426 | 0 | %s of %s |
| 64427 | 0 | ##0.## % |
| 64428 | 0 | #,##0.### |
| 64429 | 0 | Axis Title |
| 64430 | 0 | Axis Labels |
| 64431 | 0 | Refresh Interval must be between 0 and 60 |
| 64432 | 0 | insert into t_Remark (Remark_Code, Company_Code, User_Code, Remark_Content, DelFlag, TrashFlag, InDate, ModDate, NewDate) values (:Remark_Code, :Company_Code, :User_Code, :Remark_Content, 0, 0, getdate(), getdate(), getdate()) |
| 64433 | 0 | update t_Remark set User_Code = :User_Code, Remark_Content = :Remark_Content, ModDate = getdate() where Remark_Code = :Remark_Code |
| 64434 | 0 | Update t_DatumRealtyFollow set TrashFlag = 1, DelFlag= 1, ModDate = getDate() where Follow_PCode = :DatumRealty_Code; update t_DatumRealty set TrashFlag = 1, DelFlag = 1, modDate = getdate() where DatumRealty_Code = :DatumRealty_Code; |
| 64435 | 0 | select W.WorkBook_Name, W.WorkBook_PY, W.WorkBook_Address1, W.District_Code, CP.Company_Name, A.Area_Code, A.Area_Name as AreaName, D.Area_Name AS DistrictName, CP.Company_Code, U.User_Name, DR.* from ((((t_DatumRealty as DR inner join t_WorkBook W on DR.WorkBook_Code = W.WorkBook_Code) inner join t_Area D on W.District_Code = D.Area_Code) left join t_Area A on W.Area_Code = A.Area_Code) inner join t_User U on DR.User_Code = U.User_Code) inner join t_Company CP on U.Company_Code = CP.Company_Code where DR.Delflag = 0 and DR.TrashFlag = 0 |
| 64436 | 0 | and DatumRealty_Code = :DatumRealty_Code |
| 64437 | 0 | insert into t_DatumRealty (DatumRealty_Code, DatumRealty_No, User_Code, WorkBook_Code, Realty_Building, Realty_Chamber, Realty_Floor, Realty_TotalFloor, Realty_Room, Realty_Hall, Realty_Loo, Realty_Balcony, Realty_Usage, Realty_Class, Realty_Year, Realty_Aspect, Realty_BuildAcreage, Realty_UseAcreage, Realty_Owner, Realty_OwnerTel, Realty_ModUser, Realty_Country, Realty_Remark, Realty_PUsage, DelFlag, TrashFlag, InDate, Realty_LastFollowDate, ModDate) values (:DatumRealty_Code, :DatumRealty_No, :User_Code, :WorkBook_Code, :Realty_Building, :Realty_Chamber, :Realty_Floor, :Realty_TotalFloor, :Realty_Room, :Realty_Hall, :Realty_Loo, :Realty_Balcony, :Realty_Usage, :Realty_Class, :Realty_Year, :Realty_Aspect, :Realty_BuildAcreage, :Realty_UseAcreage, :Realty_Owner, :Realty_OwnerTel, :Realty_ModUser, :Realty_Country, :Realty_Remark, :Realty_PUsage, 0, 0, getdate(), getdate(), getdate()) |
| 64438 | 0 | update t_DatumRealty set WorkBook_Code = :WorkBook_Code, Realty_Building = :Realty_Building, DatumRealty_No = :DatumRealty_No, User_Code = :User_Code, Realty_Chamber = :Realty_Chamber, Realty_Floor = :Realty_Floor, Realty_TotalFloor = :Realty_TotalFloor, Realty_Room = :Realty_Room, Realty_Hall = :Realty_Hall, Realty_Loo = :Realty_Loo, Realty_Balcony = :Realty_Balcony, Realty_Usage = :Realty_Usage, Realty_Class = :Realty_Class, Realty_Year = :Realty_Year, Realty_Aspect = :Realty_Aspect, Realty_BuildAcreage = :Realty_BuildAcreage, Realty_UseAcreage = :Realty_UseAcreage, Realty_ModUser = :Realty_ModUser, Realty_Owner = :Realty_Owner, Realty_OwnerTel = :Realty_OwnerTel, Realty_Country = :Realty_Country, Realty_Remark = :Realty_Remark, Realty_PUsage = :Realty_PUsage, ModDate = getdate() where DatumRealty_Code = :DatumRealty_Code |
| 64439 | 0 | Top Legend Position must be between 0 and 100 % |
| 64440 | 0 | First Legend Value must be > 0 |
| 64441 | 0 | Legend Color Width must be between 0 and 100 % |
| 64442 | 0 | No ParentChart to validate DataSource |
| 64443 | 0 | No valid DataSource: %s |
| 64444 | 0 | FillSampleValues NumValues must be > 0 |
| 64445 | 0 | %s Angle must be between 0 and 359 degrees |
| 64446 | 0 | DateTime Axis cannot be Logarithmic |
| 64447 | 0 | Logarithmic Axis Min and Max values should be >= 0 |
| 64448 | 0 | insert into t_Receipt (Receipt_Code, Company_Code, Receipt_Client, Receipt_Type, User_name, Receipt_Money, Receipt_Text, Receipt_Memo, Receipt_MoneyType, Receipt_AuditFlag, Receipt_AuditUser, Receipt_AuditDate, delflag, TrashFlag, InDate, ModDate) values (:Receipt_Code, :Company_Code, :Receipt_Client, :Receipt_Type, :User_name, :Receipt_Money, :Receipt_Text, :Receipt_Memo, :Receipt_MoneyType, 0, :Receipt_AuditUser, :Receipt_AuditDate, 0, 0, getdate(), getdate()) |
| 64449 | 0 | update t_Receipt set Receipt_Client = :Receipt_Client, Receipt_Type = :Receipt_Type, Receipt_Money = :Receipt_Money, Receipt_Text = :Receipt_Text, Receipt_Memo = :Receipt_Memo, Receipt_MoneyType = :Receipt_MoneyType, Receipt_AuditFlag = :Receipt_AuditFlag, Receipt_AuditUser = :Receipt_AuditUser, Receipt_AuditDate = :Receipt_AuditDate, ModDate = GetDate()where Receipt_Code = :Receipt_Code |
| 64450 | 0 | update t_FolTask set trashflag =1, DelFlag = 1, ModDate = getDate() where FolTask_code = :FolTask_Code |
| 64451 | 0 | select F.*, R.Realty_Code, R.Realty_No, P.user_Code as User_Code, P.Company_Code as Company_Code, R.Realty_Trade, W.WorkBook_Name, R.Realty_Building, R.Realty_Chamber, R.Realty_Owner, A.User_Name as User_NameAll, P.User_Name as User_NamePer, C.User_Name as User_NameCom from ((((t_FolTask AS F INNER JOIN t_Realty AS R ON F.FolTask_PCode = R.Realty_Code) INNER JOIN t_WorkBook AS W ON R.WorkBook_Code = W.WorkBook_Code) INNER JOIN t_User AS A ON F.User_Allot = A.User_Code) INNER JOIN t_User AS P ON F.User_Perform = P.User_Code) INNER JOIN t_User AS C ON F.User_Complete = C.User_Code where F.FolTask_Type = 0 and F.delflag = 0 and F.TrashFlag = 0 |
| 64452 | 0 | select F.*, C1.Client_Code, C1.Client_No, P.user_Code as User_Code, P.Company_Code as Company_Code, A.User_Name as User_NameAll, P.User_Name as User_NamePer, C.User_Name as User_NameCom, C1.Client_Name, C1.Client_Trade, C1.Client_Street, C1.Client_District, C1.Client_Area from (((t_FolTask AS F INNER JOIN t_Client AS C1 ON F.FolTask_PCode = C1.Client_Code) INNER JOIN t_User AS A ON F.User_Allot = A.User_Code) INNER JOIN t_User AS P ON F.User_Perform = P.User_Code) INNER JOIN t_User AS C ON F.User_Complete = C.User_Code where F.FolTask_Type = 1 and F.delflag = 0 and F.TrashFlag = 0 |
| 64453 | 0 | and FolTask_Code = :FolTask_Code |
| 64454 | 0 | insert into t_FolTask (FolTask_Code, FolTask_PCode, FolTask_Type, User_Allot, User_Perform, User_Complete, FolTask_DateAllot, FolTask_DatePerform, FolTask_DateComplete, FolTask_MemoAllot, FolTask_Complete, FolTask_MemoComplete, delflag, InDate, ModDate) values (:FolTask_Code, :FolTask_PCode, :FolTask_Type, :User_Allot, :User_Perform, :User_Complete, :FolTask_DateAllot, :FolTask_DateComplete, :FolTask_DatePerform, :FolTask_MemoAllot, :FolTask_Complete, :FolTask_MemoComplete, 0, getdate(), getdate()) |
| 64455 | 0 | update t_FolTask set User_Allot = :User_Allot, User_Perform = :User_Perform, User_Complete = :User_Complete, FolTask_DateAllot = :FolTask_DateAllot, FolTask_DatePerform = :FolTask_DatePerform, FolTask_DateComplete = :FolTask_DateComplete, FolTask_Complete = :FolTask_Complete, FolTask_MemoComplete = :FolTask_MemoComplete, FolTask_MemoAllot = :FolTask_MemoAllot, ModDate = getdate() where FolTask_Code = :FolTask_Code |
| 64456 | 0 | update %s set trashflag =1, DelFlag = 1, ModDate =getdate() where Follow_code = :Follow_Code; update t_Awoke set trashflag = 1, DelFlag = 1, ModDate = getdate() where Awoke_PCode = :Follow_Code; |
| 64457 | 0 | select RF.Follow_AwokeArea, RF.User_Code as User_Code2, RF.InDate AS InDate, CP.Company_Name, CP.Company_Code, U.User_Name, U1.Company_Code, W.WorkBook_Name, W.WorkBook_Code, R.Realty_Trade, R.Realty_Groom, R.Realty_Secrecy, R.Realty_Special, R.User_Code, R.Realty_Code, R.Realty_Building, R.Realty_State, R.Realty_Owner, W.WorkBook_PY, RF.* from (((t_Realty AS R INNER JOIN (t_RealtyFollow AS RF INNER JOIN t_User AS U ON RF.User_Code = U.User_Code) ON R.Realty_Code = RF.Follow_PCode) INNER JOIN t_Company AS CP ON U.Company_Code = CP.Company_Code) INNER JOIN t_WorkBook AS W ON R.WorkBook_Code = W.WorkBook_Code) INNER JOIN t_User AS U1 ON R.User_Code = U1.User_Code WHERE RF.DelFlag=0 AND RF.TrashFlag=0 and R.Delflag = 0 and R.TrashFlag = 0 |
| 64458 | 0 | select CF.Follow_AwokeArea, CF.InDate AS InDate, C.Client_Name, C.Client_Trade, C.Client_Usage, C.Client_Code, U.User_Name, U1.Company_Code, CP.Company_Code, CP.Company_Name, CF.* from (t_Client AS C INNER JOIN ((t_ClientFollow AS CF INNER JOIN t_User AS U ON CF.User_Code = U.User_Code) INNER JOIN t_Company AS CP ON U.Company_Code = CP.Company_Code) ON C.Client_Code = CF.Follow_PCode) INNER JOIN t_User AS U1 ON C.User_Code = U1.User_Code WHERE CF.DelFlag=0 AND CF.TrashFlag=0 and C.Delflag = 0 and C.TrashFlag = 0 |
| 64459 | 0 | select CTF.Follow_AwokeArea, CTF.InDate as InDate, CT.Contract_Code, CT.Contract_No, CT.Contract_Trade, CT.Contract_Address, Contract_ClientName, CT.Contract_OwnerName, CT.Realty_Code, CT.Realty_No, U.User_Name as User_Name, CP.Company_Code, CP.Company_Name, CTF.* from ((t_ContractFollow as CTF inner join t_Contract as CT ON CTF.Follow_PCode = CT.Contract_Code) inner join t_User as U ON CTF.User_Code = U.User_Code) INNER JOIN t_Company as CP ON U.Company_Code = CP.Company_Code where CTF.DelFlag = 0 and CTF.TrashFlag = 0 and CT.Delflag = 0 |
| 64460 | 0 | and Follow_Code = :Follow_Code |
| 64461 | 0 | update t_Remark set trashflag = 1, ModDate = getdate() where Remark_code = :Remark_Code |
| 64462 | 0 | select RK.*, CP.Company_Name, U.User_Name from (t_Remark as RK inner join t_Company as CP on RK.Company_Code = CP.Company_Code) inner join t_User as U on RK.User_Code = U.User_Code where RK.delflag = 0 and RK.TrashFlag = 0 |
| 64463 | 0 | and Remark_Code = :Remark_Code |
| 64464 | 0 | and WebPublish_Code = :WebPublish_Code |
| 64465 | 0 | insert into t_WebPublish (WebPublish_Code, Realty_Code, HomePage_Code, WebPublish_Publisher, DistrictName, AreaName, WorkBook_Name, WorkBook_Address1, Realty_Floor, Realty_TotalFloor, Realty_Room, Realty_Hall, Realty_Loo, Realty_Usage, Realty_Fitment, Realty_BuildAcreage, Realty_Aspect, Realty_Year, Realty_Trade, Realty_SellPrice, Realty_RentPrice, Realty_Configure, Realty_Remark, WebPublish_Published, WebPublish_Audit, Indate, Delflag, ModDate) values (:WebPublish_Code, :Realty_Code, :HomePage_Code, :WebPublish_Publisher, :DistrictName, :AreaName, :WorkBook_Name, :WorkBook_Address1, :Realty_Floor, :Realty_TotalFloor, :Realty_Room, :Realty_Hall, :Realty_Loo, :Realty_Usage, :Realty_Fitment, :Realty_BuildAcreage, :Realty_Aspect, :Realty_Year, :Realty_Trade, :Realty_SellPrice, :Realty_RentPrice, :Realty_Configure, :Realty_Remark, 0, 0, getdate(), 0, getdate()) |
| 64466 | 0 | update t_WebPublish set WebPublish_Publisher = :WebPublish_Publisher, DistrictName = :DistrictName, AreaName = :AreaName, WorkBook_Name = :WorkBook_Name, WorkBook_Address1 = :WorkBook_Address1, Realty_Floor = :Realty_Floor, Realty_TotalFloor = :Realty_TotalFloor, Realty_Room = :Realty_Room, Realty_Hall = :Realty_Hall, Realty_Loo = :Realty_Loo, Realty_Usage = :Realty_Usage, Realty_Fitment = :Realty_Fitment, Realty_BuildAcreage = :Realty_BuildAcreage, Realty_Aspect = :Realty_Aspect, Realty_Year = :Realty_Year, Realty_Trade = :Realty_Trade, Realty_SellPrice = :Realty_SellPrice, Realty_RentPrice = :Realty_RentPrice, Realty_Configure = :Realty_Configure, Realty_Remark = :Realty_Remark, WebPublish_Published = :WebPublish_Published, WebPublish_Audit = :WebPublish_Audit, ModDate = getdate() where WebPublish_Code = :WebPublish_Code |
| 64467 | 0 | update t_Conclude set trashflag =1, ModDate = getdate() where Conclude_code = :Conclude_Code |
| 64468 | 0 | select t_Conclude.*, t_Conclude.User_Code as User_Code, t_Company.Company_Code, t_Company.Company_Name, t_User.User_Name from (t_Conclude inner join t_User on t_Conclude.User_Code = t_User.User_Code) inner join t_Company on t_User.Company_Code = t_Company.Company_Code where t_Conclude.delflag = 0 and t_Conclude.trashflag = 0 |
| 64469 | 0 | and Conclude_Code = :Conclude_Code |
| 64470 | 0 | insert into t_Conclude (Conclude_Code, Conclude_Title, Conclude_Content, Conclude_Advice, Conclude_Remark, User_Code, delflag, InDate, ModDate, NewDate)values (:Conclude_Code, :Conclude_Title, :Conclude_Content, :Conclude_Advice, :Conclude_Remark, :User_Code, 0, getdate(), getdate(), getdate()) |
| 64471 | 0 | update t_Conclude set Conclude_Title = :Conclude_Title, Conclude_Content = :Conclude_Content, Conclude_Advice = :Conclude_Advice, Conclude_Remark = :Conclude_Remark, ModDate = getdate() where Conclude_Code = :Conclude_Code |
| 64472 | 0 | update t_Cost set trashflag = 1, DelFlag = 1, ModDate =getdate() where Cost_code = :Cost_Code |
| 64473 | 0 | select C.*, CP.Company_Name, U1.User_Name AS User_Name1, U2.User_Name AS User_Name2, CP.Company_Name as Company_Name, CP1.Company_Code as CP_Code from (((t_Company AS CP INNER JOIN t_Cost AS C ON CP.Company_Code = C.Company_Code) INNER JOIN t_User AS U1 ON C.User_Code1 = U1.User_Code) INNER JOIN t_User AS U2 ON C.User_Code2 = U2.User_Code) INNER JOIN t_Company AS CP1 ON U1.Company_Code = CP1.Company_Code where C.delflag = 0 |
| 64474 | 0 | and Cost_Code = :Cost_Code |
| 64475 | 0 | insert into t_Cost (Cost_Code, Cost_Name, Cost_Content, Cost_Money, Company_Code, User_Code1, Cost_Date, User_Code2, Cost_AuditFlag, Cost_AuditUser, Cost_AuditDate, delflag, InDate, ModDate) values (:Cost_Code, :Cost_Name, :Cost_Content, :Cost_Money, :Company_Code, :User_Code1, :Cost_Date, :User_Code2, 0, :Cost_AuditUser, :Cost_AuditDate, 0, getdate(), getdate()) |
| 64476 | 0 | update t_Cost set Cost_Name = :Cost_Name, Cost_Money = :Cost_Money, Cost_Content = :Cost_Content, User_Code2 = :User_Code2, Cost_AuditFlag = :Cost_AuditFlag, Cost_Date = :Cost_Date, Cost_AuditUser = :Cost_AuditUser, Cost_AuditDate = :Cost_AuditDate, ModDate = getdate() where Cost_Code = :Cost_Code |
| 64477 | 0 | update t_Receipt set trashflag =1, DelFlag = 1, ModDate =getdate() where Receipt_code = :Receipt_Code |
| 64478 | 0 | select RP.*, CP.Company_Name from t_Receipt as RP INNER JOIN t_Company as CP ON RP.Company_Code = CP.Company_Code where RP.delflag = 0 and RP.TrashFlag = 0 |
| 64479 | 0 | and Receipt_Code = :Receipt_Code |
| 64480 | 0 | Unable to find file '%s' used from '%s' |
| 64481 | 0 | Too many parameters at %d:%d |
| 64482 | 0 | No IFDEF for ENDIF at %d:%d |
| 64483 | 0 | No IFDEF for ELSE at %d:%d |
| 64484 | 0 | Can't use ELSE twice at %d:%d |
| 64485 | 0 | Unknown compiler directives at %d:%d |
| 64486 | 0 | Define not closed |
| 64487 | 0 | Unable to read variant |
| 64488 | 0 | Unable to write variant |
| 64489 | 0 | Script engine already running |
| 64490 | 0 | Not running |
| 64491 | 0 | update t_WebPublish set DelFlag = 1, moddate = getdate() where WebPublish_Code = :WebPublish_Code |
| 64492 | 0 | update t_WebPublish set DelFlag = 1, moddate = getdate() where WebPublish_Audit = 0 |
| 64493 | 0 | update t_WebPublish set DelFlag = 1, moddate = getdate() where WebPublish_Published = 1 |
| 64494 | 0 | Truncate table t_WebPublish |
| 64495 | 0 | select W.*, H.HomePage_Name, R.Realty_No, U.User_Name from (((t_WebPublish W inner join t_Realty R on W.Realty_Code = R.Realty_Code) inner join t_Homepage H on W.HomePage_Code = H.HomePage_Code) Left join t_User U on W.WebPublish_Publisher = U.User_Code) where W.DelFlag = 0 |
| 64496 | 0 | Divide by Zero |
| 64497 | 0 | Math Error |
| 64498 | 0 | Unsatisfied Forward %s |
| 64499 | 0 | Forward Parameter Mismatch |
| 64500 | 0 | Invalid number of parameters |
| 64501 | 0 | Unknown error |
| 64502 | 0 | Hint |
| 64503 | 0 | Variable '%s' never used |
| 64504 | 0 | Function '%s' never used |
| 64505 | 0 | Unknown hint |
| 64506 | 0 | Warning |
| 64507 | 0 | Calculation always evaluates to %s |
| 64508 | 0 | %s is not needed |
| 64509 | 0 | Abstract Class Construction |
| 64510 | 0 | Unknown warning |
| 64511 | 0 | Too many nested include files while processing '%s' from '%s' |
| 64512 | 0 | open round ('(')expected |
| 64513 | 0 | comma (',') expected |
| 64514 | 0 | 'TO' expected |
| 64515 | 0 | is ('=') expected |
| 64516 | 0 | 'OF' expected |
| 64517 | 0 | Close block(']') expected |
| 64518 | 0 | Variable Expected |
| 64519 | 0 | String Expected |
| 64520 | 0 | 'END' expected |
| 64521 | 0 | Label '%s' not set |
| 64522 | 0 | Not in a loop |
| 64523 | 0 | Invalid jump |
| 64524 | 0 | Open Block ('[') expected |
| 64525 | 0 | Write-only property |
| 64526 | 0 | Read-only property |
| 64527 | 0 | Class type expected |
| 64528 | 0 | Char error |
| 64529 | 0 | Syntax error |
| 64530 | 0 | Unexpected end of file |
| 64531 | 0 | Semicolon (';') expected |
| 64532 | 0 | 'BEGIN' expected |
| 64533 | 0 | period ('.') expected |
| 64534 | 0 | Duplicate identifier '%s' |
| 64535 | 0 | colon (':') expected |
| 64536 | 0 | Unknown type '%s' |
| 64537 | 0 | Close round expected |
| 64538 | 0 | Type mismatch |
| 64539 | 0 | Internal error (%s) |
| 64540 | 0 | Assignment expected |
| 64541 | 0 | 'THEN' expected |
| 64542 | 0 | 'DO' expected |
| 64543 | 0 | No result |
| 64544 | 0 | Cannot cast an interface |
| 64545 | 0 | Capacity < Length |
| 64546 | 0 | Nil interface |
| 64547 | 0 | Unknown method |
| 64548 | 0 | Expected return address at stack base |
| 64549 | 0 | This function can only be called from within the OnUses event |
| 64550 | 0 | Unable to register function %s |
| 64551 | 0 | Unable to register constant %s |
| 64552 | 0 | Invalid Type |
| 64553 | 0 | Unable to register type %s |
| 64554 | 0 | Unknown interface: %s |
| 64555 | 0 | Error |
| 64556 | 0 | Unknown identifier '%s' |
| 64557 | 0 | Identifier expected |
| 64558 | 0 | Comment error |
| 64559 | 0 | String error |
| 64560 | 0 | Out Of Range |
| 64561 | 0 | Out Of Stack Range |
| 64562 | 0 | Type Mismatch |
| 64563 | 0 | Unexpected End Of File |
| 64564 | 0 | Version error |
| 64565 | 0 | divide by Zero |
| 64566 | 0 | Math error |
| 64567 | 0 | Could not call proc |
| 64568 | 0 | Out of Record Fields Range |
| 64569 | 0 | Null Pointer Exception |
| 64570 | 0 | Null variant error |
| 64571 | 0 | Out Of Memory |
| 64572 | 0 | Interface not supported |
| 64573 | 0 | Unknown error |
| 64574 | 0 | Invalid array |
| 64575 | 0 | Out of string range |
| 64576 | 0 | select C.*, U.User_Name, Cp.Company_Code, Cp.Company_Name, CASE WHEN B.User_Code <> '' THEN CONVERT(bit, 1) END AS IsBlotter from ((t_Client as C with(NOLOCK) inner join t_User U on C.User_Code = U.User_Code) inner join t_Company Cp on U.Company_Code = Cp.Company_Code) left join (SELECT * FROM t_Blotter WHERE Blotter_Type = 1 and DelFlag = 0 and User_Code = '%s') B ON C.Client_Code = B.Blotter_PCode where C.TrashFlag = 0 |
| 64577 | 0 | and Client_Code = :Client_Code |
| 64578 | 0 | insert into t_Client (Client_Code, Client_No, Client_Name, Client_Linkman, Client_IDCard, Client_Address, Client_Tel, Client_LinkManTel, Client_Class, Client_Rating, Client_Country, Client_Trade, Client_State, Client_Secrecy, Client_Groom, Client_Usage, Client_FloorFrom, Client_FloorTo, Client_PFloor, Client_RClass, Client_Aspect, Client_Fitment, Client_Payment, Client_Configure, Client_Commision, City_Code, Client_District, District_Code, Client_Area, Area_Code, Client_Street, Client_RoomFrom, Client_RoomTo, Client_Hall, Client_Loo, Client_Balcony, Client_Vocation, Client_PUsage, Client_AcreageFrom, Client_AcreageTo, Client_PriceFrom, Client_PriceTo, Client_PriceUnit, Client_ConsignDate, Client_Source, Client_Remark, Client_RegUser, Client_ModUser, User_Code, DelFlag, TrashFlag, InDate, Client_LastFollowDate, ModDate) values (:Client_Code, :Client_No, :Client_Name, :Client_Linkman, :Client_IDCard, :Client_Address, :Client_Tel, :Client_Trade, :Client_Class, :Client_Rating, :Client_Country, :Client_Trade, :Client_State, :Client_Secrecy, :Client_Groom, :Client_Usage, :Client_FloorFrom, :Client_FloorTo, :Client_PFloor, :Client_RClass, :Client_Aspect, :Client_Fitment, :Client_Payment, :Client_Configure, :Client_Commision, :City_Code, :Client_District, :District_Code, :Client_Area, :Area_Code, :Client_Street, :Client_RoomFrom, :Client_RoomTo, :Client_Hall, :Client_Loo, :Client_Balcony, :Client_Vocation, :Client_PUsage, :Client_AcreageFrom, :Client_AcreageTo, :Client_PriceFrom, :Client_PriceTo, :Client_PriceUnit, :Client_ConsignDate, :Client_Source, :Client_Remark, :Client_RegUser, :Client_ModUser, :User_Code, 0, 0, getdate(), getdate(), getdate() ) |
| 64579 | 0 | update t_Client set Client_Name = :Client_Name, Client_Linkman = :Client_Linkman, Client_IDCard = :Client_IDCard, Client_Address = :Client_Address, Client_Tel = :Client_Tel, Client_LinkManTel = :Client_LinkManTel, Client_Class = :Client_Class, Client_No = :Client_No, Client_Rating = :Client_Rating, Client_Country = :Client_Country, Client_Trade = :Client_Trade, Client_State = :Client_State, Client_Secrecy = :Client_Secrecy, Client_Groom = :Client_Groom, Client_Usage = :Client_Usage, Client_FloorFrom = :Client_FloorFrom, Client_FloorTo = :Client_FloorTo, Client_PFloor = :Client_PFloor, Client_RClass = :Client_RClass, Client_Aspect = :Client_Aspect, Client_Fitment = :Client_Fitment, Client_Payment = :Client_Payment, Client_Configure = :Client_Configure, Client_Commision = :Client_Commision, Client_District = :Client_District, District_Code = :District_Code, Client_Area = :Client_Area, Area_Code = :Area_Code, Client_Street = :Client_Street, Client_RoomFrom = :Client_RoomFrom, Client_RoomTo = :Client_RoomTo, Client_Hall = :Client_Hall, Client_Loo = :Client_Loo, Client_Balcony = :Client_Balcony, Client_Vocation = :Client_Vocation, Client_PUsage = :Client_PUsage, Client_AcreageFrom = :Client_AcreageFrom, Client_AcreageTo = :Client_AcreageTo, Client_PriceFrom = :Client_PriceFrom, Client_PriceTo = :Client_PriceTo, Client_PriceUnit = :Client_PriceUnit, Client_ConsignDate = :Client_ConsignDate, Client_Source = :Client_Source, Client_Remark = :Client_Remark, Client_ModUser = :Client_ModUser, User_Code = :User_Code, ModDate = getdate() where Client_Code = :Client_Code |
| 64580 | 0 | Invalid float |
| 64581 | 0 | Exception: %s |
| 64582 | 0 | No Error |
| 64583 | 0 | Cannot Import %s |
| 64584 | 0 | Invalid Type |
| 64585 | 0 | Internal error |
| 64586 | 0 | Invalid Header |
| 64587 | 0 | Invalid Opcode |
| 64588 | 0 | Invalid Opcode Parameter |
| 64589 | 0 | no Main Proc |
| 64590 | 0 | Out of Global Vars range |
| 64591 | 0 | Out of Proc Range |
| 64592 | 0 | insert into t_HireCon (HireCon_Code, Hire_Code, Fee0, Fee1, Fee2, Fee3, Fee4, Fee5, Fee6, Fee7, HireCon_FeeDate, HireCon_Paid, HireCon_Remark, TrashFlag, Delflag, ModDate) values (:HireCon_Code, :Hire_Code, :Fee0, :Fee1, :Fee2, :Fee3, :Fee4, :Fee5, :Fee6, :Fee7, :HireCon_FeeDate, :HireCon_Paid, :HireCon_Remark, 0, 0, getdate()) |
| 64593 | 0 | update t_HireCon set Fee0 = :Fee0, Fee1 = :Fee1, Fee2 = :Fee2, Fee3 = :Fee3, Fee4 = :Fee4, Fee5 = :Fee5, Fee6 = :Fee6, Fee7 = :Fee7, HireCon_FeeDate = :HireCon_FeeDate, HireCon_Paid = :HireCon_Paid, HireCon_Remark = :HireCon_Remark, ModDate = getdate() where HireCon_Code = :HireCon_Code |
| 64594 | 0 | select * from t_HireAct where TrashFlag = 0 and DelFlag = 0 |
| 64595 | 0 | update t_HireAct set TrashFlag = 1, DelFlag = 1, moddate = getdate() where HireAct_Code = :HireAct_Code |
| 64596 | 0 | select *, t_Hire.Hire_Code, t_Hire.Hire_No, t_Hire.Trust_Code, t_Trust.Trust_No, t_Trust.Realty_No, t_Trust.Realty_Address, t_Hire.Hire_CustName, t_Hire.Hire_StartDate, t_Hire.Hire_EndDate, t_Hire.Hire_CustBank, t_Hire.Hire_CustAccount from t_HireAct INNER JOIN t_Hire ON t_HireAct.Hire_Code = t_Hire.Hire_Code INNER JOIN t_Trust ON t_Hire.Trust_Code = t_Trust.Trust_Code where t_HireAct.TrashFlag = 0 and t_HireAct.DelFlag = 0 |
| 64597 | 0 | and HireAct_Code = :HireAct_Code |
| 64598 | 0 | insert into t_HireAct (HireAct_Code, Hire_Code, Fee0, Fee1, Fee2, Fee3, Fee4, Fee5, Fee6, Fee7, HireAct_FeeDate, HireAct_Remark, HireAct_User, TrashFlag, Delflag, ModDate) values (:HireAct_Code, :Hire_Code, :Fee0, :Fee1, :Fee2, :Fee3, :Fee4, :Fee5, :Fee6, :Fee7, :HireAct_FeeDate, :HireAct_Remark, :HireAct_User, 0, 0, getdate()) |
| 64599 | 0 | update t_HireAct set Fee0 = :Fee0, Fee1 = :Fee1, Fee2 = :Fee2, Fee3 = :Fee3, Fee4 = :Fee4, Fee5 = :Fee5, Fee6 = :Fee6, Fee7 = :Fee7, HireAct_FeeDate = :HireAct_FeeDate, HireAct_Remark = :HireAct_Remark, ModDate = getdate() where HireAct_Code = :HireAct_Code |
| 64600 | 0 | select R.*, W.WorkBook_Name, U.Company_Code from t_Realty as R with(NOLOCK) inner join t_WorkBook W on R.WorkBook_Code = W.WorkBook_Code inner join t_User U on U.User_Code = R.User_Code where R.Delflag = 0 |
| 64601 | 0 | update t_Realty set TrashFlag = 1, modDate = getdate() where Realty_Code = :Realty_Code; update t_Awoke set TrashFlag = 1, DelFlag = 1, moddate = getdate() FROM t_Awoke INNER JOIN t_RealtyFollow ON t_Awoke.Awoke_Code = t_RealtyFollow.Follow_Code where Follow_PCode = :Realty_Code; update t_RealtyFollow set TrashFlag = 1, DelFlag = 1, modDate = getdate() where Follow_PCode = :Realty_Code; |
| 64602 | 0 | select U.User_Name, Cp.Company_Code, Cp.Company_Name, W.WorkBook_Name, W.WorkBook_PY, W.WorkBook_Address1, W.District_Code, A.Area_Code, A.Area_Name as AreaName, D.Area_Name AS DistrictName, R.*, CASE WHEN B.User_Code <> '' THEN CONVERT(bit, 1) END AS IsBlotter, (select count(*) FROM t_Image as I WHERE I.Image_PCode = R.Realty_Code and I.DelFlag = 0) as ImageCount from ((((t_Realty as R with(NOLOCK) inner join t_User U on R.User_Code = U.User_Code) inner join t_Company Cp on U.Company_Code = Cp.Company_Code) inner join t_WorkBook W on R.WorkBook_Code = W.WorkBook_Code) inner join t_Area D on W.District_Code = D.Area_Code) left join t_Area A on W.Area_Code = A.Area_Code left join (SELECT * FROM t_Blotter WHERE Blotter_Type = 0 and DelFlag = 0 and User_Code = '%s') B ON R.Realty_Code = B.Blotter_PCode where R.TrashFlag = 0 |
| 64603 | 0 | and Realty_Code = :Realty_Code |
| 64604 | 0 | insert into t_Realty (Realty_Code, Realty_No, City_Code, WorkBook_Code, Realty_Building, Realty_Chamber, Realty_Floor, Realty_TotalFloor, Realty_Room, Realty_Hall, Realty_Loo, Realty_Balcony, Realty_Usage, Realty_Class, Realty_Year, Realty_Aspect, Realty_BuildAcreage, Realty_UseAcreage, Realty_Trade , Realty_State, Realty_RentPrice, Realty_RentUnit, Realty_RentUnitPrice, Realty_RentLowprice, Realty_SellPrice, Realty_SellUnit, Realty_SellUnitPrice, Realty_SellLowprice, Realty_Tax, Realty_BasePrice, Realty_ConsignDate, Realty_Trust, Realty_ManagerPrice, Realty_HandOverDate, Realty_ConsignNo, Realty_Source, Realty_Occupy, Realty_Property, Realty_Fitment, Realty_Certificate, Realty_Configure, Realty_Payment, Realty_Furniture, Realty_Commision, Realty_Wiring, Realty_Look, Realty_KeyNo, Realty_Groom, Realty_Special, Realty_Secrecy, Realty_Owner, Realty_OwnerTel, Realty_Deputy, Realty_DeputyTel, Realty_Country, Realty_Remark, Realty_PUsage, Realty_Detail, Realty_RegUser, Realty_ModUser, User_Code, DelFlag, TrashFlag, InDate, Realty_LastFollowDate, ModDate) values (:Realty_Code, :Realty_No, :City_Code, :WorkBook_Code, :Realty_Building, :Realty_Chamber, :Realty_Floor, :Realty_TotalFloor, :Realty_Room, :Realty_Hall, :Realty_Loo, :Realty_Balcony, :Realty_Usage, :Realty_Class, :Realty_Year, :Realty_Aspect, :Realty_BuildAcreage, :Realty_UseAcreage, :Realty_Trade, :Realty_State, :Realty_RentPrice, :Realty_RentUnit, :Realty_RentUnitPrice, :Realty_RentLowprice, :Realty_SellPrice, :Realty_SellUnit, :Realty_SellUnitPrice, :Realty_SellLowprice, :Realty_Tax, :Realty_BasePrice, :Realty_ConsignDate, :Realty_Trust, :Realty_ManagerPrice, :Realty_HandOverDate, :Realty_ConsignNo, :Realty_Source, :Realty_Occupy, :Realty_Property, :Realty_Fitment, :Realty_Certificate, :Realty_Configure, :Realty_Payment, :Realty_Furniture, :Realty_Commision, :Realty_Wiring, :Realty_Look, :Realty_KeyNo, :Realty_Groom, :Realty_Special, :Realty_Secrecy, :Realty_Owner, :Realty_OwnerTel, :Realty_Deputy, :Realty_DeputyTel, :Realty_Country, :Realty_Remark, :Realty_PUsage, :Realty_Detail, :Realty_RegUser, :Realty_ModUser, :User_Code, 0, 0, getdate(), getdate(), getdate()) |
| 64605 | 0 | update t_Realty set WorkBook_Code = :WorkBook_Code, Realty_Building = :Realty_Building, Realty_No = :Realty_No, Realty_Chamber = :Realty_Chamber, Realty_Floor = :Realty_Floor, Realty_TotalFloor = :Realty_TotalFloor, Realty_Room = :Realty_Room, Realty_Hall = :Realty_Hall, Realty_Loo = :Realty_Loo, Realty_Balcony = :Realty_Balcony, Realty_Usage = :Realty_Usage, Realty_Class = :Realty_Class, Realty_Year = :Realty_Year, Realty_Aspect = :Realty_Aspect, Realty_BuildAcreage = :Realty_BuildAcreage, Realty_UseAcreage = :Realty_UseAcreage, Realty_Trade = :Realty_Trade, Realty_State = :Realty_State, Realty_RentPrice = :Realty_RentPrice, Realty_RentUnit = :Realty_RentUnit, Realty_RentUnitPrice = :Realty_RentUnitPrice, Realty_RentLowprice = :Realty_RentLowprice, Realty_SellPrice = :Realty_SellPrice, Realty_SellUnit = :Realty_SellUnit, Realty_SellUnitPrice = :Realty_SellUnitPrice, Realty_SellLowprice = :Realty_SellLowprice, Realty_Tax = :Realty_Tax, Realty_BasePrice = :Realty_BasePrice, Realty_ConsignDate = :Realty_ConsignDate, Realty_Trust = :Realty_Trust, Realty_ManagerPrice = :Realty_ManagerPrice, Realty_HandOverDate = :Realty_HandOverDate, Realty_ConsignNo = :Realty_ConsignNo, Realty_Source = :Realty_Source, Realty_Occupy = :Realty_Occupy, Realty_Property = :Realty_Property, Realty_Fitment = :Realty_Fitment, Realty_Certificate = :Realty_Certificate, Realty_Configure = :Realty_Configure, Realty_Payment = :Realty_Payment, Realty_Furniture = :Realty_Furniture, Realty_Commision = :Realty_Commision, Realty_Wiring = :Realty_Wiring, Realty_Look = :Realty_Look, Realty_KeyNo = :Realty_KeyNo, Realty_Groom = :Realty_Groom, Realty_Special = :Realty_Special, Realty_Secrecy = :Realty_Secrecy, Realty_Owner = :Realty_Owner, Realty_OwnerTel = :Realty_OwnerTel, Realty_Deputy = :Realty_Deputy, Realty_DeputyTel = :Realty_DeputyTel, Realty_Country = :Realty_Country, Realty_Remark = :Realty_Remark, Realty_PUsage = :Realty_PUsage, Realty_Detail = :Realty_Detail, Realty_ModUser = :Realty_ModUser, User_Code = :User_Code, ModDate = getdate() where Realty_Code = :Realty_Code |
| 64606 | 0 | select C.*, U.Company_Code from t_Client C INNER JOIN t_User U ON C.User_Code = U.User_Code where C.Delflag = 0 |
| 64607 | 0 | update t_Client set TrashFlag = 1, modDate = getdate() where Client_Code = :Client_Code; update t_Awoke set TrashFlag = 1, DelFlag = 1, moddate = getdate() FROM t_Awoke INNER JOIN t_ClientFollow ON t_Awoke.Awoke_Code = t_ClientFollow.Follow_Code where Follow_PCode = :Client_Code; update t_ClientFollow set TrashFlag = 1, DelFlag = 1, modDate = getdate() where Follow_PCode = :Client_Code; |
| 64608 | 0 | update t_TrustAct set TrashFlag = 1, DelFlag = 1, moddate = getdate() where TrustAct_Code = :TrustAct_Code |
| 64609 | 0 | SELECT t_TrustAct.TrustAct_Code, t_TrustAct.Trust_Code, t_TrustAct.TrustAct_Fee, t_TrustAct.TrustAct_Remark, t_Trust.Trust_No, t_Trust.Realty_No, t_TrustAct.TrustAct_PayDate, t_Trust.Realty_Address, t_Trust.Trust_OwnerName, t_Trust.Trust_OwnerBank, t_Trust.Trust_OwnerAccount, t_Trust.Trust_StartDate, t_Trust.Trust_EndDate from t_TrustAct INNER JOIN t_Trust ON t_TrustAct.Trust_Code = t_Trust.Trust_Code Where t_TrustAct.TrashFlag = 0 and t_TrustAct.DelFlag = 0 |
| 64610 | 0 | and TrustAct_Code = :TrustAct_Code |
| 64611 | 0 | insert into t_TrustAct (TrustAct_Code, Trust_Code, TrustAct_Fee, TrustAct_Remark, TrustAct_PayDate, TrashFlag, Delflag, ModDate) values (:TrustAct_Code, :Trust_Code, :TrustAct_Fee, :TrustAct_Remark, :TrustAct_PayDate, 0, 0, getdate()) |
| 64612 | 0 | update t_TrustAct set TrustAct_Fee = :TrustAct_Fee, TrustAct_Remark = :TrustAct_Remark, TrustAct_PayDate = :TrustAct_PayDate, ModDate = getdate() where TrustAct_Code = :TrustAct_Code |
| 64613 | 0 | select *, Trust_No, Realty_No, Realty_Address, Trust_OwnerName, C1.Company_Name as Company_Name1, U1.User_Name as User_name1 from ((t_Hire H inner join t_Trust T on H.Trust_Code = T.Trust_Code) Left join t_Company C1 on H.Company_Code = C1.Company_Code Left join t_User U1 on H.User_Code = U1.User_Code) where H.Delflag = 0 and H.TrashFlag = 0 |
| 64614 | 0 | select *, Trust_No, Realty_No, Realty_Address, Trust_OwnerName from (t_Hire H inner join t_Trust T on H.Trust_Code = T.Trust_Code) where H.Delflag = 0 and H.TrashFlag = 0 |
| 64615 | 0 | update t_Hire set TrashFlag = 1, DelFlag = 1, modDate = getdate() where Hire_Code = :Hire_Code; update t_HireCon set TrashFlag = 1, DelFlag = 1, modDate = getdate() where Hire_Code = :Hire_Code; update t_HireAct set TrashFlag = 1, DelFlag = 1, modDate = getdate() where Hire_Code = :Hire_Code; |
| 64616 | 0 | select H.*, Trust_No, Realty_No, Realty_Address, Trust_OwnerName, C1.Company_Name as Company_Name1, U1.User_Name as User_name1, C2.Company_Name as Company_Name2, U2.User_Name as User_name2, C3.Company_Name as Company_Name3, U3.User_Name as User_name3 from ((((t_Hire H inner join t_Trust T on H.Trust_Code = T.Trust_Code) Left join t_Company C1 on H.Company_Code = C1.Company_Code Left join t_User U1 on H.User_Code = U1.User_Code) Left join t_Company C2 on H.Hire_Company0 = C2.Company_Code Left join t_User U2 on H.Hire_User0 = U2.User_Code) Left join t_Company C3 on H.Hire_Company1 = C3.Company_Code Left join t_User U3 on H.Hire_User1 = U3.User_Code) where H.Delflag = 0 and H.TrashFlag = 0 |
| 64617 | 0 | and Hire_Code = :Hire_Code |
| 64618 | 0 | insert into t_Hire (Hire_Code, Trust_Code, Hire_No, Hire_CustName, Hire_CustIDCard, Hire_CustMobile, Hire_CustTel, Hire_CustAddress, Hire_CustBank, Hire_CustAccount, Hire_StartDate, Hire_EndDate, Hire_RentPrice, Hire_PayMode, Hire_RentTotal, Hire_RentDeposit, Hire_Comm, Hire_RentFreeDays, Company_Code, User_Code, Hire_Company0, Hire_User0, Hire_Comm0, Hire_Company1, Hire_User1, Hire_Comm1, Hire_Remark, Hire_RegUser, TrashFlag, DelFlag, InDate, ModDate)values (:Hire_Code, :Trust_Code, :Hire_No, :Hire_CustName, :Hire_CustIDCard, :Hire_CustMobile, :Hire_CustTel, :Hire_CustAddress, :Hire_CustBank, :Hire_CustAccount, :Hire_StartDate, :Hire_EndDate, :Hire_RentPrice, :Hire_PayMode, :Hire_RentTotal, :Hire_RentDeposit, :Hire_Fee, :Hire_RentFreeDays, :Company_Code, :User_Code, :Hire_Company0, :Hire_User0, :Hire_Comm0, :Hire_Company1, :Hire_User1, :Hire_Comm1, :Hire_Remark, :Hire_RegUser, 0, 0, getdate(), getdate()) |
| 64619 | 0 | update t_Hire set Trust_Code = :Trust_Code, Hire_No = :Hire_No, Hire_CustName = :Hire_CustName, Hire_CustIDCard = :Hire_CustIDCard, Hire_CustMobile = :Hire_CustMobile, Hire_CustTel = :Hire_CustTel, Hire_CustAddress = :Hire_CustAddress, Hire_CustBank = :Hire_CustBank, Hire_CustAccount = :Hire_CustAccount, Hire_StartDate = :Hire_StartDate, Hire_EndDate = :Hire_EndDate, Hire_RentPrice = :Hire_RentPrice, Hire_PayMode = :Hire_PayMode, Hire_RentTotal = :Hire_RentTotal, Hire_RentDeposit = :Hire_RentDeposit, Hire_Comm = :Hire_Comm, Hire_RentFreeDays = :Hire_RentFreeDays, Company_Code = :Company_Code, User_Code = :User_Code, Hire_Company0 = :Hire_Company0, Hire_User0 = :Hire_User0, Hire_Comm0 = :Hire_Comm0, Hire_Company1 = :Hire_Company1, Hire_User1 = :Hire_User1, Hire_Comm1 = :Hire_Comm1, Hire_Remark = :Hire_Remark, ModDate = getdate() where Hire_Code = :Hire_Code |
| 64620 | 0 | select * from t_HireCon where TrashFlag = 0 and DelFlag = 0 |
| 64621 | 0 | update t_HireCon set TrashFlag = 1, DelFlag = 1, moddate = getdate() where HireCon_Code = :HireCon_Code |
| 64622 | 0 | select *, t_Hire.Hire_Code, t_Hire.Hire_No, t_Hire.Trust_Code, t_Trust.Trust_No, t_Trust.Realty_No, t_Trust.Realty_Address, t_Hire.Hire_CustName, t_Hire.Hire_StartDate, t_Hire.Hire_EndDate, t_Hire.Hire_CustBank, t_Hire.Hire_CustAccount from t_HireCon INNER JOIN t_Hire ON t_HireCon.Hire_Code = t_Hire.Hire_Code INNER JOIN t_Trust ON t_Hire.Trust_Code = t_Trust.Trust_Code where t_HireCon.TrashFlag = 0 and t_HireCon.DelFlag = 0 |
| 64623 | 0 | and HireCon_Code = :HireCon_Code |
| 64624 | 0 | insert into t_KeyLend (KeyLend_Code, Realty_Code, User_Code, KeyLend_Flag, Company_Name, User_Name, KeyLend_Back, KeyLend_LendDate, KeyLend_BackDate, KeyLend_Content, InDate, ModDate, NewDate, DelFlag, TrashFlag) values (:KeyLend_Code, :Realty_Code, :User_Code, :KeyLend_Flag, :Company_Name, :User_Name, :KeyLend_Back, :KeyLend_LendDate, :KeyLend_BackDate, :KeyLend_Content, getdate(), getdate(), getdate(), 0, 0 ) |
| 64625 | 0 | update t_KeyLend set KeyLend_Code = :KeyLend_Code, Realty_Code = :Realty_Code, User_Code = :User_Code, KeyLend_Flag = :KeyLend_Flag, Company_Name = :Company_Name, User_Name = :User_Name, KeyLend_Back = :KeyLend_Back, KeyLend_LendDate = :KeyLend_LendDate, KeyLend_BackDate = :KeyLend_BackDate, KeyLend_Content = :KeyLend_Content, ModDate = getdate() where KeyLend_Code = :KeyLend_Code |
| 64626 | 0 | select Trust_Code, Trust_No, Realty_No, Realty_Address, Trust_StartDate, Trust_EndDate, Trust_OwnerName from t_Trust where TrashFlag = 0 and DelFlag = 0 |
| 64627 | 0 | select * from t_Trust where Delflag = 0 and TrashFlag = 0 |
| 64628 | 0 | update t_Trust set TrashFlag = 1, DelFlag = 1, modDate = getdate() where Trust_Code = :Trust_Code; update t_TrustCon set TrashFlag = 1, DelFlag = 1, modDate = getdate() where Trust_Code = :Trust_Code; update t_TrustAct set TrashFlag = 1, DelFlag = 1, modDate = getdate() where Trust_Code = :Trust_Code; |
| 64629 | 0 | select T.*, C1.Company_Name as Company_Name1, U1.User_Name as User_name1, C2.Company_Name as Company_Name2, U2.User_Name as User_name2, C3.Company_Name as Company_Name3, U3.User_Name as User_name3 from (((t_Trust T Left join t_Company C1 on T.Company_Code = C1.Company_Code Left join t_User U1 on T.User_Code = U1.User_Code) Left join t_Company C2 on T.Trust_Company0 = C2.Company_Code Left join t_User U2 on T.Trust_User0 = U2.User_Code) Left join t_Company C3 on T.Trust_Company1 = C3.Company_Code Left join t_User U3 on T.Trust_User1 = U3.User_Code) where T.Delflag = 0 and T.TrashFlag = 0 |
| 64630 | 0 | and Trust_Code = :Trust_Code |
| 64631 | 0 | insert into t_Trust (Trust_Code, Realty_Code, Trust_No, Realty_No, Realty_Address, Trust_OwnerName, Trust_OwnerTel, Trust_OwnerMobile, Trust_OwnerAddress, Trust_OwnerIDCard, Trust_OwnerBank, Trust_OwnerAccount, Trust_StartDate, Trust_EndDate, Trust_RentPrice, Trust_RentFreeDays, Trust_RentTotal, Trust_RentDeposit, Trust_PayMode, Company_Code, User_Code, Trust_Comm, Trust_Company0, Trust_User0, Trust_Comm0, Trust_Company1, Trust_User1, Trust_Comm1, Trust_Description, Trust_Remark, Trust_RegUser, TrashFlag, DelFlag, InDate, ModDate) values (:Trust_Code, :Realty_Code, :Trust_No, :Realty_No, :Realty_Address, :Trust_OwnerName, :Trust_OwnerTel, :Trust_OwnerMobile, :Trust_OwnerAddress, :Trust_OwnerIDCard, :Trust_OwnerBank, :Trust_OwnerAccount, :Trust_StartDate, :Trust_EndDate, :Trust_RentPrice, :Trust_RentFreeDays, :Trust_RentTotal, :Trust_RentDeposit, :Trust_PayMode, :Company_Code, :User_Code, :Trust_Comm, :Trust_Company0, :Trust_User0, :Trust_Comm0, :Trust_Company1, :Trust_User1, :Trust_Comm1, :Trust_Description, :Trust_Remark, :Trust_RegUser, 0, 0, getdate(), getdate()) |
| 64632 | 0 | update t_Trust set Realty_Code = :Realty_Code, Trust_No = :Trust_No, Realty_No = :Realty_No, Realty_Address = :Realty_Address, Trust_OwnerName = :Trust_OwnerName, Trust_OwnerTel = :Trust_OwnerTel, Trust_OwnerMobile = :Trust_OwnerMobile, Trust_OwnerAddress = :Trust_OwnerAddress, Trust_OwnerIDCard = :Trust_OwnerIDCard, Trust_OwnerBank = :Trust_OwnerBank, Trust_OwnerAccount = :Trust_OwnerAccount, Trust_StartDate = :Trust_StartDate, Trust_EndDate = :Trust_EndDate, Trust_RentPrice = :Trust_RentPrice, Trust_RentFreeDays = :Trust_RentFreeDays, Trust_RentTotal = :Trust_RentTotal, Trust_RentDeposit = :Trust_RentDeposit, Trust_PayMode = :Trust_PayMode, Company_Code = :Company_Code, User_Code = :User_Code, Trust_Comm = :Trust_Comm, Trust_Company0 = :Trust_Company0, Trust_User0 = :Trust_User0, Trust_Comm0 = :Trust_Comm0, Trust_Company1 = :Trust_Company1, Trust_User1 = :Trust_User1, Trust_Comm1 = :Trust_Comm1, Trust_Description = :Trust_Description, Trust_Remark = :Trust_Remark, ModDate = getdate() where Trust_Code = :Trust_Code |
| 64633 | 0 | select * from t_TrustCon where TrashFlag = 0 and DelFlag = 0 |
| 64634 | 0 | update t_TrustCon set TrashFlag = 1, DelFlag = 1, moddate = getdate() where TrustCon_Code = :TrustCon_Code |
| 64635 | 0 | SELECT t_TrustCon.TrustCon_Code, t_TrustCon.Trust_Code, t_TrustCon.TrustCon_Fee, t_TrustCon.TrustCon_Remark, t_Trust.Trust_No, t_Trust.Realty_No, t_TrustCon.TrustCon_PayDate, t_TrustCon.TrustCon_Paid, t_Trust.Realty_Address, t_Trust.Trust_OwnerName, t_Trust.Trust_OwnerBank, t_Trust.Trust_OwnerAccount, t_Trust.Trust_StartDate, t_Trust.Trust_EndDate from t_TrustCon INNER JOIN t_Trust ON t_TrustCon.Trust_Code = t_Trust.Trust_Code Where t_TrustCon.TrashFlag = 0 and t_TrustCon.DelFlag = 0 |
| 64636 | 0 | and TrustCon_Code = :TrustCon_Code |
| 64637 | 0 | insert into t_TrustCon (TrustCon_Code, Trust_Code, TrustCon_Fee, TrustCon_Remark, TrustCon_PayDate, TrustCon_Paid, TrashFlag, Delflag, ModDate) values (:TrustCon_Code, :Trust_Code, :TrustCon_Fee, :TrustCon_Remark, :TrustCon_PayDate, :TrustCon_Paid, 0, 0, getdate()) |
| 64638 | 0 | update t_TrustCon set TrustCon_Fee = :TrustCon_Fee, TrustCon_Remark = :TrustCon_Remark, TrustCon_PayDate = :TrustCon_PayDate, TrustCon_Paid = :TrustCon_Paid, ModDate = getdate() where TrustCon_Code = :TrustCon_Code |
| 64639 | 0 | select * from t_TrustAct where TrashFlag = 0 and DelFlag = 0 |
| 64640 | 0 | update t_Contract set Contract_No = :Contract_No, Contract_Trade = :Contract_Trade, Contract_Usage = :Contract_Usage, Contract_Type = :Contract_Type, Contract_ConsignNo = :Contract_ConsignNo, Contract_CertNo = :Contract_CertNo, Contract_Status = :Contract_Status, Contract_Price = :Contract_Price, Contract_Date = :Contract_Date, Contract_EndDate = :Contract_EndDate, Company_Code = :Company_Code, User_Code = :User_Code, Realty_No = :Realty_No, Contract_Address = :Contract_Address, Contract_Square = :Contract_Square, Contract_PriceUnit = :Contract_PriceUnit, Contract_Floor = :Contract_Floor, Contract_OwnerName = :Contract_OwnerName, Contract_OwnerTel = :Contract_OwnerTel, Contract_OwnerAddress = :Contract_OwnerAddress, Contract_OwnerIDCard = :Contract_OwnerIDCard, Contract_OwnerCountry = :Contract_OwnerCountry, Contract_OwnerZip = :Contract_OwnerZip, Contract_ClientName = :Contract_ClientName, Contract_ClientTel = :Contract_ClientTel, Contract_ClientAddress = :Contract_ClientAddress, Contract_ClientIDCard = :Contract_ClientIDCard, Contract_ClientCountry = :Contract_ClientCountry, Contract_ClientZip = :Contract_ClientZip, Contract_BuyIn = :Contract_BuyIn, Contract_SellOut = :Contract_SellOut, FlowType_Code = :FlowType_Code, FlowCompany_Code = :FlowCompany_Code, FlowUser_Code = :FlowUser_Code, Contract_Remark = :Contract_Remark, Contract_Term = :Contract_Term, Contract_AuditNote1 = :Contract_AuditNote1, Contract_AuditNote2 = :Contract_AuditNote2, Contract_PayMode = :Contract_PayMode, Contract_LoanSelf = :Contract_LoanSelf, Contract_TranFee = :Contract_TranFee, Contract_MortBank = :Contract_MortBank, Contract_MortMoney = :Contract_MortMoney, Contract_MortYears = :Contract_MortYears, Contract_MortDate = :Contract_MortDate, Contract_MortBankG = :Contract_MortBankG, Contract_MortMoneyG = :Contract_MortMoneyG, Contract_MortYearsG = :Contract_MortYearsG, Contract_MortDateG = :Contract_MortDateG, Contract_EvaCompany = :Contract_EvaCompany, Contract_EvaMoney = :Contract_EvaMoney, Contract_EvaDate = :Contract_EvaDate, Contract_InsCompany = :Contract_InsCompany, Contract_InsMoney = :Contract_InsMoney, Contract_InsDate = :Contract_InsDate, Contract_AssCompany = :Contract_AssCompany, Contract_AssMoney = :Contract_AssMoney, Contract_AssDate = :Contract_AssDate, Contract_Content = :Contract_Content, Contract_LoanDetail = :Contract_LoanDetail, Contract_AllTotal = :Contract_AllTotal, Contract_AllTotalAct = :Contract_AllTotalAct, Contract_FeeTotal = :Contract_FeeTotal, Contract_FeeTotalAct = :Contract_FeeTotalAct, Contract_FeeOwner = :Contract_FeeOwner, Contract_FeeOwnerAct = :Contract_FeeOwnerAct, Contract_FeeClient = :Contract_FeeClient, Contract_FeeClientAct = :Contract_FeeClientAct, Contract_CommDate = :Contract_CommDate, Contract_BalanceDate = :Contract_BalanceDate, Contract_ModUser = :Contract_ModUser, Contract_AuditUser = :Contract_AuditUser, Contract_Audit = :Contract_Audit, Contract_AuditDate = :Contract_AuditDate, ModDate = getdate() where Contract_Code = :Contract_Code |
| 64641 | 0 | update t_ContractCon set DelFlag = 1, moddate = getdate() where ContractCon_Code = :ContractCon_Code |
| 64642 | 0 | select CC.*, Contract_No, Contract_Date, Realty_No, Contract_Trade, Contract_Address, Contract_OwnerName, Contract_ClientName, Contract_CommDate, Contract_BalanceDate from t_ContractCon CC inner join t_Contract C on C.Contract_Code = CC.Contract_Code where CC.DelFlag = 0 |
| 64643 | 0 | select * from t_ContractCon where DelFlag = 0 |
| 64644 | 0 | and ContractCon_Code = :ContractCon_Code |
| 64645 | 0 | insert into t_ContractCon (ContractCon_Code, Contract_Code, ContractCon_FeeSource, ContractCon_FeeObject, ContractCon_FeeType, ContractCon_Money0, ContractCon_Money1, ContractCon_FeeDate, ContractCon_Status, ContractCon_Remark, Delflag, ModDate) values (:ContractCon_Code, :Contract_Code, :ContractCon_FeeSource, :ContractCon_FeeObject, :ContractCon_FeeType, :ContractCon_Money0, :ContractCon_Money1, :ContractCon_FeeDate, :ContractCon_Status, :ContractCon_Remark, 0, getdate() ) |
| 64646 | 0 | update t_ContractCon set ContractCon_FeeSource = :ContractCon_FeeSource, ContractCon_FeeObject = :ContractCon_FeeObject, ContractCon_FeeType = :ContractCon_FeeType, ContractCon_Money0 = :ContractCon_Money0, ContractCon_Money1 = :ContractCon_Money1, ContractCon_FeeDate = :ContractCon_FeeDate, ContractCon_Status = :ContractCon_Status, ContractCon_Remark = :ContractCon_Remark, ModDate = getdate() where ContractCon_Code = :ContractCon_Code |
| 64647 | 0 | update t_ContractAct set DelFlag = 1, moddate = getdate() where ContractAct_Code = :ContractAct_Code |
| 64648 | 0 | select CA.*, Contract_No, Contract_Date, Realty_No, Contract_Trade, Contract_Address, Contract_OwnerName, Contract_ClientName, Contract_CommDate, Contract_BalanceDate from t_ContractAct CA inner join t_Contract C on C.Contract_Code = CA.Contract_Code where CA.DelFlag = 0 |
| 64649 | 0 | select * from t_ContractAct where DelFlag = 0 |
| 64650 | 0 | and ContractAct_Code = :ContractAct_Code |
| 64651 | 0 | insert into t_ContractAct (ContractAct_Code, Contract_Code, ContractAct_FeeSource, ContractAct_FeeObject, ContractAct_FeeType, ContractAct_Money0, ContractAct_Money1, ContractAct_FeeDate, ContractAct_Status, ContractAct_Remark, ContractAct_FeeCenter, ContractAct_CashType, ContractAct_ReceiptNo, ContractAct_FeePerson, Delflag, ModDate) values (:ContractAct_Code, :Contract_Code, :ContractAct_FeeSource, :ContractAct_FeeObject, :ContractAct_FeeType, :ContractAct_Money0, :ContractAct_Money1, :ContractAct_FeeDate, :ContractAct_Status, :ContractAct_Remark, :ContractAct_FeeCenter, :ContractAct_CashType, :ContractAct_ReceiptNo, :ContractAct_FeePerson, 0, getdate() ) |
| 64652 | 0 | update t_ContractAct set ContractAct_FeeSource = :ContractAct_FeeSource, ContractAct_FeeObject = :ContractAct_FeeObject, ContractAct_FeeType = :ContractAct_FeeType, ContractAct_Money0 = :ContractAct_Money0, ContractAct_Money1 = :ContractAct_Money1, ContractAct_FeeDate = :ContractAct_FeeDate, ContractAct_Status = :ContractAct_Status, ContractAct_Remark = :ContractAct_Remark, ContractAct_FeeCenter = :ContractAct_FeeCenter, ContractAct_CashType = :ContractAct_CashType, ContractAct_ReceiptNo = :ContractAct_ReceiptNo, ContractAct_FeePerson = :ContractAct_FeePerson, ModDate = getdate() where ContractAct_Code = :ContractAct_Code |
| 64653 | 0 | update t_KeyLend set TrashFlag = 1, DelFlag = 1, ModDate = getdate() where KeyLend_Code = :KeyLend_Code |
| 64654 | 0 | select K.*, C.Company_Name as InputCom, U.User_Name as InputUser from (t_KeyLend as K INNER JOIN t_User as U ON K.User_Code = U.User_Code) INNER JOIN t_Company as C ON U.Company_Code = C.Company_Code where K.DelFlag = 0 and K.TrashFlag = 0 |
| 64655 | 0 | and KeyLend_Code = :KeyLend_Code |
| 64656 | 0 | and Intent_Code = :Intent_Code |
| 64657 | 0 | insert into t_Intent (Intent_Code, Realty_Code, Client_Code, User_Code, Intent_Content, Delflag, TrashFlag, ModDate, NewDate) values (:Intent_Code, :Realty_Code, :Client_Code, :User_Code, :Intent_Content, 0, 0, getdate(), getdate() ) |
| 64658 | 0 | update t_Intent set Client_Code = :Client_Code, User_Code = :User_Code, Intent_Content = :Intent_Content, ModDate = getdate() where Intent_Code = :Intent_Code |
| 64659 | 0 | update t_FolTask set trashflag =1, DelFlag = 1, ModDate= getdate() where FolTask_code = :FolTask_Code |
| 64660 | 0 | select F.*, F.User_Perform as User_Code, R.Realty_Code, R.Realty_Building, R.Realty_Trade, R.Realty_Chamber, W.WorkBook_Code, W.WorkBook_Name, A.User_Code, A.User_Name as User_NameAll, P.Company_Code as Company_Code, P.User_Code, P.User_Name as User_NamePer, C.User_Code, C.User_Name as User_NameCom from ((((t_FolTask as F inner join t_Realty AS R ON F.FolTask_PCode = R.Realty_Code) inner join t_WorkBook as W on R.WorkBook_Code = W.WorkBook_Code) inner join t_User as A on F.User_Allot = A.User_Code) inner join t_User AS P on F.User_Perform = P.User_Code) inner join t_User AS C on F.User_Complete = C.User_Code where F.delflag = 0 and F.TrashFlag = 0 |
| 64661 | 0 | select F.*, F.User_Perform as User_Code, K.Client_Code, K.Client_trade, K.Client_Name, K.Client_District, K.District_Code, K.Client_Area, K.Area_Code, K.Client_Street, A.User_Code, P.Company_Code as Company_Code, P.User_Code, C.User_Code, A.User_Name as User_NameAll , P.User_Name as User_NamePer, C.User_Name as User_NameCom from (((t_FolTask AS F inner join t_Client AS K ON F.FolTask_PCode = K.Client_Code) inner join t_User as A on F.User_Allot = A.User_Code) inner join t_User AS P on F.User_Perform = P.User_Code) inner join t_User AS C on F.User_Complete = C.User_Code where F.delflag = 0 and F.TrashFlag = 0 |
| 64662 | 0 | and FolTask_Code = :FolTask_Code |
| 64663 | 0 | insert into t_FolTask (FolTask_Code, FolTask_PCode, FolTask_Type, User_Allot, User_Perform, User_Complete, FolTask_DateAllot, FolTask_DatePerform, FolTask_DateComplete, FolTask_MemoAllot, FolTask_Complete, FolTask_MemoComplete, delflag, InDate, ModDate) values (:FolTask_Code, :FolTask_PCode, :FolTask_Type, :User_Allot, :User_Perform, :User_Complete, :FolTask_DateAllot, :FolTask_DatePerform, :FolTask_DateComplete, :FolTask_MemoAllot, :FolTask_Complete, :FolTask_MemoComplete, 0, getdate(), getdate()) |
| 64664 | 0 | update t_FolTask set User_Allot = :User_Allot, User_Perform = :User_Perform, User_Complete = :User_Complete, FolTask_DateAllot = :FolTask_DateAllot, FolTask_DatePerform = :FolTask_DatePerform, FolTask_DateComplete = :FolTask_DateComplete, FolTask_Complete = :FolTask_Complete, FolTask_MemoComplete = :FolTask_MemoComplete, FolTask_MemoAllot = :FolTask_MemoAllot, ModDate = getdate() where FolTask_Code = :FolTask_Code |
| 64665 | 0 | select (select sum(ContractCon_Money0) from t_ContractCon where DelFlag = 0 And Contract_Code = '%0:s') as AllTotal, (select sum(ContractAct_Money0) from t_ContractAct where DelFlag = 0 And Contract_Code = '%0:s') as AllTotalAct, (select sum(ContractCon_Money0) - Sum(ContractCon_Money1) from t_ContractCon where DelFlag = 0 And Contract_Code = '%0:s' And ContractCon_FeeSource = '业主' And ContractCon_FeeType in (select FeeType_Name from t_FeeType where FeeType_Kind = 3)) as FeeOwner, (select sum(ContractAct_Money0) - Sum(ContractAct_Money1) from t_ContractAct where DelFlag = 0 And Contract_Code = '%0:s' And ContractAct_FeeSource = '业主' And ContractAct_FeeType in (select FeeType_Name from t_FeeType where FeeType_Kind = 3)) as FeeOwnerAct, (select sum(ContractCon_Money0) - Sum(ContractCon_Money1) from t_ContractCon where DelFlag = 0 And Contract_Code = '%0:s' And ContractCon_FeeSource = '客户' And ContractCon_FeeType in (select FeeType_Name from t_FeeType where FeeType_Kind = 3)) as FeeClient, (select sum(ContractAct_Money0) - Sum(ContractAct_Money1) from t_ContractAct where DelFlag = 0 And Contract_Code = '%0:s' And ContractAct_FeeSource = '客户' And ContractAct_FeeType in (select FeeType_Name from t_FeeType where FeeType_Kind = 3)) as FeeClientAct |
| 64666 | 0 | select * from t_Contract where DelFlag = 0 |
| 64667 | 0 | and Contract_Code = :Contract_Code |
| 64668 | 0 | update t_Contract set DelFlag = 1, ModDate = getdate() where Contract_Code = :Contract_Code; update t_ContractComm set DelFlag = 1, moddate = getdate() where Contract_Code = :Contract_Code; update t_Flow set DelFlag = 1, moddate = getdate() where Contract_Code = :Contract_Code; update t_ContractFollow set TrashFlag = 1, DelFlag = 1, modDate = getdate() where Follow_PCode = :Contract_Code; |
| 64669 | 0 | select c.*, F.FlowType_Name, C1.Company_Name as CompanyName, U1.User_Name as UserName, C2.Company_Name as FlowCompany_Name, U2.User_Name as FlowUser_Name from t_Contract C Left join t_Company C1 on C.Company_Code = C1.Company_Code Left Join t_User U1 on C.User_Code = U1.User_Code Left join t_FlowType F on C.FlowType_Code = F.FlowType_Code left Join t_Company C2 on C.FlowCompany_Code = C2.Company_Code Left Join t_User U2 on C.FlowUser_Code = U2.User_Code where C.DelFlag = 0 |
| 64670 | 0 | and C.Contract_Code = :Contract_Code |
| 64671 | 0 | insert into t_Contract (Contract_Code, Contract_No, Contract_Trade, Contract_Usage, Contract_Type, Contract_ConsignNo, Contract_CertNo, Contract_Status, Contract_Price, Contract_Date, Contract_EndDate, Company_Code, User_Code, Realty_Code, Realty_No, Contract_Address, Contract_Square, Contract_PriceUnit, Contract_Floor, Contract_OwnerName, Contract_OwnerTel, Contract_OwnerAddress, Contract_OwnerIDCard, Contract_OwnerCountry, Contract_OwnerZip, Contract_ClientName, Contract_ClientTel, Contract_ClientAddress, Contract_ClientIDCard, Contract_ClientCountry, Contract_ClientZip, Contract_BuyIn, Contract_SellOut, Contract_Remark, Contract_Term, Contract_AuditNote1, Contract_AuditNote2, FlowType_Code, FlowCompany_Code, FlowUser_Code, Contract_PayMode, Contract_LoanSelf, Contract_TranFee, Contract_MortBank, Contract_MortMoney, Contract_MortYears, Contract_MortDate, Contract_MortBankG, Contract_MortMoneyG, Contract_MortYearsG, Contract_MortDateG, Contract_EvaCompany, Contract_EvaMoney, Contract_EvaDate, Contract_InsCompany, Contract_InsMoney, Contract_InsDate, Contract_AssCompany, Contract_AssMoney, Contract_AssDate, Contract_Content, Contract_LoanDetail, Contract_AllTotal, Contract_AllTotalAct, Contract_FeeTotal, Contract_FeeTotalAct, Contract_FeeOwner, Contract_FeeOwnerAct, Contract_FeeClient, Contract_FeeClientAct, Contract_CommDate, Contract_BalanceDate, Contract_RegUser, Contract_ModUser, Contract_AuditUser, InDate, Contract_AuditDate, Contract_Audit, DelFlag, ModDate) values (:Contract_Code, :Contract_No, :Contract_Trade, :Contract_Usage, :Contract_Type, :Contract_ConsignNo, :Contract_CertNo, :Contract_Status, :Contract_Price, :Contract_Date, :Contract_EndDate, :Company_Code, :User_Code, :Realty_Code, :Realty_No, :Contract_Address, :Contract_Square, :Contract_PriceUnit, :Contract_Floor, :Contract_OwnerName, :Contract_OwnerTel, :Contract_OwnerAddress, :Contract_OwnerIDCard, :Contract_OwnerCountry, :Contract_OwnerZip, :Contract_ClientName, :Contract_ClientTel, :Contract_ClientAddress, :Contract_ClientIDCard, :Contract_ClientCountry, :Contract_ClientZip, :Contract_BuyIn, :Contract_SellOut, :Contract_Remark, :Contract_Term, :Contract_AuditNote1, :Contract_AuditNote2, :FlowType_Code, :FlowCompany_Code, :FlowUser_Code, :Contract_PayMode, :Contract_LoanSelf, :Contract_TranFee, :Contract_MortBank, :Contract_MortMoney, :Contract_MortYears, :Contract_MortDate, :Contract_MortBankG, :Contract_MortMoneyG, :Contract_MortYearsG, :Contract_MortDateG, :Contract_EvaCompany, :Contract_EvaMoney, :Contract_EvaDate, :Contract_InsCompany, :Contract_InsMoney, :Contract_InsDate, :Contract_AssCompany, :Contract_AssMoney, :Contract_AssDate, :Contract_Content, :Contract_LoanDetail, :Contract_AllTotal, :Contract_AllTotalAct, :Contract_FeeTotal, :Contract_FeeTotalAct, :Contract_FeeOwner, :Contract_FeeOwnerAct, :Contract_FeeClient, :Contract_FeeClientAct, :Contract_CommDate, :Contract_BalanceDate, :Contract_RegUser, :Contract_ModUser, :Contract_AuditUser, getdate(), getdate(), 0, 0, getdate() ) |
| 64672 | 0 | select DRF.*, U.Company_Code, DR.DatumRealty_Code, U.User_Name as User_Name from (t_DatumRealtyFollow as DRF INNER JOIN t_DatumRealty as DR ON DRF.Follow_PCode = DR.DatumRealty_Code) INNER JOIN t_User as U ON DRF.User_Code = U.User_Code where DRF.DelFlag = 0 and DRF.TrashFlag = 0 and DR.DelFlag = 0 and DR.TrashFlag = 0 |
| 64673 | 0 | and Follow_Code = :Follow_Code |
| 64674 | 0 | insert into %s (Follow_Code, Follow_PCode, User_Code, Follow_Mode, Follow_Text, Follow_Awoke, Follow_AwokeArea, Follow_AwokeText, Follow_AwokeDate, Follow_ShowStyle, Delflag, TrashFlag, InDate, ModDate, NewDate) values (:Follow_Code, :Follow_PCode, :User_Code, :Follow_Mode, :Follow_Text, :Follow_Awoke, :Follow_AwokeArea, :Follow_AwokeText, :Follow_AwokeDate, :Follow_ShowStyle, 0, 0, getdate(), getdate(), getdate() ); |
| 64675 | 0 | update t_Realty set Realty_LastFollowDate = getdate() where Realty_Code = :Follow_PCode; |
| 64676 | 0 | update t_Client set Client_LastFollowDate = getdate() where Client_Code = :Follow_PCode; |
| 64677 | 0 | update t_DatumRealty set Realty_LastFollowDate = getdate() where DatumRealty_Code = :Follow_PCode; |
| 64678 | 0 | update %s set User_Code = :User_Code, Follow_Mode = :Follow_Mode, Follow_Text = :Follow_Text, Follow_Awoke = :Follow_Awoke, Follow_AwokeArea = :Follow_AwokeArea, Follow_AwokeDate = :Follow_AwokeDate, Follow_AwokeText = :Follow_AwokeText, ModDate = getdate() where Follow_Code = :Follow_Code; |
| 64679 | 0 | select R.Realty_No, R.Realty_Trade, R.Realty_Chamber, R.Realty_Building, R.Realty_Room, W.WorkBook_Name, R.Realty_Hall, R.Realty_BuildAcreage, R.Realty_State, R.Realty_ConsignDate, R.Realty_Loo, R.Realty_Balcony, R.Realty_Chamber, R.Realty_Code, R.Realty_Usage, R.Realty_RentUnitPrice, R.Realty_SellUnitPrice, R.Realty_Floor, R.Realty_Owner, R.Realty_OwnerTel, R.Realty_Country, R.User_Code, U.Company_Code, A1.Area_Name as Area_Name, A1.Area_Code, W.WorkBook_PY, A2.Area_Name as City_Name, A2.Area_Code, R.Realty_LastFollowDate, R.Realty_Groom, R.Realty_Special, R.Realty_Remark, R.Realty_ConsignNo from (((t_Realty AS R INNER JOIN t_WorkBook W on R.WorkBook_Code = W.WorkBook_Code) inner join t_Area A2 on W.District_Code = A2.Area_Code) left join t_Area A1 on W.Area_Code = A1.Area_Code) INNER JOIN t_User AS U ON R.User_Code = U.User_Code where R.DelFlag = 0 and R.TrashFlag = 0 |
| 64680 | 0 | and Realty_Code = :Realty_Code |
| 64681 | 0 | select C.Client_No, C.Client_Name, C.Client_Trade, C.Client_District, C.District_Code, C.Area_Code, C.Client_Street, C.Client_State, C.Client_ConsignDate, C.Client_Code, U.User_Name, C1.Company_Name, U.Company_Code, C.Client_LastFollowDate, C.Client_Groom from (t_Client AS C INNER JOIN t_User AS U ON C.User_Code = U.User_Code) INNER JOIN t_Company AS C1 ON U.Company_Code = C1.Company_Code where C.delflag = 0 and C.TrashFlag = 0 |
| 64682 | 0 | and Client_Code = :Client_Code |
| 64683 | 0 | update t_Intent set trashflag =1, DelFlag = 1, ModDate =getdate() where Intent_code = :Intent_Code |
| 64684 | 0 | select I.*, I.User_Code AS User_Code, U.Company_Code AS Company_Code, R.Realty_No, U2.Company_Code, U1.Company_Code, W.WorkBook_Name, R.Realty_Building, R.Realty_Trade, C.Client_Trade, R.Realty_Room, R.Realty_Hall, R.Realty_Loo, R.Realty_Balcony, R.Realty_BuildAcreage, C.Client_No, W.WorkBook_PY, C.Client_Name, C1.Company_Name, U.User_Name, U.Company_Code, A2.Area_Name AS City_Name, A1.Area_Name AS Area_Name, R.User_Code, C.User_Code from ((((((t_Intent AS I INNER JOIN t_Client AS C ON I.Client_Code = C.Client_Code) INNER JOIN (t_Realty AS R INNER JOIN t_WorkBook AS W ON R.WorkBook_Code = W.WorkBook_Code) ON I.Realty_Code = R.Realty_Code) INNER JOIN (t_User AS U INNER JOIN t_Company AS C1 ON U.Company_Code = C1.Company_Code) ON I.User_Code = U.User_Code) INNER JOIN t_Area AS A2 ON W.District_Code = A2.Area_Code) LEFT JOIN t_Area AS A1 ON W.Area_Code = A1.Area_Code) INNER JOIN t_User AS U1 ON R.User_Code = U1.User_Code) INNER JOIN t_User AS U2 ON C.User_Code = U2.User_Code WHERE (((I.DelFlag)=0) AND ((I.TrashFlag)=0)) |
| 64685 | 0 | and Intent_Code = :Intent_Code |
| 64686 | 0 | select I.*, I.User_Code as User_Code, U.Company_Code as Company_Code, R.Realty_No, W.WorkBook_Name, R.Realty_Trade, R.Realty_State, U.User_Name FROM ((t_Intent AS I INNER JOIN t_Realty AS R ON I.Realty_Code = R.Realty_Code) INNER JOIN t_WorkBook AS W ON R.WorkBook_Code = W.WorkBook_Code) INNER JOIN t_User AS U ON I.User_Code = U.User_Code where I.DelFlag = 0 and I.TrashFlag = 0 |
| 64687 | 0 | select I.*, I.User_Code as User_Code, U.Company_Code as Company_Code, C.Client_No, C.Client_Name, C.Client_State, U.User_Name as User_Name, C.Client_Trade, C.Client_District, C.Client_Street, C.Client_ConsignDate from (t_Intent AS I INNER JOIN t_Client AS C ON I.Client_Code = C.Client_Code) INNER JOIN t_User AS U ON I.User_Code = U.User_Code where I.DelFlag = 0 and I.TrashFlag = 0 |
| 64688 | 0 | select U.*, C.Company_Name as Company_Name, P.Position_Name as Position_Name, convert(Image, null) as Photo_Data from (t_User as U inner join t_Company as C on U.Company_Code = C.Company_Code) inner join t_Position as P on U.Position_Code = P.Position_Code where U.TrashFlag = 0 and U.DelFlag = 0 |
| 64689 | 0 | and U.User_Code = :User_Code |
| 64690 | 0 | insert into t_User (User_Code, Company_Code, User_No, User_Name, User_Sfz, User_HJ, User_Sales, User_Birthday, User_JDate, User_Tel, User_Address, User_Email, User_SeeRealty, User_SeeClient, User_Ranager, User_Remark, User_WorkResume, User_Study, User_Sex, User_Status, Position_Code, User_Pwd, User_CRC, TrashFlag, DelFlag, InDate, ModDate) values (:User_Code, :Company_Code, :User_No, :User_Name, :User_Sfz, :User_HJ, :User_Sales, :User_Birthday, :User_JDate, :User_Tel, :User_Address, :User_Email, :User_SeeRealty, :User_SeeClient, :User_Ranager, :User_Remark, :User_WorkResume, :User_Study, :User_Sex, :User_Status, :Position_Code, :User_Pwd, :User_CRC, 0, 0, getdate(), getdate() ); |
| 64691 | 0 | insert into t_Photo (Photo_Code, Photo_Type, Photo_Data, ModDate) values (:User_Code, 0, :Photo_Data, getdate() ) |
| 64692 | 0 | update t_User set User_Code = :User_Code, Company_Code = :Company_Code, User_No = :User_No, User_Name = :User_Name, User_Sfz = :User_Sfz, User_HJ = :User_HJ, User_Sales = :User_Sales, User_Birthday = :User_Birthday, User_JDate = :User_JDate, User_Tel = :User_Tel, User_Address = :User_Address, User_Email = :User_Email, User_SeeRealty = :User_SeeRealty, User_SeeClient = :User_SeeClient, User_Ranager = :User_Ranager, User_Remark = :User_Remark, User_WorkResume = :User_WorkResume, User_Study = :User_Study, User_Sex = :User_Sex, User_Status = :User_Status, Position_Code = :Position_Code, User_Pwd = :User_Pwd, User_CRC = :User_CRC, ModDate = getdate() where User_Code = :User_Code; |
| 64693 | 0 | update t_Photo set Photo_Data = :Photo_Data, ModDate = getdate() where Photo_Code = :User_Code |
| 64694 | 0 | update t_Advert set DelFlag = 1, moddate = getdate() where Advert_Code = :Advert_Code |
| 64695 | 0 | select A.*, R.Realty_No, R.Realty_Trade, R.Realty_Chamber, Realty_Building, R.Realty_Floor, R.Realty_Room, R.Realty_Hall, R.Realty_Loo, R.Realty_Balcony, R.Realty_Aspect, R.Realty_BuildAcreage, Realty_SellUnit, Realty_RentUnit, R.Realty_Fitment, R.Realty_Usage, R.Realty_Year, R.Realty_SellPrice, R.Realty_RentPrice, R.Realty_Remark, AD.Area_Name as DistrictName, AA.Area_Name as AreaName, W.WorkBook_Name, W.WorkBook_Address1, U.User_Name, C.Company_Name from (((((t_Advert A inner join t_Realty R on A.Realty_Code = R.Realty_Code) inner join t_WorkBook W on R.WorkBook_Code = W.WorkBook_Code) inner join t_Area AD on W.District_Code = AD.Area_Code) left join t_Area AA on W.Area_Code = AA.Area_Code) inner join t_User U on R.User_Code = U.User_Code) inner join t_Company C on U.Company_Code = C.Company_Code where A.DelFlag = 0 |
| 64696 | 0 | select * from t_Advert where DelFlag = 0 |
| 64697 | 0 | and Advert_Code = :Advert_Code |
| 64698 | 0 | insert into t_Advert (Advert_Code, Realty_Code, Advert_User, Advert_Type, Advert_Issue, Advert_Content, Advert_Price, Advert_Publish, InDate, Delflag, ModDate, NewDate) values (:Advert_Code, :Realty_Code, :Advert_User, :Advert_Type, :Advert_Issue, :Advert_Content, :Advert_Price, :Advert_Publish, :InDate, 0, getdate(), getdate() ) |
| 64699 | 0 | update t_Advert set Advert_Type = :Advert_Type, Advert_Issue = :Advert_Issue, Advert_Content = :Advert_Content, Advert_Price = :Advert_Price, Advert_Publish = :Advert_Publish, InDate = :InDate, ModDate = getdate() where Advert_Code = :Advert_Code |
| 64700 | 0 | update %s set trashflag =1, DelFlag = 1, ModDate =getdate() where Follow_code = :Follow_Code; update t_Awoke set trashflag = 1, DelFlag = 1, ModDate = getdate() where Awoke_PCode = :Follow_Code; |
| 64701 | 0 | select RF.*, U.Company_Code, R.Realty_Code, U.User_Name, U1.Company_Code, R.User_Code from ((t_RealtyFollow AS RF INNER JOIN t_Realty AS R ON RF.Follow_PCode = R.Realty_Code) INNER JOIN t_User AS U ON RF.User_Code = U.User_Code) INNER JOIN t_User as U1 ON R.User_Code = U1.User_Code WHERE (((RF.DelFlag)=0) AND ((RF.TrashFlag)=0)) and R.Delflag = 0 and R.TrashFlag = 0 |
| 64702 | 0 | select CF.*, U.Company_Code, C.Client_Code, U.User_Name AS User_Name, U1.Company_Code from ((t_ClientFollow AS CF INNER JOIN t_Client AS C ON CF.Follow_PCode = C.Client_Code) INNER JOIN t_User AS U ON CF.User_Code = U.User_Code) INNER JOIN t_User AS U1 ON C.User_Code = U1.User_Code WHERE ((CF.DelFlag)=0) AND C.Delflag = 0 and C.TrashFlag = 0 |
| 64703 | 0 | select CTF.*, U.Company_Code, CT.Contract_Code, U.User_Name as User_Name from (t_ContractFollow as CTF inner join t_Contract as CT ON CTF.Follow_PCode = CT.Contract_Code) inner join t_User as U ON CTF.User_Code = U.User_Code where CTF.DelFlag = 0 and CTF.TrashFlag = 0 and CT.DelFlag = 0 |
| 64704 | 0 | insert into t_Area (Area_code, Area_Name, Area_No, Area_PCode, Area_Type, delflag, ModDate, NewDate) values (:Area_code, :Area_Name, :Area_No, :Area_PCode, :Area_Type, 0, getdate(), getdate() ) |
| 64705 | 0 | update t_Area set Area_Name = :Area_Name, Area_No = :Area_No, Area_PCode = :Area_PCode, ModDate = getdate() where Area_Code = :Area_Code |
| 64706 | 0 | select W.*, C.Area_Name as City_Name, C.Area_Code as City_Code, D.Area_Name as District_Name, A.Area_Name as Area_Name from ((t_WorkBook W inner join t_Area D ON W.District_Code = D.Area_Code) inner join t_Area C ON D.Area_PCode = C.Area_Code) left join t_Area A ON W.Area_Code = A.Area_Code where W.TrashFlag = 0 and W.DelFlag = 0 |
| 64707 | 0 | update t_WorkBook set TrashFlag = 1, ModDate = getdate() where WorkBook_code = :WorkBook_code; |
| 64708 | 0 | select W.*, C.Area_Name as City_Name, C.Area_Code as City_Code, D.Area_Name as District_Name, A.Area_Name as Area_Name, (select count('') FROM t_Building as B WHERE B.WorkBook_Code = W.WorkBook_Code and B.DelFlag = 0) as BuildingCount, (select count('') FROM t_DatumRealty as DR WHERE DR.WorkBook_Code = W.WorkBook_Code and DR.DelFlag = 0) as DatumReatyCount, (select count('') FROM t_Image as I WHERE I.Image_PCode = W.WorkBook_Code and I.DelFlag = 0) as ImageCount, (select count('') FROM t_Realty as R WHERE R.WorkBook_Code = W.WorkBook_Code and R.DelFlag = 0) as RealtyCount from ((t_WorkBook W inner join t_Area D ON W.District_Code = D.Area_Code) inner join t_Area C ON D.Area_PCode = C.Area_Code) left join t_Area A ON W.Area_Code = A.Area_Code where W.TrashFlag = 0 and W.DelFlag = 0 |
| 64709 | 0 | and W.WorkBook_code = :WorkBook_code |
| 64710 | 0 | insert into t_WorkBook (WorkBook_Code, District_Code, Area_Code, WorkBook_Name, WorkBook_PY, WorkBook_Usage, WorkBook_Class, WorkBook_Year, WorkBook_Address1, WorkBook_Address2, WorkBook_Sight, WorkBook_Outfit, WorkBook_Sell, WorkBook_Rent, WorkBook_ManagerN, WorkBook_Square, WorkBook_Room, WorkBook_Frame, WorkBook_Kind, WorkBook_EnName, WorkBook_EnAddress, WorkBook_Manager, WorkBook_Tel, WorkBook_Company, WorkBook_CompanyTel, Map_Code, WorkBook_MapX, WorkBook_MapY, WorkBook_Memo, WorkBook_Descrip, WorkBook_Bus, WorkBook_Environment, WorkBook_History, DelFlag, TrashFlag, ModDate) values (:WorkBook_Code, :District_Code, :Area_Code, :WorkBook_Name, :WorkBook_PY, :WorkBook_Usage, :WorkBook_Class, :WorkBook_Year, :WorkBook_Address1, :WorkBook_Address2, :WorkBook_Sight, :WorkBook_Outfit, :WorkBook_Sell, :WorkBook_Rent, :WorkBook_ManagerN, :WorkBook_Square, :WorkBook_Room, :WorkBook_Frame, :WorkBook_Kind, :WorkBook_EnName, :WorkBook_EnAddress, :WorkBook_Manager, :WorkBook_Tel, :WorkBook_Company, :WorkBook_CompanyTel, :Map_Code, :WorkBook_MapX, :WorkBook_MapY, :WorkBook_Memo, :WorkBook_Descrip, :WorkBook_Bus, :WorkBook_Environment, :WorkBook_History, 0, 0, getdate() ) |
| 64711 | 0 | update t_WorkBook set Area_Code = :Area_Code, WorkBook_Name = :WorkBook_Name, WorkBook_PY = :WorkBook_PY, WorkBook_Usage = :WorkBook_Usage, WorkBook_Class = :WorkBook_Class, WorkBook_Year = :WorkBook_Year, WorkBook_Address1 = :WorkBook_Address1, WorkBook_Address2 = :WorkBook_Address2, WorkBook_Sight = :WorkBook_Sight, WorkBook_Outfit = :WorkBook_Outfit, WorkBook_Sell = :WorkBook_Sell, WorkBook_Rent = :WorkBook_Rent, WorkBook_ManagerN = :WorkBook_ManagerN, WorkBook_Square = :WorkBook_Square, WorkBook_Room = :WorkBook_Room, WorkBook_Frame = :WorkBook_Frame, WorkBook_Kind = :WorkBook_Kind, WorkBook_EnName = :WorkBook_EnName, WorkBook_EnAddress = :WorkBook_EnAddress, WorkBook_Manager = :WorkBook_Manager, WorkBook_Tel = :WorkBook_Tel, WorkBook_Company = :WorkBook_Company, WorkBook_CompanyTel = :WorkBook_CompanyTel, Map_Code = :Map_Code, WorkBook_MapX = :WorkBook_MapX, WorkBook_MapY = :WorkBook_MapY, WorkBook_Memo = :WorkBook_Memo, WorkBook_Descrip = :WorkBook_Descrip, WorkBook_Bus = :WorkBook_Bus, WorkBook_Environment = :WorkBook_Environment, WorkBook_History = :WorkBook_History, ModDate = getdate() where WorkBook_Code = :WorkBook_Code |
| 64712 | 0 | update t_Company set TrashFlag = 1, ModDate = getdate() where Company_Code = :Company_Code |
| 64713 | 0 | select *, convert(Image, null) as Photo_Data from t_Company where TrashFlag = 0 and DelFlag = 0 |
| 64714 | 0 | and Company_Code = :Company_Code |
| 64715 | 0 | insert into t_Company (Company_Code, Company_PCode, Company_No, Company_Name, Company_Tel, Company_Email, Company_Address, Company_RealtyPreFix, Company_ClientPreFix, Company_Man, Company_ManPaper, Company_LimitedRealty, Company_LimitedClient, Company_LimitedPublic, Company_LimitedSecrecy, Company_LimitedRFollow, Company_LimitedCFollow, Company_AreaLimitedRealty, Company_AreaLimitedClient, TrashFlag, DelFlag, ModDate, InDate) values ( :Company_Code, :Company_PCode, :Company_No, :Company_Name, :Company_Tel, :Company_Email, :Company_Address, :Company_RealtyPreFix, :Company_ClientPreFix, :Company_Man, :Company_ManPaper, :Company_LimitedRealty, :Company_LimitedClient, :Company_LimitedPublic, :Company_LimitedSecrecy, :Company_LimitedRFollow, :Company_LimitedCFollow, :Company_AreaLimitedRealty, :Company_AreaLimitedClient, 0, 0, getdate(), getdate()) |
| 64716 | 0 | insert into t_Photo (Photo_Code, Photo_Type, Photo_Data, ModDate) values (:Company_Code, 1, :Photo_Data, getdate() ) |
| 64717 | 0 | update t_Company set Company_No = :Company_No, Company_Name = :Company_Name, Company_PCode = :Company_PCode, Company_Tel = :Company_Tel, Company_Email = :Company_Email, Company_Address = :Company_Address, Company_RealtyPreFix = :Company_RealtyPreFix, Company_ClientPreFix = :Company_ClientPreFix, Company_Man = :Company_Man, Company_ManPaper = :Company_ManPaper, Company_LimitedRealty = :Company_LimitedRealty, Company_LimitedClient = :Company_LimitedClient, Company_LimitedPublic = :Company_LimitedPublic, Company_LimitedSecrecy = :Company_LimitedSecrecy, Company_LimitedRFollow = :Company_LimitedRFollow, Company_LimitedCFollow = :Company_LimitedCFollow, Company_AreaLimitedRealty = :Company_AreaLimitedRealty, Company_AreaLimitedClient = :Company_AreaLimitedClient, ModDate = getdate() where Company_Code = :Company_Code |
| 64718 | 0 | update t_Photo set Photo_Data = :Photo_Data, ModDate = getdate() where Photo_Code = :Company_Code |
| 64719 | 0 | update t_User set TrashFlag = 1, ModDate = getdate() where User_Code = :User_Code |
| 64720 | 0 | Invalid use of NOT |
| 64721 | 0 | update t_news set TrashFlag = 1, ModDate = getdate() where news_code = :news_code |
| 64722 | 0 | select N.*, U.User_Name, C.Company_Code, C.Company_Name from (t_News as N inner join t_User as U on N.User_Code = U.User_Code) inner join t_Company as C on U.Company_Code = C.Company_Code where N.Delflag = 0 and N.TrashFlag = 0 |
| 64723 | 0 | select t_News.* from t_News where Delflag = 0 and TrashFlag = 0 |
| 64724 | 0 | and News_Code = :News_Code |
| 64725 | 0 | insert into t_news (News_Code, News_Title, News_Type, News_Source, News_Text, News_FText, News_Color, User_Code, TrashFlag, Delflag, InDate, ModDate) values (:News_code, :News_Title, :News_Type, :News_Source, :News_Text, :News_FText, :News_Color, :User_Code, 0, 0, getdate(), getdate()) |
| 64726 | 0 | update t_News set News_Title = :News_Title, News_Type = :News_Type, News_Source = :News_Source, News_Text = :News_Text, News_FText = :News_FText, News_Color = :News_Color, User_Code = :User_Code, ModDate = getdate() where News_Code = :News_Code |
| 64727 | 0 | Update t_BlackList Set TrashFlag =1, modDate = Getdate() where BlackList_code = :BlackList_Code |
| 64728 | 0 | select B.*, U.User_Name, C.Company_Code, C.Company_Name from (t_BlackList as B inner join t_User as U on B.User_Code = U.User_Code) inner join t_Company as C on U.Company_Code = C.Company_Code where B.DelFlag = 0 and B.TrashFlag = 0 |
| 64729 | 0 | select * from t_BlackList where DelFlag = 0 and TrashFlag = 0 |
| 64730 | 0 | and BlackList_Code = :BlackList_Code |
| 64731 | 0 | insert into t_BlackList (BlackList_Code, BlackList_Name, BlackList_Type, BlackList_Phone, BlackList_Content, User_Code, TrashFlag, DelFlag, InDate, ModDate) values (:BlackList_Code, :BlackList_Name, :BlackList_Type, :BlackList_Phone, :BlackList_Content, :User_Code, 0, 0, getdate(), getdate()) |
| 64732 | 0 | update t_BlackList set BlackList_Name = :BlackList_Name, BlackList_Type = :BlackList_Type, BlackList_Phone = :BlackList_Phone, BlackList_Content = :BlackList_Content, User_Code = :User_Code, ModDate = getdate() where BlackList_Code = :BlackList_Code |
| 64733 | 0 | update t_Area set DelFlag = 1, ModDate = getdate() where Area_Code = :Area_Code |
| 64734 | 0 | select * from t_Area where DelFlag = 0 |
| 64735 | 0 | and Area_Code = :Area_Code |
| 64736 | 0 | Illegal character in numeric contant "%s" |
| 64737 | 0 | Missing %s |
| 64738 | 0 | Unknown function : %s |
| 64739 | 0 | Error in expression : %s |
| 64740 | 0 | Recursive calls not allowed |
| 64741 | 0 | Too many arguments |
| 64742 | 0 | Wrong arguments for %s |
| 64743 | 0 | Unknown type |
| 64744 | 0 | True |
| 64745 | 0 | False |
| 64746 | 0 | Evaluator not prepared |
| 64747 | 0 | Missing argument for %s |
| 64748 | 0 | Conversion error |
| 64749 | 0 | Division by Zero |
| 64750 | 0 | Invalid format or value specified |
| 64751 | 0 | Invalid argument to SQRT function |
| 64752 | 0 | Circular linking not allowed |
| 64753 | 0 | Converts a string to upper case letters |
| 64754 | 0 | Converts a string to lower case letters |
| 64755 | 0 | Makes the first character upper case and the rest lower case |
| 64756 | 0 | Formats numeric <N> using the mask in <F> |
| 64757 | 0 | Cannot %s %s expressions |
| 64758 | 0 | add |
| 64759 | 0 | subtract |
| 64760 | 0 | multiply |
| 64761 | 0 | divide |
| 64762 | 0 | boolean |
| 64763 | 0 | string |
| 64764 | 0 | numeric |
| 64765 | 0 | Cannot divide by 0 |
| 64766 | 0 | Operator %s is not compatible with %s expressions |
| 64767 | 0 | Field %s is of unknown type |
| 64768 | 0 | Returns <X> or <Y> depending on the boolean expression <Exp> |
| 64769 | 0 | Convert a numeric <X> to a string |
| 64770 | 0 | Return current time as a string |
| 64771 | 0 | Return current date as a string |
| 64772 | 0 | Sums the numeric <X> |
| 64773 | 0 | Returns a substring of string X |
| 64774 | 0 | Integer division of <X> by <Y> |
| 64775 | 0 | Increments for each iteration |
| 64776 | 0 | Returns the highest <X> |
| 64777 | 0 | Returns the lowest <X> |
| 64778 | 0 | Returns the average of numeric <X> |
| 64779 | 0 | boolean value |
| 64780 | 0 | Returns the integer part of <X> |
| 64781 | 0 | Returns the fractional part of <X> |
| 64782 | 0 | Returns square root of <X> |
| 64783 | 0 | Returns the data type of <Exp> |
| 64784 | 0 | GroupFooterBand |
| 64785 | 0 | SubDetailBand |
| 64786 | 0 | ColumnHeaderBand |
| 64787 | 0 | OverlayBand |
| 64788 | 0 | ChildBand |
| 64789 | 0 | Save report |
| 64790 | 0 | Load report |
| 64791 | 0 | Page |
| 64792 | 0 | of |
| 64793 | 0 | Illegal call to NewPage |
| 64794 | 0 | QRPrinter not ready |
| 64795 | 0 | QuSoft AS |
| 64796 | 0 | none |
| 64797 | 0 | File does not exist |
| 64798 | 0 | Completed |
| 64799 | 0 | QuickReport file |
| 64800 | 0 | Page Header |
| 64801 | 0 | Detail |
| 64802 | 0 | Page Footer |
| 64803 | 0 | Summary |
| 64804 | 0 | Group Header |
| 64805 | 0 | Group Footer |
| 64806 | 0 | Sub Detail |
| 64807 | 0 | Column Header |
| 64808 | 0 | Overlay |
| 64809 | 0 | Child |
| 64810 | 0 | TitleBand |
| 64811 | 0 | PageHeaderBand |
| 64812 | 0 | DetailBand |
| 64813 | 0 | PageFooterBand |
| 64814 | 0 | SummaryBand |
| 64815 | 0 | GroupHeaderBand |
| 64816 | 0 | B5 182 x 257 mm |
| 64817 | 0 | Folio 8 1/2 x 13 in |
| 64818 | 0 | Quarto 215 x 275 mm |
| 64819 | 0 | 10x14 in |
| 64820 | 0 | 11x17 in |
| 64821 | 0 | Note 8 1/2 x 11 in |
| 64822 | 0 | Envelope #9 3 7/8 x 8 7/8 |
| 64823 | 0 | Envelope #10 4 1/8 x 9 1/2 |
| 64824 | 0 | Envelope #11 4 1/2 x 10 3/8 |
| 64825 | 0 | Envelope #12 4 \276 x 11 |
| 64826 | 0 | Envelope #14 4 \276 x 11 |
| 64827 | 0 | C size sheet |
| 64828 | 0 | D size sheet |
| 64829 | 0 | E size sheet |
| 64830 | 0 | Custom Size |
| 64831 | 0 | Title |
| 64832 | 0 | Cannot access field '%s' in a filter |
| 64833 | 0 | Untitled Application |
| 64834 | 0 | The transaction isolation level must be dirty read for local databases |
| 64835 | 0 | Default size |
| 64836 | 0 | Letter 8 1/2 x 11 in |
| 64837 | 0 | Letter Small 8 1/2 x 11 in |
| 64838 | 0 | Tabloid 11 x 17 in |
| 64839 | 0 | Ledger 17 x 11 in |
| 64840 | 0 | Legal 8 1/2 x 14 in |
| 64841 | 0 | Statement 5 1/2 x 8 1/2 in |
| 64842 | 0 | Executive7 1/2 x 10 in |
| 64843 | 0 | A3 297 x 420 mm |
| 64844 | 0 | A4 210 x 297 mm |
| 64845 | 0 | A4 Small 210 x 297 mm |
| 64846 | 0 | A5 148 x 210 mm |
| 64847 | 0 | B4 250 x 354 mm |
| 64848 | 0 | Cannot perform this operation on a closed database |
| 64849 | 0 | Database handle owned by a different session |
| 64850 | 0 | Cannot perform this operation on an active session |
| 64851 | 0 | Error creating cursor handle |
| 64852 | 0 | ReferenceTableName not specified for field '%s' |
| 64853 | 0 | No SQL statement available |
| 64854 | 0 | No value for parameter '%s' |
| 64855 | 0 | Cannot connect to database '%s' |
| 64856 | 0 | An error occurred while attempting to initialize the Borland Database Engine (error $%.4x) |
| 64857 | 0 | 0009 |
| 64858 | 0 | BDE error $%.4x |
| 64859 | 0 | Index does not exist. Index: %s |
| 64860 | 0 | Missing TableName property |
| 64861 | 0 | Missing DataSetField property |
| 64862 | 0 | Not in cached update mode |
| 64863 | 0 | Invalid alias name %s |
| 64864 | 0 | This header already contains button with name %s
Please type another one to continue. |
| 64865 | 0 | FormatEtcList: Invalid item index. |
| 64866 | 0 | update t_Att set DelFlag = 1, TrashFlag = 1, ModDate = getdate() where Att_code = :Att_Code |
| 64867 | 0 | select C.Company_Code, C.Company_Name, U.User_Name, A.* from (t_Att AS A INNER JOIN t_User AS U ON A.User_Code = U.User_Code) INNER JOIN t_Company AS C ON U.Company_Code = C.Company_Code where A.delflag = 0 and A.TrashFlag = 0 |
| 64868 | 0 | and Att_Code = :Att_Code |
| 64869 | 0 | insert into t_Att (Att_Code,User_Code,Att_AddDate,Att_AddWeek,Att_Type,Att_Content, Att_StartDate,Att_EndDate,Att_State, Att_RTime, InDate, ModDate )values (:Att_Code, :User_Code, :Att_AddDate, :Att_AddWeek, :Att_Type, :Att_Content, :Att_StartDate, :Att_EndDate, :Att_State, :Att_RTime, getdate(), getdate()) |
| 64870 | 0 | update t_Att set User_Code = :User_Code, Att_AddDate = :Att_AddDate, Att_AddWeek = :Att_AddWeek, Att_Type = :Att_Type, Att_Content = :Att_Content, Att_StartDate = :Att_StartDate, Att_EndDate = :Att_EndDate, Att_RTime = :Att_RTime, Att_State = :Att_State, ModDate = getdate() where Att_Code = :Att_Code |
| 64871 | 0 | Cannot enable AutoSessionName property with more than one session on a form or data-module |
| 64872 | 0 | Cannot add a session to the form or data-module while session '%s' has AutoSessionName enabled |
| 64873 | 0 | Cannot modify SessionName while AutoSessionName is enabled |
| 64874 | 0 | Duplicate database name '%s' |
| 64875 | 0 | Duplicate session name '%s' |
| 64876 | 0 | Invalid session name %s |
| 64877 | 0 | Database name missing |
| 64878 | 0 | Session name missing |
| 64879 | 0 | Cannot perform this operation on an open database |
| 64880 | 0 | Error connecting with SSL. |
| 64881 | 0 | SetCipher failed. |
| 64882 | 0 | Error creating SSL context. |
| 64883 | 0 | Could not load root certificate. |
| 64884 | 0 | Could not load certificate. |
| 64885 | 0 | Could not load key, check password. |
| 64886 | 0 | Error geting SSL method. |
| 64887 | 0 | Error binding data to SSL socket. |
| 64888 | 0 | Mode has not been set. |
| 64889 | 0 | Could not load SSL library. |
| 64890 | 0 | SSL status: "%s" |
| 64891 | 0 | Uneven size in DecodeToStream. |
| 64892 | 0 | Uneven size in Encode. |
| 64893 | 0 | Protocol field is empty |
| 64894 | 0 | Host field is empty |
| 64895 | 0 | This bar already contains header with name %s
Please type another one to continue. |
| 64896 | 0 | Request rejected or failed. |
| 64897 | 0 | Request rejected because SOCKS server cannot connect. |
| 64898 | 0 | Request rejected because the client program and identd report different user-ids. |
| 64899 | 0 | Unknown socks error. |
| 64900 | 0 | Socks server did not respond. |
| 64901 | 0 | Invalid socks authentication method. |
| 64902 | 0 | Authentication error to socks server. |
| 64903 | 0 | General SOCKS server failure. |
| 64904 | 0 | Connection not allowed by ruleset. |
| 64905 | 0 | Network unreachable. |
| 64906 | 0 | Host unreachable. |
| 64907 | 0 | Connection refused. |
| 64908 | 0 | TTL expired. |
| 64909 | 0 | Command not supported. |
| 64910 | 0 | Address type not supported. |
| 64911 | 0 | Error accepting connection with SSL. |
| 64912 | 0 | Net dropped connection or reset. |
| 64913 | 0 | Software caused connection abort. |
| 64914 | 0 | Connection reset by peer. |
| 64915 | 0 | No buffer space available. |
| 64916 | 0 | Socket is already connected. |
| 64917 | 0 | Socket is not connected. |
| 64918 | 0 | Cannot send or receive after socket is closed. |
| 64919 | 0 | Too many references, cannot splice. |
| 64920 | 0 | Connection timed out. |
| 64921 | 0 | Connection refused. |
| 64922 | 0 | Too many levels of symbolic links. |
| 64923 | 0 | File name too long. |
| 64924 | 0 | Host is down. |
| 64925 | 0 | No route to host. |
| 64926 | 0 | Directory not empty |
| 64927 | 0 | Host not found. |
| 64928 | 0 | Operation now in progress. |
| 64929 | 0 | Operation already in progress. |
| 64930 | 0 | Socket operation on non-socket. |
| 64931 | 0 | Destination address required. |
| 64932 | 0 | Message too long. |
| 64933 | 0 | Protocol wrong type for socket. |
| 64934 | 0 | Bad protocol option. |
| 64935 | 0 | Protocol not supported. |
| 64936 | 0 | Socket type not supported. |
| 64937 | 0 | Operation not supported on socket. |
| 64938 | 0 | Protocol family not supported. |
| 64939 | 0 | Address family not supported by protocol family. |
| 64940 | 0 | Address already in use. |
| 64941 | 0 | Cannot assign requested address. |
| 64942 | 0 | Network is down. |
| 64943 | 0 | Network is unreachable. |
| 64944 | 0 | Connected. |
| 64945 | 0 | Disconnecting. |
| 64946 | 0 | Disconnected. |
| 64947 | 0 | %s |
| 64948 | 0 | Connect timed out. |
| 64949 | 0 | Chunk Started |
| 64950 | 0 | This authentication method is already registered with class name %s. |
| 64951 | 0 | %s is not a valid service. |
| 64952 | 0 | Socket Error # %d
%s |
| 64953 | 0 | Interrupted system call. |
| 64954 | 0 | Bad file number. |
| 64955 | 0 | Access denied. |
| 64956 | 0 | Bad address. |
| 64957 | 0 | Invalid argument. |
| 64958 | 0 | Too many open files. |
| 64959 | 0 | Operation would block. |
| 64960 | 0 | Not enough data in buffer. |
| 64961 | 0 | Winsock Initialization Error. |
| 64962 | 0 | Set Size Exceeded. |
| 64963 | 0 | File "%s" not found |
| 64964 | 0 | Only one TIdAntiFreeze can exist per application. |
| 64965 | 0 | IOHandler value is not valid |
| 64966 | 0 | Not Connected |
| 64967 | 0 | No data to read. |
| 64968 | 0 | Can not bind in port range (%d - %d) |
| 64969 | 0 | Invalid Port Range (%d - %d) |
| 64970 | 0 | Read Timeout |
| 64971 | 0 | Max line length exceeded. |
| 64972 | 0 | Error on call Winsock2 library function %s |
| 64973 | 0 | Error on loading Winsock2 library (%s) |
| 64974 | 0 | Resolving hostname %s. |
| 64975 | 0 | Connecting to %s. |
| 64976 | 0 | Refresh is only supported if the FileName or XML properties are set |
| 64977 | 0 | FileName cannot be blank |
| 64978 | 0 | Line |
| 64979 | 0 | OLE control activation failed |
| 64980 | 0 | Could not obtain OLE control window handle |
| 64981 | 0 | Operation not allowed on an empty OLE container |
| 64982 | 0 | Invalid object verb |
| 64983 | 0 | Invalid stream format |
| 64984 | 0 | License information for %s is invalid |
| 64985 | 0 | License information for %s not found. You cannot use this control in design mode |
| 64986 | 0 | Unable to retrieve a pointer to a running object registered with OLE for %s/%s |
| 64987 | 0 | Already connected. |
| 64988 | 0 | Cannot allocate socket. |
| 64989 | 0 | Connection Closed Gracefully. |
| 64990 | 0 | Could not bind socket. Address and port are already in use. |
| 64991 | 0 | Failed attempting to retrieve time zone information. |
| 64992 | 0 | Cannot change Position of a TTBDock if it already contains controls |
| 64993 | 0 | "%s" DOMImplementation already registered |
| 64994 | 0 | No matching DOM Vendor: "%s" |
| 64995 | 0 | Selected DOM Vendor does not support this property or method |
| 64996 | 0 | Property or Method "%s" is not supported by DOM Vendor "%s" |
| 64997 | 0 | Node cannot be null |
| 64998 | 0 | Microsoft MSXML is not installed |
| 64999 | 0 | No active document |
| 65000 | 0 | Node "%s" not found |
| 65001 | 0 | IDOMNode required |
| 65002 | 0 | Attributes are not supported on this node type |
| 65003 | 0 | Invalid node type |
| 65004 | 0 | Mismatched paramaters to RegisterChildNodes |
| 65005 | 0 | Element does not contain a single text node |
| 65006 | 0 | DOM Implementation does not support IDOMParseOptions |
| 65007 | 0 | Node is readonly |
| 65008 | 0 | Error in expression: |
| 65009 | 0 | Unexpected expression before Null: |
| 65010 | 0 | Unexpected expression after operator: |
| 65011 | 0 | Incorrect expression: |
| 65012 | 0 | Unexpected AND or OR: |
| 65013 | 0 | No data found |
| 65014 | 0 | Invalid stream operation |
| 65015 | 0 | Error |
| 65016 | 0 | Cannot change the size of a JPEG image |
| 65017 | 0 | JPEG error #%d |
| 65018 | 0 | JPEG Image File |
| 65019 | 0 | Toolbar item index out of range |
| 65020 | 0 | Toolbar item already inserted |
| 65021 | 0 | An item viewer associated the specified item could not be found |
| 65022 | 0 | More Buttons| |
| 65023 | 0 | A TTBDock control cannot be placed inside a tool window or another TTBDock |
| 65024 | 0 | 字符串 "%s" 没有找到. |
| 65025 | 0 | (空) |
| 65026 | 0 | (非空) |
| 65027 | 0 | (全部) |
| 65028 | 0 | (清除过滤器) |
| 65029 | 0 | (递增排序) |
| 65030 | 0 | (递减排序) |
| 65031 | 0 | Not |
| 65032 | 0 | AND |
| 65033 | 0 | OR |
| 65035 | 0 | In |
| 65036 | 0 | Null |
| 65037 | 0 | Quote is absent: |
| 65038 | 0 | '(' expected: |
| 65039 | 0 | ')' expected: |
| 65040 | 0 | [0x0011]: Duplicate Transaction ID |
| 65041 | 0 | [0x0012]: Application is not licensed to use this feature |
| 65042 | 0 | [0x0013]: Local Transaction already active |
| 65043 | 0 | [0x0014]: Multiple Transactions not Enabled |
| 65044 | 0 | [0x0015]: Connection failed |
| 65045 | 0 | [0x0016]: Driver initialization failed |
| 65046 | 0 | [0x0017]: Optimistic Locking failed |
| 65047 | 0 | [0x0018]: Invalid REF |
| 65048 | 0 | [0x0019]: No table found |
| 65049 | 0 | 是否清除选定的单元格? |
| 65050 | 0 | 无效的文本格式 |
| 65051 | 0 | 无效的 VCLDBIF 格式 |
| 65052 | 0 | 在插入值的时候出现了错误: |
| 65053 | 0 | 是否忽略该错误? |
| 65054 | 0 | 列表信息 |
| 65055 | 0 | 字段名称 '%s' 没有找到 |
| 65056 | 0 | [0x0001]: Warning |
| 65057 | 0 | [0x0002]: Insufficient Memory for Operation |
| 65058 | 0 | [0x0003]: Invalid Field Type |
| 65059 | 0 | [0x0004]: Invalid Handle |
| 65060 | 0 | [0x0005]: Operation Not Supported |
| 65061 | 0 | [0x0006]: Invalid Time |
| 65062 | 0 | [0x0007]: Invalid Data Translation |
| 65063 | 0 | [0x0008]: Parameter/Column out of Range |
| 65064 | 0 | [0x0009]: Invalid Parameter |
| 65065 | 0 | [0x000A]: Result set at EOF |
| 65066 | 0 | dbExpress Error [0x000B]: Parameter Not Set |
| 65067 | 0 | [0x000C] Invalid Username/Password |
| 65068 | 0 | [0x000D]: Invalid Precision |
| 65069 | 0 | [0x000E]: Invalid Length |
| 65070 | 0 | [0x000F]: Invalid Transaction Isolation Level |
| 65071 | 0 | [0x0010]: Invalid Transaction ID |
| 65072 | 0 | Name |
| 65073 | 0 | Value |
| 65074 | 0 | First record |
| 65075 | 0 | Prior record |
| 65076 | 0 | Next record |
| 65077 | 0 | Last record |
| 65078 | 0 | Insert record |
| 65079 | 0 | Delete record |
| 65080 | 0 | Edit record |
| 65081 | 0 | Post edit |
| 65082 | 0 | Cancel edit |
| 65083 | 0 | Refresh data |
| 65084 | 0 | Operation not allowed in a DBCtrlGrid |
| 65085 | 0 | Property already defined by lookup field |
| 65086 | 0 | Remote Login |
| 65088 | 0 | Variant does not reference an automation object |
| 65089 | 0 | Dispatch methods do not support more than 64 parameters |
| 65090 | 0 | DCOM not installed |
| 65091 | 0 | Invalid Enum Value |
| 65092 | 0 | Missing Connection or ConnectionString |
| 65093 | 0 | Filter property cannot be used for detail tables |
| 65094 | 0 | Dataset does not support bookmarks, which are required for multi-record data controls |
| 65095 | 0 | Missing %s property |
| 65096 | 0 | CommandText does not return a result set |
| 65097 | 0 | Error creating object. Please verify that the Microsoft Data Access Components 2.1 (or later) have been properly installed |
| 65098 | 0 | Events are not supported with server side TableDirect cursors |
| 65099 | 0 | Unsupported field type (%s) in field %s |
| 65100 | 0 | A connection component is required for async ExecuteOptions |
| 65101 | 0 | Cannot perform a requery after connection has changed |
| 65102 | 0 | FilterOptions are not supported |
| 65103 | 0 | Recordset is not open |
| 65104 | 0 | SQL not supported: %s |
| 65105 | 0 | Execute not supported: %s |
| 65106 | 0 | Field '%s' is not the correct type of calculated field to be used in an aggregate, use an internalcalc |
| 65107 | 0 | Operation not allowed on a unidirectional dataset |
| 65108 | 0 | Unassigned variant value |
| 65109 | 0 | Record not found |
| 65110 | 0 | BCD overflow |
| 65111 | 0 | %s is not a valid BCD value |
| 65112 | 0 | Invalid format type for BCD |
| 65113 | 0 | Could not parse SQL TimeStamp string |
| 65114 | 0 | Invalid SQL date/time values |
| 65115 | 0 | Delete record? |
| 65116 | 0 | Delete all selected records? |
| 65117 | 0 | Grid requested to display more than 256 columns |
| 65118 | 0 | OLE error %.8x |
| 65119 | 0 | Method '%s' not supported by automation object |
| 65120 | 0 | Constant out of range |
| 65121 | 0 | Incorrectly formed filter expression |
| 65122 | 0 | nothing |
| 65123 | 0 | Type mismatch in expression |
| 65124 | 0 | Operation cannot mix aggregate value with record-varying value |
| 65125 | 0 | Arithmetic in filter expressions not supported |
| 65126 | 0 | Expression is not an aggregate expression |
| 65127 | 0 | Constant is not correct type %s |
| 65128 | 0 | Aggregate expressions not allowed in filters |
| 65129 | 0 | IN predicate list may not be empty |
| 65130 | 0 | Invalid use of keyword |
| 65131 | 0 | False |
| 65132 | 0 | True |
| 65133 | 0 | Parameter '%s' not found |
| 65134 | 0 | Unable to load bind parameters |
| 65135 | 0 | Field '%s' is of an unsupported type |
| 65136 | 0 | Cannot perform this operation on an open dataset |
| 65137 | 0 | Dataset not in edit or insert mode |
| 65138 | 0 | Cannot perform this operation on a closed dataset |
| 65139 | 0 | Cannot perform this operation on an empty dataset |
| 65140 | 0 | Cannot modify a read-only dataset |
| 65141 | 0 | Nested dataset must inherit from %s |
| 65142 | 0 | Filter expression incorrectly terminated |
| 65143 | 0 | Unterminated field name |
| 65144 | 0 | Unterminated string constant |
| 65145 | 0 | Invalid filter expression character: '%s' |
| 65146 | 0 | '(' expected but %s found |
| 65147 | 0 | ')' expected but %s found |
| 65148 | 0 | ')' or ',' expected but %s found |
| 65149 | 0 | Expression expected but %s found |
| 65150 | 0 | Field '%s' cannot be used in a filter expression |
| 65151 | 0 | NULL only allowed with '=' and '<>' |
| 65152 | 0 | Type mismatch for field '%s', expecting: %s actual: %s |
| 65153 | 0 | Size mismatch for field '%s', expecting: %d actual: %d |
| 65154 | 0 | Invalid variant type or size for field '%s' |
| 65155 | 0 | Value of field '%s' is out of range |
| 65156 | 0 | Field '%s' must have a value |
| 65157 | 0 | Field '%s' has no dataset |
| 65158 | 0 | Field '%s' cannot be a calculated or lookup field |
| 65159 | 0 | Field '%s' cannot be modified |
| 65160 | 0 | Field index out of range |
| 65161 | 0 | Field '%s' is not indexed and cannot be modified |
| 65162 | 0 | Cannot access index field '%s' |
| 65163 | 0 | No index for fields '%s' |
| 65164 | 0 | Index '%s' not found |
| 65165 | 0 | Circular datalinks are not allowed |
| 65166 | 0 | Lookup information for field '%s' is incomplete |
| 65167 | 0 | DataSource cannot be changed |
| 65168 | 0 | Failed to set calendar min/max range |
| 65169 | 0 | Failed to set calendar selected range |
| 65170 | 0 | No help keyword specified. |
| 65171 | 0 | Invalid field size |
| 65172 | 0 | Invalid FieldKind |
| 65173 | 0 | Field '%s' is of an unknown type |
| 65174 | 0 | Field name missing |
| 65175 | 0 | Duplicate field name '%s' |
| 65176 | 0 | Field '%s' not found |
| 65177 | 0 | Cannot access field '%s' as type %s |
| 65178 | 0 | Invalid value for field '%s' |
| 65179 | 0 | %g is not a valid value for field '%s'. The allowed range is %g to %g |
| 65180 | 0 | %s is not a valid value for field '%s'. The allowed range is %s to %s |
| 65181 | 0 | '%s' is not a valid integer value for field '%s' |
| 65182 | 0 | '%s' is not a valid boolean value for field '%s' |
| 65183 | 0 | '%s' is not a valid floating point value for field '%s' |
| 65184 | 0 | Failed to set object at index %d |
| 65185 | 0 | MultiLine must be True when TabPosition is tpLeft or tpRight |
| 65186 | 0 | Invalid index |
| 65187 | 0 | Unable to insert an item |
| 65188 | 0 | Invalid owner |
| 65189 | 0 | RichEdit line insertion error |
| 65190 | 0 | Failed to Load Stream |
| 65191 | 0 | Failed to Save Stream |
| 65192 | 0 | %s is already associated with %s |
| 65193 | 0 | %d is an invalid PageIndex value. PageIndex must be between 0 and %d |
| 65194 | 0 | This control requires version 4.70 or greater of COMCTL32.DLL |
| 65195 | 0 | Date exceeds maximum of %s |
| 65196 | 0 | Date is less than minimum of %s |
| 65197 | 0 | You must be in ShowCheckbox mode to set to this date |
| 65198 | 0 | Failed to set calendar date or time |
| 65199 | 0 | Failed to set maximum selection range |
| 65200 | 0 | Info Background |
| 65201 | 0 | Info Text |
| 65202 | 0 | Menu Background |
| 65203 | 0 | Menu Text |
| 65204 | 0 | None |
| 65205 | 0 | Scroll Bar |
| 65206 | 0 | 3D Dark Shadow |
| 65207 | 0 | 3D Light |
| 65208 | 0 | Window Background |
| 65209 | 0 | Window Frame |
| 65210 | 0 | Window Text |
| 65211 | 0 | Failed to clear tab control |
| 65212 | 0 | Failed to delete tab at index %d |
| 65213 | 0 | Failed to retrieve tab at index %d |
| 65214 | 0 | Failed to get object at index %d |
| 65215 | 0 | Failed to set tab "%s" at index %d |
| 65216 | 0 | Active Border |
| 65217 | 0 | Active Caption |
| 65218 | 0 | Application Workspace |
| 65219 | 0 | Background |
| 65220 | 0 | Button Face |
| 65221 | 0 | Button Highlight |
| 65222 | 0 | Button Shadow |
| 65223 | 0 | Button Text |
| 65224 | 0 | Caption Text |
| 65225 | 0 | Default |
| 65226 | 0 | Gray Text |
| 65227 | 0 | Highlight Background |
| 65228 | 0 | Highlight Text |
| 65229 | 0 | Inactive Border |
| 65230 | 0 | Inactive Caption |
| 65231 | 0 | Inactive Caption Text |
| 65232 | 0 | Navy |
| 65233 | 0 | Purple |
| 65234 | 0 | Teal |
| 65235 | 0 | Gray |
| 65236 | 0 | Silver |
| 65237 | 0 | Red |
| 65238 | 0 | Lime |
| 65239 | 0 | Yellow |
| 65240 | 0 | Blue |
| 65241 | 0 | Fuchsia |
| 65242 | 0 | Aqua |
| 65243 | 0 | White |
| 65244 | 0 | Money Green |
| 65245 | 0 | Sky Blue |
| 65246 | 0 | Cream |
| 65247 | 0 | Medium Gray |
| 65248 | 0 | Error removing control from dock tree |
| 65249 | 0 | - Dock zone not found |
| 65250 | 0 | - Dock zone has no control |
| 65251 | 0 | Multiselect mode must be on for this feature |
| 65252 | 0 | Separator |
| 65253 | 0 | Error setting %s.Count |
| 65254 | 0 | Listbox (%s) style must be virtual in order to set Count |
| 65255 | 0 | No OnGetItem event handler assigned |
| 65256 | 0 | Unable to find a Table of Contents |
| 65257 | 0 | No help found for %s |
| 65258 | 0 | No context-sensitive help installed |
| 65259 | 0 | No topic-based help system installed |
| 65260 | 0 | Black |
| 65261 | 0 | Maroon |
| 65262 | 0 | Green |
| 65263 | 0 | Olive |
| 65264 | 0 | Alt+ |
| 65265 | 0 | (None) |
| 65266 | 0 | Value must be between %d and %d |
| 65267 | 0 | All |
| 65268 | 0 | Unable to insert a line |
| 65269 | 0 | Invalid clipboard format |
| 65270 | 0 | Clipboard does not support Icons |
| 65271 | 0 | Cannot open clipboard |
| 65272 | 0 | Text exceeds memo capacity |
| 65273 | 0 | Operation not supported on selected printer |
| 65274 | 0 | There is no default printer currently selected |
| 65275 | 0 | Menu '%s' is already being used by another form |
| 65276 | 0 | Picture: |
| 65277 | 0 | (%dx%d) |
| 65278 | 0 | Preview |
| 65279 | 0 | Docked control must have a name |
| 65280 | 0 | Tab |
| 65281 | 0 | Esc |
| 65282 | 0 | Enter |
| 65283 | 0 | Space |
| 65284 | 0 | PgUp |
| 65285 | 0 | PgDn |
| 65286 | 0 | End |
| 65287 | 0 | Home |
| 65288 | 0 | Left |
| 65289 | 0 | Up |
| 65290 | 0 | Right |
| 65291 | 0 | Down |
| 65292 | 0 | Ins |
| 65293 | 0 | Del |
| 65294 | 0 | Shift+ |
| 65295 | 0 | Ctrl+ |
| 65296 | 0 | Warning |
| 65297 | 0 | Error |
| 65298 | 0 | Information |
| 65299 | 0 | Confirm |
| 65300 | 0 | &Yes |
| 65301 | 0 | &No |
| 65302 | 0 | OK |
| 65303 | 0 | Cancel |
| 65304 | 0 | &Help |
| 65305 | 0 | &Abort |
| 65306 | 0 | &Retry |
| 65307 | 0 | &Ignore |
| 65308 | 0 | &All |
| 65309 | 0 | N&o to All |
| 65310 | 0 | Yes to &All |
| 65311 | 0 | BkSp |
| 65312 | 0 | &Ignore |
| 65313 | 0 | &Retry |
| 65314 | 0 | Abort |
| 65315 | 0 | &All |
| 65316 | 0 | Cannot drag a form |
| 65317 | 0 | Metafiles |
| 65318 | 0 | Enhanced Metafiles |
| 65319 | 0 | Icons |
| 65320 | 0 | Bitmaps |
| 65321 | 0 | Grid too large for operation |
| 65322 | 0 | Too many rows or columns deleted |
| 65323 | 0 | Grid index out of range |
| 65324 | 0 | Fixed column count must be less than column count |
| 65325 | 0 | Fixed row count must be less than row count |
| 65326 | 0 | Invalid input value |
| 65327 | 0 | Invalid input value. Use escape key to abandon changes |
| 65328 | 0 | Not enough timers available |
| 65329 | 0 | Printer is not currently printing |
| 65330 | 0 | Printing in progress |
| 65331 | 0 | Printer index out of range |
| 65332 | 0 | Printer selected is not valid |
| 65333 | 0 | %s on %s |
| 65334 | 0 | GroupIndex cannot be less than a previous menu item's GroupIndex |
| 65335 | 0 | Cannot create form. No MDI forms are currently active |
| 65336 | 0 | Can only modify an image if it contains a bitmap |
| 65337 | 0 | A control cannot have itself as its parent |
| 65338 | 0 | OK |
| 65339 | 0 | Cancel |
| 65340 | 0 | &Yes |
| 65341 | 0 | &No |
| 65342 | 0 | &Help |
| 65343 | 0 | &Close |
| 65344 | 0 | Invalid ImageList Index |
| 65345 | 0 | Failed to read ImageList data from stream |
| 65346 | 0 | Failed to write ImageList data to stream |
| 65347 | 0 | Error creating window device context |
| 65348 | 0 | Error creating window class |
| 65349 | 0 | Cannot focus a disabled or invisible window |
| 65350 | 0 | Control '%s' has no parent window |
| 65351 | 0 | Parent given is not a parent of '%s' |
| 65352 | 0 | Cannot hide an MDI Child Form |
| 65353 | 0 | Cannot change Visible in OnShow or OnHide |
| 65354 | 0 | Cannot make a visible window modal |
| 65355 | 0 | Scrollbar property out of range |
| 65356 | 0 | %s property out of range |
| 65357 | 0 | Menu index out of range |
| 65358 | 0 | Menu inserted twice |
| 65359 | 0 | Sub-menu is not in menu |
| 65360 | 0 | Tab style incompatible with current tab position |
| 65361 | 0 | Bitmap image is not valid |
| 65362 | 0 | Icon image is not valid |
| 65363 | 0 | Metafile is not valid |
| 65364 | 0 | Invalid pixel format |
| 65365 | 0 | Invalid image |
| 65366 | 0 | Scan line index out of range |
| 65367 | 0 | Cannot change the size of an icon |
| 65368 | 0 | Invalid operation on TOleGraphic |
| 65369 | 0 | Unknown picture file extension (.%s) |
| 65370 | 0 | Unsupported clipboard format |
| 65371 | 0 | Out of system resources |
| 65372 | 0 | Canvas does not allow drawing |
| 65373 | 0 | Invalid image size |
| 65374 | 0 | Invalid ImageList |
| 65375 | 0 | Unable to Replace Image |
| 65376 | 0 | Failed to create key %s |
| 65377 | 0 | Failed to get data for '%s' |
| 65378 | 0 | Failed to set data for '%s' |
| 65379 | 0 | Resource %s not found |
| 65380 | 0 | %s.Seek not implemented |
| 65381 | 0 | Operation not allowed on sorted list |
| 65382 | 0 | Too many rows or columns deleted |
| 65383 | 0 | %s not in a class registration group |
| 65384 | 0 | Property %s does not exist |
| 65385 | 0 | Stream write error |
| 65386 | 0 | Thread creation error: %s |
| 65387 | 0 | Thread Error: %s (%d) |
| 65388 | 0 | ? |
| 65389 | 0 | ''%s'' is not a valid date and time |
| 65390 | 0 | Tab index out of bounds |
| 65391 | 0 | Tab position incompatible with current tab style |
| 65392 | 0 | Invalid property path |
| 65393 | 0 | Invalid property type: %s |
| 65394 | 0 | Invalid property value |
| 65395 | 0 | Invalid data type for '%s' |
| 65396 | 0 | Invalid string constant |
| 65397 | 0 | Cannot insert or delete rows from grid |
| 65398 | 0 | Item not found ($0%x) |
| 65399 | 0 | Line too long |
| 65400 | 0 | List capacity out of bounds (%d) |
| 65401 | 0 | List count out of bounds (%d) |
| 65402 | 0 | List index out of bounds (%d) |
| 65403 | 0 | Out of memory while expanding memory stream |
| 65404 | 0 | %s on line %d |
| 65405 | 0 | Error reading %s%s%s: %s |
| 65406 | 0 | Stream read error |
| 65407 | 0 | Property is read-only |
| 65408 | 0 | Class %s not found |
| 65409 | 0 | A class named %s already exists |
| 65410 | 0 | List does not allow duplicates ($0%x) |
| 65411 | 0 | A component named %s already exists |
| 65412 | 0 | String list does not allow duplicates |
| 65413 | 0 | Cannot create file "%s". %s |
| 65414 | 0 | Fixed column count must be less than column count |
| 65415 | 0 | Fixed row count must be less than row count |
| 65416 | 0 | Cannot open file "%s". %s |
| 65417 | 0 | Grid too large for operation |
| 65418 | 0 | Grid index out of range |
| 65419 | 0 | Unable to write to %s |
| 65420 | 0 | Invalid stream format |
| 65421 | 0 | ''%s'' is not a valid component name |
| 65422 | 0 | Invalid property value |
| 65423 | 0 | Invalid property element: %s |
| 65424 | 0 | Wed |
| 65425 | 0 | Thu |
| 65426 | 0 | Fri |
| 65427 | 0 | Sat |
| 65428 | 0 | Sunday |
| 65429 | 0 | Monday |
| 65430 | 0 | Tuesday |
| 65431 | 0 | Wednesday |
| 65432 | 0 | Thursday |
| 65433 | 0 | Friday |
| 65434 | 0 | Saturday |
| 65435 | 0 | Ancestor for '%s' not found |
| 65436 | 0 | Cannot assign a %s to a %s |
| 65437 | 0 | Bits index out of range |
| 65438 | 0 | Can't write to a read-only resource stream |
| 65439 | 0 | CheckSynchronize called from thread $%x, which is NOT the main thread |
| 65440 | 0 | Dec |
| 65441 | 0 | January |
| 65442 | 0 | February |
| 65443 | 0 | March |
| 65444 | 0 | April |
| 65445 | 0 | May |
| 65446 | 0 | June |
| 65447 | 0 | July |
| 65448 | 0 | August |
| 65449 | 0 | September |
| 65450 | 0 | October |
| 65451 | 0 | November |
| 65452 | 0 | December |
| 65453 | 0 | Sun |
| 65454 | 0 | Mon |
| 65455 | 0 | Tue |
| 65456 | 0 | Abstract Error |
| 65457 | 0 | Access violation at address %p in module '%s'. %s of address %p |
| 65458 | 0 | System Error. Code: %d.
%s |
| 65459 | 0 | A call to an OS function failed |
| 65460 | 0 | Application is not licensed to use this feature |
| 65461 | 0 | Jan |
| 65462 | 0 | Feb |
| 65463 | 0 | Mar |
| 65464 | 0 | Apr |
| 65465 | 0 | May |
| 65466 | 0 | Jun |
| 65467 | 0 | Jul |
| 65468 | 0 | Aug |
| 65469 | 0 | Sep |
| 65470 | 0 | Oct |
| 65471 | 0 | Nov |
| 65472 | 0 | Custom variant type (%s%.4x) is out of range |
| 65473 | 0 | Custom variant type (%s%.4x) already used by %s |
| 65474 | 0 | Custom variant type (%s%.4x) is not usable |
| 65475 | 0 | Too many custom variant types have been registered |
| 65476 | 0 | Could not convert variant of type (%s) into type (%s) |
| 65477 | 0 | Overflow while converting variant of type (%s) into type (%s) |
| 65478 | 0 | Variant overflow |
| 65479 | 0 | Invalid argument |
| 65480 | 0 | Invalid variant type |
| 65481 | 0 | Operation not supported |
| 65482 | 0 | Unexpected variant error |
| 65483 | 0 | External exception %x |
| 65484 | 0 | Assertion failed |
| 65485 | 0 | Interface not supported |
| 65486 | 0 | Exception in safecall method |
| 65487 | 0 | %s (%s, line %d) |
| 65488 | 0 | Operation aborted |
| 65489 | 0 | Exception %s in module %s at %p.
%s%s |
| 65490 | 0 | Application Error |
| 65491 | 0 | Format '%s' invalid or incompatible with argument |
| 65492 | 0 | No argument for format '%s' |
| 65493 | 0 | Variant method calls not supported |
| 65494 | 0 | Read |
| 65495 | 0 | Write |
| 65496 | 0 | Format string too long |
| 65497 | 0 | Error creating variant or safe array |
| 65498 | 0 | Variant or safe array index out of bounds |
| 65499 | 0 | Variant or safe array is locked |
| 65500 | 0 | Invalid variant type conversion |
| 65501 | 0 | Invalid variant operation |
| 65502 | 0 | Invalid NULL variant operation |
| 65503 | 0 | Invalid variant operation (%s%.8x)
%s |
| 65504 | 0 | Disk full |
| 65505 | 0 | Invalid numeric input |
| 65506 | 0 | Division by zero |
| 65507 | 0 | Range check error |
| 65508 | 0 | Integer overflow |
| 65509 | 0 | Invalid floating point operation |
| 65510 | 0 | Floating point division by zero |
| 65511 | 0 | Floating point overflow |
| 65512 | 0 | Floating point underflow |
| 65513 | 0 | Invalid pointer operation |
| 65514 | 0 | Invalid class typecast |
| 65515 | 0 | Access violation at address %p. %s of address %p |
| 65516 | 0 | Access violation |
| 65517 | 0 | Stack overflow |
| 65518 | 0 | Control-C hit |
| 65519 | 0 | Privileged instruction |
| 65520 | 0 | '%s' is not a valid integer value |
| 65521 | 0 | '%s' is not a valid floating point value |
| 65522 | 0 | '%s' is not a valid date |
| 65523 | 0 | '%s' is not a valid time |
| 65524 | 0 | '%s' is not a valid date and time |
| 65525 | 0 | '%d.%d' is not a valid timestamp |
| 65526 | 0 | '%s' is not a valid boolean value |
| 65527 | 0 | Invalid argument to time encode |
| 65528 | 0 | Invalid argument to date encode |
| 65529 | 0 | Out of memory |
| 65530 | 0 | I/O error %d |
| 65531 | 0 | File not found |
| 65532 | 0 | Invalid filename |
| 65533 | 0 | Too many open files |
| 65534 | 0 | File access denied |
| 65535 | 0 | Read beyond end of file |
