FiveTech Software tech support forums

... "see" DATEFORMAT in CLASS TDataRow Note: Picture clauses for Dates in (x)Harbour PICTURE "@D" // Use dateformat set. (default American, i.e., 'mm/dd/yy' ) PICTURE "@E" // Force European format ( i.e., 'dd/mm/yy' ) even if the format is set to American ok, but i don´t ...

... sets correct dateformt to Dates also Note: Picture clauses for Dates in (x)Harbour PICTURE "@D" // Use dateformat set. (default American, i.e., 'mm/dd/yy' ) PICTURE "@E" // Force European format ( i.e., 'dd/mm/yy' ) even if the format is set to American

What is your FWNumFormat setting ? xbrNumFormat( "E", .T. ) // "E" for European, "A" for American and others // .t. for showing thousand separators * New function nStrToNum( cNumericVal, [lEuropean] ) --> nVal Optional Parameter lEuropean defaults ...

Dear Tim, Ask at the North American Post Office, if the Code is Two-Dimensional Datamatrix 2D??

Estimado Tim, Pregunte en la oficina de correos de América del Norte si el código es bidimensional Datamatrix 2D?

Thanks

Regards, saludos.

... like that Syntax Date Format ANSI yy.mm.dd BRITISH dd/mm/yy FRENCH dd/mm/yy GERMAN dd.mm.yy ITALIAN dd-mm-yy JAPAN yy.mm.dd USA mm-dd-yy AMERICAN mm/dd/yy so "extract" YYYY, MM and DD from Element before store into DBF

... You have to use ' ' around your date variables. Rick Lipkin DTOC() does not work for MySql. Another thing, there a few things which work for Americans but not others in the world. because some database servers accept American notation of dates. For example your syntax of DTOC() does not work ...

Silvio.Falconi wrote:Nages,
someone (an american boy) sad me not use lock and unlock (and commit) because
tdatabase make it auto.

Not FLOCK

Nages,
someone (an american boy) sad me not use lock and unlock (and commit) because
tdatabase make it auto.

... dDataFinale:= ctod("08/07/2021") SET DATE ITALIAN  By default, the date format is American ( MM/DD/YY ) not ( DD/MM/YY ). You wanted to assign 4th July 2021 and 8th July 2021 to dDataIniziale and dDataFinale, but in fact you assigned ...

By converting an excel file to a dbase file the date field is switching to the american style (MM/DD/YYYY)
How to prevent or rectify this?

... Main() local oDlg, oBrw SET DATE BRITISH SET CENTURY ON xbrNumFormat( "E", .t. ) // "E" for European, "A" for American and others // .t. for showing thousand separators USE ITEMS /* CCODE Character 10 DETAIL Character 50 PVP1 Numeric 14 5 PVP2 Numeric 14 5 PVP3 ...

Marc Venken wrote:Maybe :

xbrNumFormat( "E", .t. ) // "E" for European, "A" for American and others
// .t. for showing thousand separators

but why the same source code on another procedure run ok ?

Maybe :

xbrNumFormat( "E", .t. ) // "E" for European, "A" for American and others
// .t. for showing thousand separators

... Main() local oDlg, oBrw SET DATE BRITISH SET CENTURY ON xbrNumFormat( "E", .t. ) // "E" for European, "A" for American and others // .t. for showing thousand separators USE ITEMS /* CCODE Character 10 DETAIL Character 50 PVP1 Numeric 14 5 PVP2 Numeric 14 5 PVP3 ...

Ejemplo funcional, valida Visa, American Express, Diners y MasterCard. #include "FiveWin.ch"Static oWnd//----------------------------------------------------------------------------//Function Main()   DEFINE WINDOW oWnd ...