When importing data, judge whether the data table name already exists in the table: t_hrm_personnel_info fields: PersonnelID


Long ll_count


Ll_count=0

Select count (1)
Into: ll_count
The from t_hrm_personnel_info
Where PersonnelID=: sPersonnelID;



Why this has been an error in PB,,,, I interviewed in the mysql can turn to again!!!!!!!!!!!!!!!

CodePudding user response:

[ODBC SQLSTATE=37000/MYSQL 5.1 Driver] [MYSQL - 5.1.29 - rc - community] FUNCTION i3gb_stationery. The count does not exist


Error message

CodePudding user response:

Select count (*)
Into: ll_count
The from t_hrm_personnel_info
Where PersonnelID=: sPersonnelID;

CodePudding user response:

Configure ODBC selected support aggregation function