Home > Back-end >  Val functions available in the access, SQL in borland c is not available, how to solve?
Val functions available in the access, SQL in borland c is not available, how to solve?

Time:09-30

The SELECT dbo_tabRealTimeData StationNum, Sum (Val (dbo_tabRealTimeData. Precipitation)) AS bb FROM dbo_tabRealTimeData WHERE dbo_tabRealTimeData. ObservTimes>" 201303012100 "And dbo_tabRealTimeData. ObservTimes<" 201303022000 "GROUP BY dbo_tabRealTimeData. StationNum ORDER BY dbo_tabRealTimeData. StationNum DESC
The above SQL statement execution in the access no problem, but in borland c + + has a problem, problem hint for "val cannot identify the internal function name"
How to solve the problem, please?

CodePudding user response:

In CB, what is your connection of database, or ACCESS?
Different database SQL statement is that some of the differences

CodePudding user response:

In the same SQl database, ACCESS the SQl query has been debugging through, transplanted to the CB, the more wrong, can't perform,
  • Related