I have attached the access database as 2007 and 2003.
The data is from a highscore list, i need alle the names distinct and all the other colums as a single row ordered by newest charDate.
My application needs to give me an fast overview about changes on the highscore, so do u know if its possible to make one sql call, and get 2 rows, giving one charName and 2 dates ?
I juse:
SELECT Data.charName, Data.charLevel, Data.charDate FROM Data WHERE (Data.charDate=#1/6/2009 0:0:1# or Data.charDate=#1/6/2009 0:1:0#) and charName = 'Renegade'
But can i in the same SQL statement, take the difference of charBlood from the two dates ?
i have attached a screendumb of my applikation, right now i just take alle the names from the newest date and loop through em all;
string lastSql = "Select * from Data where charName = '"+Name+"' and (((data.charDate)=#"+dtLast.ToString("M/d/yyyy H:m:s")+"#))"; string nowSql = "Select * from Data where charName = '" + Name +"' and (((data.charDate)=#"+dtNow.ToString("M/d/yyyy H:m:s")+"#))";
But the call is very expensive as the database grows, therefore it could be neat if i could get the diffrence in charBlood in the same SQL
Hi Jacob What is the status on this question, did we ever find a solution?
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.