In order to escape from Paradox I am trying to put up a new
database in MS Access and still be able to use Paradox scripts
etc. This would be possible by creating an alias in Paradox BDE
and then connect to the Access database. The scripts could easily be rewritten
with the alias name added to the filenames. The problem is the Date/Time
format. Opening a linked table in Paradox a column with data type "Date"
shows both date and time, and what is worse, it is not possible to add a
new date without adding time. This is no problem in Access and I therefore
suspect it is a function residing in the ODBC Driver. Unfortunately this
is not configurable with regard to the Date/Time format. Does anyone know
how to solve this problem?

Svante

I have almost no experience of using MS Access tables from Paradox.

I could run a select statement from Paradox using a condition
where Orderdatum > {d'1997-01-01'}.

Are you updating the Access tables with SQL or tcursors?



--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Svante Nyberg" <syber (AT) ecology (DOT) su.se> skrev i meddelandet
news:44e1b192$1 (AT) pnews (DOT) thedbcommunity.com...

Bertil

I have only created a table in MS Access with different
Date/Time columns with different configurations ("short date",
input mask etc) for testing purpose. I have not tried to edit or
enter a date in the linked MS Access table by using TCURSOR from
Paradox objectPAL. I have only "manually" tried to enter a date
in an open linked table in edit mode in Paradox.
If it is a ODBC-problem, do you know any other way to link a MS Access table
to Paradox? ADO, JDBC?

/Svante




"Bertil Isberg" <ctech (AT) corel (DOT) ca> wrote:

Svante

Can you enter the date if you also enter the time? Which format do you
use in this case?

Does Access have a date datatype or is date an input mask for datetime
datatype?

I would be very surprised if you can find anything better than ODBC to
connect from Paradox to Access.


There's another possible approach. Get Access data into Paradox tables
strored in PRIV, so each user gets his own copy. You can select one
master record and linked detail records at a time.

Edit the Paradox table, and send it back to Access using ObjectPAL. This
is the recommended approach when using Paradox as front end to SQL Server.

--
Bertil Isberg
CTECH
Paradox Buglist: http://hem.bredband.net/bertilisberg/

remove spamfilter (reversed) to reply

Svante

Maybe the easiest way to handle this is to enter the time using the
spacebar. E g enter the date 2006-08-17 and press spacebar three times.
This gives you the current time.

Obviously, Access has a datetime datatype. The smalldate format is only
a formatting of the datetime.


--
Bertil Isberg
CTECH
Paradox Buglist: http://hem.bredband.net/bertilisberg/

remove spamfilter (reversed) to reply

Svante

If you're working in a form, you can add a picture property to the field.

####-##-## 00:00:00

will fill in the time automatically (I'm using Format=DB Timestamp )
For some reason, the default Win.Timestamp shows the time first, and I
can't find where to change this is Windows.


--
Bertil Isberg
CTECH
Paradox Buglist: http://hem.bredband.net/bertilisberg/

remove spamfilter (reversed) to reply

Bertil Isberg wrote:
and if you are working with a script you can use
mydate=datetime("24.12.2006")
Hej Tomte Gubbar ...


marco

Thank you! I will try what you are suggesting.

/Svante

marco <n_sp_hum_marco.foglia (AT) tucsoft (DOT) com> wrote: