Java- og Access-datoer

Java (this is Access)!

??

Jeg har som sagt problemer med dato-formaterne og med at få konstrueret en SQL-sætning, der duer!
F.eks. virker følgende IKKE:

\"SELECT Id FROM Kampe WHERE Date(aktuelle dato) > Date(Dato)\";

HJÆÆÆÆLP!!

Challengers>As I mentioned, this is Access and NOT JAVA. Giving an SQL statament in Access is not the same as JAVA and thats more than likeley the reason wht you havent received others answers.

In this example youcan see the SomeDateField is NOT within the string \"\" how this is done in JAVA is up to you and it should be formatted MM/DD/YYYY

Its years ago since I played around with C/C++ so I cant remember how to contactenate strings.
Hope you get the idea!

SQLString = \"SELECT Id FROM Kampe WHERE #\" & SomeDateField  & \"# > DatabaseDateField\"

Thats not right! If you want to see those where the date is > than the current date:
tblDateField is the name of the column in the database and Date() gives the current date!

\"SELECT Id FROM Kampe WHERE [tblDateField] > Date();\"

?

Hvis jeg bruger denne sætning, opstår der en SQLException, der giver følgende meddelelse: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Skal Date()-funktionen have parametre med??

tblDateField needs altering to the name of the field in YOUR table

Ja, det har jeg også fundet ud af - nu virker det. Mange tak for hjælpen! Pointene er dine!

thanks:o)