TheSonics
asked on
SQL weird
SELECT DISTINCT fldHistoSItemsDate, fldHistoSItemsHeure, fldHistoSItemsEmp
FROM [Histo - SItems]
WHERE (fldHistoSItemsSaisie = 144)
ORDER BY fldHistoSItemsDate, fldHistoSItemsHeure
This request returns me 4 result in VB6 but 1300 in SQL Manager... any idea ? not the same format but same value.
FROM [Histo - SItems]
WHERE (fldHistoSItemsSaisie = 144)
ORDER BY fldHistoSItemsDate, fldHistoSItemsHeure
This request returns me 4 result in VB6 but 1300 in SQL Manager... any idea ? not the same format but same value.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What is the data type of fldHistoSItemsSaisie?
I think that you should ask to have your grade re-marked, if none of these solutions gave you your answer then you should have indicated as such - C's should only rarely / if ever be given - read the help files if you are unsure
Additionally since navstar's answer was just agreeing with AngelIII's answer he should be given some of the credit.
Additionally since navstar's answer was just agreeing with AngelIII's answer he should be given some of the credit.
point split Raynard, angelIII, navstar16