Re: Witango-Talk: sql question

Fri, 05 Jul 2002 07:11:27 -0700

Title: 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 -----
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                    Mail:  [EMAIL PROTECTED]
Phone: +49 - 761 - 4 555 666         Fax: +49 - 761 - 4 555 660
_________________ www.witango.net  ___________________
----- Original Message -----
From: robert
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
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

Reply via email to