Re: Sql mdb

limelect wrote:
I have moved from pardox to mdb
On paradox i could split the time and date on 2 fields
Now my record stil hase time and date separetly
I need to make an sql on date and time
1.How can i do it
2. I tried with sql startdate=11/09/2008 no luck dose not filter at all (no error)
3. I tried with sql startdate='11/09/2008' error
4. I tried with sql startdate="11/09/2008" error
5 I tried with sql startdate=11/09/2008 0:0 error
P.S the filed hase only date no time .should i include time,I cannot!!
Are you trying to make a select query, or an update or insert? Trying to build an SQL string?

The date and time delimiter in an mdb database is # and the date must be mm-dd-yyyy and time is hh:mm:ss if the field in the database is a datetime.
SQL := 'Select * from table where startdate = #11-09-2008#';

You can concatenate the date and time, separated by a space.
Startdate := '#' + date + ' ' + time + '#';

Mike
.

Relevant Pages

  • Sql mdb
    ... I have moved from pardox to mdb ... On paradox i could split the time and date on 2 fields ... Now my record stil hase time and date separetly ... I need to make an sql on date and time ...
    (borland.public.delphi.database.ado)
  • Re: Sql mdb
    ... As for date is the date field a string?? ... Do you know of a function to convert date/time to mdb format? ... Now my record stil hase time and date separetly ... I need to make an sql on date and time ...
    (borland.public.delphi.database.ado)
  • TechTips: Paradox from an Access perspective - data model
    ... This series of articles is intended to discuss the Paradox system from the ... point-of-view of the programmer whose primary experience is grounded in ... Microsoft Access was founded on the SQL-92 data model, ... SQL standard, but operates with them much more poorly. ...
    (comp.databases.paradox)
  • Re: Command Line Query Tool for Access DB
    ... If you want to use a stored Access query that requires a parameter (e.g. ... your script can concatenate the parameterinto a SQL SELECT ... extracts data from an MDB database to STDOUT. ...
    (microsoft.public.access.queries)
  • Re: Paradox application with SQL
    ... Can someone link me to some instructional information on getting a Paradox ... application to work with an SQL server like MySQL? ... ongoing) converting of a bunch of tables, forms and reports - from Paradox ... Images and formatted memo fields is yet another story of twist and strange ...
    (comp.databases.paradox)