FiveTech Software tech support forums

... MEMOREAD( cFile ) )


There is one problem with HASH --> JSON --> HASH.
Any date values in the original hash are converted to character stings "yyyymmdd". Unless we scan the hash and convert all such values back to date type, the hash can not be used in date calculations.

Please try this simple ...

... RIFERIM.","QUANTITA","IMPORTO","COSTO" ; PICTURE ,,,,"@ZE 99,999,999.999", "@ZE 99,999,999.999", "@ZE 99,999,999.999" ;
in this XBROWSE there is dAAAAMMGGadata FUNCTION whit single quotes that convert field DATA from YYYYMMDD to DD/MM/YYYY and it works for each row in oRsMovimenti

thank you

Numerics and dates are sorted in the order of the values, not as character values.
So the seeks can not be on the initial characters as they appear in the browse.

Numerics: Seek to the value next higher than the value entered.
Dates: Seeks to the value next higher than the value in YYYYMMDD format

... you send the information of these 3 lines you remove them from the text file, with this you will always have the information that you need in the local log or online.

You can split in little files too:
Folder YYYYMMDD

Files HHMM - file with info about this Hour/Minute if each 5sec, 12 records/lines

... 41; Devuelve " / / "

esto es correcto, ambas cadenas de fechas construidas estan fallando, la idea es que hb_DtoS(dFecha) retorna una cadena "YYYYMMDD", hb_StoD(cFecha) transforma una cadena "YYYYMMDD" a formato fecha, de ello se desprende que:

"2013" + "1" + "7" -> "201317"
"2013" + "17" + "7 ...

Silvio

APPEND FROM .... converts dates ONLY of the source data is in YYYYMMDD format.

In your case you have to create the field as character field with length 10.
After importing you have to copy to other file converting date with CTOD()

Or you can adopt my earlier logic with needed changes. Change ...

... 2 clientes y les instale la misma aplicacion y en uno corria bien y en otro no, daba errores por las fechas, y comence a usarlas en formato ANSI YYYYMMDD talcual como las devuelve DTOS y ya no estoy pendiente de las fechas.

este codigo lo acabo de probar en mysql y corre perfecto

select * from ...

... CODIGO,NOMBRE,VENCTO,IMPORTE, FROM VENCTOS WERE VENCTO >= '"+DtoS&#40; dInicio &#41;+"' AND VENCTO <= '"+DtoS&#40; dFinal &#41; + "'"


uso dtos en vez de dtoc para convertirlo a string y usar la fecha como ansi "yyyymmdd", asi no tienes problemas con el codigo sql, corre en sql server y mysql.

Dear Marc Vanzegbroeck,

Try use numeric for date with format YYYYMMDD ,

like :

11795129,20120731,42,9,"","Laadbrug",8,1,0,0.00


Thank

kok

... iParam, ... )

after
const char * hb_parc( int iParam, ... )


line 629

before
char * hb_pards( int iParam, ... ) /* retrieve a date as a string yyyymmdd */

after
const char * hb_pards( int iParam, ... ) /* retrieve a date as a string yyyymmdd */


line 1518

before
ULONG hb_snprintf( char ...

... hb_parc( int iParam, ... )
to
const char * hb_parc( int iParam, ... )

627:
char * hb_pards( int iParam, ... ) /* retrieve a date as a string yyyymmdd */
to
const char * hb_pards( int iParam, ... ) /* retrieve a date as a string yyyymmdd */

1518:
ULONG hb_snprintf( char * buffer, ULONG nSize ...

... CLASS TDicomVRDA - DICOM Value Representation Date ** ** A date in the format YYYYMMDD ** *\**************************************************************/CLASS TDicomVRDA FROM TDicomVR METHOD New&#40; str_Group, str_Element, var ...

... type. If they are not,
a runtime error occurs when the APPEND FROM command is invoked.

Any date information in <xcFile> must be in the format yyyymmdd to be
properly APPENDed.

In a network environment, APPEND FROM does not require that the current
database file be USEed EXCLUSIVEly or locked ...

... the same principle as one would need for XML. You would need to add definitions for Data, Export Translations (i.e. would date be exported as YYYYMMDD or MM/DD/YYYY, logicals as -1=True, 0=False)

I am hoping that perhaps a group of us could come up with a DTD format, then a generic 'class' to ...

Two suggestions.

Date may be formatted as yyyy-mm-dd but not as yyyymmdd. This can be done by SET DATE ANSI and use DTOC( dvar ).

For empty dates use null string.

Logicals may be converted as TRUE or FALSE. Excel understands True / False but not YES / NO.