|
i am not just usinrg witango and sql i also use a
acces application
and there i want to caculate some time from a sql
table
----- Original Message -----
Sent: Friday, July 05, 2002 6:15 PM
Subject: Re: Witango-Talk: sql
question
So I am confused here. If you are just using
SQL 2000 and witango then the date in the field does not matter. You can
remove it from your calculation with the format:datetime as in my previous
post.
Or do I not understand the problem.
Dan
on 7/5/02 11:07
AM, robert at [EMAIL PROTECTED]
wrote:
ms sql 2000 i moved from access to
sql
----- Original Message -----
From: [EMAIL PROTECTED]
To: Multiple recipients of
list witango-talk <mailto:[EMAIL PROTECTED]>
Sent: Friday, July 05, 2002 4:58 PM
Subject:
Re: Witango-Talk: sql question
What databse you use ???
regards
Daniel
----- Original Message -----
From: robert <mailto:[EMAIL PROTECTED]>
To: Multiple recipients of list witango-talk
<mailto:[EMAIL PROTECTED]>
Sent: Friday,
July 05, 2002 4:43 PM
Subject: Re: Witango-Talk: sql
question
but i use the same
table in other appication and the can`t handle text field so i need a
datetime field whit only the tine in it
----- Original Message -----
From: [EMAIL PROTECTED]
To: Multiple
recipients of list witango-talk
<mailto:[EMAIL PROTECTED]>
Sent: Friday,
July 05, 2002 4:24 PM
Subject: Re: Witango-Talk: sql
question
Sory, i have forget
it:
For Witango
it dos no mather if you calculate with a value from a
Text-Field.
It will be handle as
number...
regards
Daniel
----- Original Message -----
From: [EMAIL PROTECTED]
To: Multiple
recipients of list witango-talk
<mailto:[EMAIL PROTECTED]>
Sent:
Friday, July 05, 2002 4:11 PM
Subject: Re: Witango-Talk:
sql question
For the
insert:
Define
teh format what you want - if your field only accept timestamps, so
change the field in a textfiled.
Hope this
help
Mit
freundlichen Gr��en, with best regards
Daniel
Richardy
________European Witango Mainland Distributor
__________
SoftDes GmbH - St. Georgener Strasse 13 - D 79111
Freiburg
Web: www.softdes.de <http://www.softdes.de>
Mail:
[EMAIL PROTECTED]
Phone: +49 - 761 - 4 555 666
Fax: +49 - 761 - 4
555 660
_________________ www.witango.net
<http://www.witango.net>
___________________
----- Original Message -----
From: robert <mailto:[EMAIL PROTECTED]>
To: Multiple recipients of list witango-talk
<mailto:[EMAIL PROTECTED]>
Sent:
Friday, July 05, 2002 3:44 PM
Subject: Re: Witango-Talk:
sql question
in
witango i can show the date how i want but is use the
sametble
in access xp and when i want to edit the fiels the
same dat show up and calc dont work properle
----- Original Message -----
From: Dan Stein <mailto:[EMAIL PROTECTED]>
To: Multiple recipients of list witango-talk
<mailto:[EMAIL PROTECTED]>
Sent:
Friday, July 05, 2002 3:33 PM
Subject: Re:
Witango-Talk: sql question
I don�t think you can prevent
the date wh3en you use Datetime as a field. But when you do your
calculation if you user
<@@local$mydate
FORMAT:Datetime=�%H::%M:%S�> (for 24 hours clock.
on
7/5/02 9:07 AM, robert at [EMAIL PROTECTED]
wrote:
i have a problem whit en sql table i have severall
field that i use as time field
and i do caclulation whit the times
so i want just the tiem 10:30:00 to be in the field when i insert
this in a sql table the field contains 1-1-1900 10:30:00
haw can i prevent
that the date is also enterd in the field
--
Dan Stein
Digital Software Solutions
799
Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile:
610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL
2000
[EMAIL PROTECTED]
www.dss-db.com
|
