Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Form with sql passthrough works in ide, not in exe ?
Message
From
28/12/2004 04:56:47
 
 
To
28/12/2004 03:00:42
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Germany
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MySQL
Miscellaneous
Thread ID:
00972038
Message ID:
00972506
Views:
14
>Hello Fabio !
>Thank you for your quick answer even on cristmas!!
>I changed my function to build a timestampstring as you suggest.
>procedure p_datum_timestamp
>SET MARK TO '-'
>SET DATE TO YMD && ANSI it is incorrect
>l_timestamp = DTOC(DATE())+" "+ TIME(0)
>
>*alte version
>*SET DATE TO ansi
>*l_timestamp = ALLTRIM(TRANSFORM(DATE()) + " " + TRANSFORM(TIME(TIME())))
>
>SET DATE TO GERMAN
>RETURN (l_timestamp)
>
>endproc
>
>d_updated = p_datum_timestamp()
>
>update ...... set d_updated = ?d_updated .....
>
>Now the form works from ide and from exe without format errors, but .....??????
>When executing my form from ide i have the format i want in all textboxes and grids !!!
>When executing my form from an exe i have the timestamp format with an AM,PM extension in all textboxes and grids ????
>
>I can't find, what makes the difference ??
>
>Best regards
>Albert

Hi Albert,
add
SET HOURS TO 24
You have to config the VFP setting into the exe environment.

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform