ADS and time fields [done]

[MOISES]

Hello,

I would like to know it latest ADS versión, I guess it´s 11, supports Time "T" fields.

Also, what advantages has versión 11 over versión 10?.

Thank you.

[MOISES]

Any clue?.

Thanks.

[fraxzi]

Moises,

ADS support 'TimeStamp' fieldtype.

I'm only using v10

[MOISES]

Hello,

I am afraid this sample does not work, it does not créate the dbf:

#include "ads.ch"

REQUEST HB_Lang_ES
REQUEST HB_CODEPAGE_ESWIN


//-------------------------------------------------------------------------------------------------------------
FUNCTION MAIN()
//-------------------------------------------------------------------------------------------------------------

LOCAL aStruct, cFichero, nRet := 0



// Idioma español para Harbour
HB_LangSelect("ES") // Para mensajes, fechas, etc..
HB_CDPSELECT("ESWIN") // Para ordenación, requiere CodePage.lib



REQUEST DBFCDX, DBFFPT

Request ADS,ADSKeyCount,ADSKeyNo,OrdKeyCount,OrdKeyNo, AdsGetRelKeyPos, AdsSetRelKeyPos

RddRegister( "ADS", 1 )
RddSetDefault( "ADS" )


adsSetServerType( 1 ) // ó ADS_LOCAL_SERVER


//setting up the file types
adsSetFileType( ADS_CDX )


// resto de sets
AdsRightsCheck( .F. )
SET DELETED ON





aStruct := { { "NAME", "C", 15, 0 },;
{ "DATE", "D", 08, 0 },;
{ "TIME", "T", 08, 0 },;
{ "TEXTO", "C", 50, 0 } }



cFichero := hb_dirbase() + "MOISES.DBF"
FErase( cFichero )


nRet := DbCreate( cFichero, aStruct ) //, "DBFCDX" )
Alert( "DbCreate() " + cValToChar( nRet ) )




USE &cFichero NEW
APPEND BLANK

REPLACE FIELD->NAME WITH "Test Moises"
REPLACE FIELD->DATE WITH Date()
REPLACE FIELD->TEXTO WITH "Bla bla bla"
DbGoTop()

Browse()


DbCloseAll()

QUIT

RETURN NIL


Any clue?.

Thank you.

[Marcelo Via Giglio]

Moises,

DBFs are DBFs for ADS too, then for use other data types out of the classic DBF types you need to use ADT tables

regards

Marcelo

[MOISES]

Marcelo,

Thanks, but DBFS support this data type field, "T", so DBFS via ADS should also support it.

When changing adsSetFileType to ADSADI, how can I create a table with the timestamp field please?.

[MOISES]

Solved,

Not supported and must use ADT tables.

http://devzone.advantagedatabase.com/fo ... s#fmanswer