Index DATE() / Time() - comp.lang.xharbour

hi, i can create this INDEX ON DTOS(MyDate) TAG "MY_DATE" TO &(_cdxname) but i fail in INDEX ON STRTRAN(MyTime,':','') TAG "MY_TIME" TO &(_cdxname) Index will be create but when try to open DBF with BRO.EXE v2.5 ( compiled with Cl*pper) i got : " Structural Index may contain Undefined Tag Expressions" i knew STRRAN() will "reduce" LEN() of Field "MyTime" ... how to make a Cl*pper / Xbase++ compatible Index with DATE() and TIME() ? REQUEST DBFCDX RddSetDefault( "DBFCDX" ) USE ( zDBF ) EXCLUSIVE INDEX ON DTOS(MyDate)+STRTRAN(MyTime,':','') TAG "MY_START" TO &(_cdxname) greetings by OHR Jimmy

Il 04/03/2011 3.39, AUGE_OHR ha scritto: > hi, > > i can create this > > INDEX ON DTOS(MyDate) TAG "MY_DATE" TO&(_cdxname) > > but i fail in > > INDEX ON STRTRAN(MyTime,':','') TAG "MY_TIME" TO&(_cdxname) > > Index will be create but when try to open DBF with BRO.EXE v2.5 > ( compiled with Cl*pper) i got : > > " Structural Index may contain Undefined Tag Expressions" > > i knew STRRAN() will "reduce" LEN() of Field "MyTime" ... > how to make a Cl*pper / Xbase++ compatible Index with DATE() and TIME() ? > > REQUEST DBFCDX > RddSetDefault( "DBFCDX" ) > USE ( zDBF ) EXCLUSIVE > > INDEX ON DTOS(MyDate)+STRTRAN(MyTime,':','') TAG "MY_START" TO&(_cdxname) > > greetings by OHR > Jimmy > > > Hi Jimmy, I don' know what BRO.EXE is. Probably it does not contain strtran(). Try INDEX ON DTOS(MyDate)+left(Mytime,2)+right(Mytime,2) TAG "MY_START" TO&(_cdxname) instead. Dan

hi, > I don' know what BRO.EXE is. Probably it does not contain strtran(). BRO.EXE is like DBU.EXE but enhance mit COMIX / SixDrive etc. it should, while i can open it with Cl*pper (COMIX) and Xbase++ (FOXCDX) > Try INDEX ON DTOS(MyDate)+left(Mytime,2)+right(Mytime,2) TAG "MY_START" > TO&(_cdxname) instead. aha ... YES ... good Idee. greetings by OHR Jimmy

On Mar 3, 7:39=A0pm, "AUGE_OHR" <AUGE_OHR*NOS...@WEB.DE> wrote: > hi, > > i can create this > > INDEX ON DTOS(MyDate) TAG "MY_DATE" TO &(_cdxname) > > but i fail in > > INDEX ON STRTRAN(MyTime,':','') TAG "MY_TIME" TO &(_cdxname) > > Index will be create but when try to open DBF with BRO.EXE v2.5 > ( compiled with Cl*pper) i got : > > " Structural Index may contain Undefined Tag Expressions" > > i knew STRRAN() will "reduce" LEN() of Field "MyTime" ... > how to make a Cl*pper / Xbase++ compatible Index with DATE() and TIME() ? > > REQUEST DBFCDX > RddSetDefault( "DBFCDX" ) > USE ( zDBF ) EXCLUSIVE > > INDEX ON DTOS(MyDate)+STRTRAN(MyTime,':','') TAG "MY_START" TO &(_cdxname= ) If you have the source code for BRO, then you can add a function in any module (or just link it in), that have calls to the various functions you might someday want to call. This will cause them to be named in a way that they can be called. And the wrapper function you create never has to be called form your code. Additionally, you can just REQUEST strtran .... and get it too. (I think) You may want to use DateTime() and TtoS() also, at some point... David A. Smith

Similiar Articles:

Index on timestamp with timezone AT LOCAL - comp.databases.oracle ...
Hi all, I have a table with a time stamp with timezone column: CREATE TABLE TEST_TZ ( DATE_TIME_TZ TIMESTAMP(3) ); CREATE INDEX IDX...

Converting date to serial date (Beginner problem) - comp.soft-sys ...
... time-series (yyyy-mm-dd) and I want to convert the dates to Matlab serial dates. time ... using datenum(dates{1}) but when I try to more than one date it tells me Index ...

Putting date and time in input feild of form?!?! - comp.lang ...
... comp.lang.javascript <URL:http://www.merlyn.demon.co.uk/js-index.htm> jscr maths, dates ... Date()" as you have. > Mick Hi Mick, Any way I could get the date and time ...

How to add 7 days to the current date? - comp.lang.javascript ...
<URL:http://www.merlyn.demon.co.uk/js-index.htm> jscr maths, dates, sources. ... and since the date only changes once per day ... Add a date or time stamp to ...

Datetick - comp.soft-sys.matlab
I am using datetick to convert matlab date to "human readable date' using ... datenum('1-Jan-2010'), -4, 4]); datetick('x','yyyy'); title ('PDO Index'); xlabel ('Time');

Week number - comp.lang.rexx
... DAYS.[FRACT]] "SDATE[ TIME]", "Q" quarter index (1-4) "SDATE[ TIME ... via the > commandline as well: > > DATERGF: manipulate sorted dates, time ...

sort multiple images - comp.soft-sys.matlab
images=dir(fullfile(directory,'*.tif')); [names index]=sortrows({images.name ... the 'date of modification' and not that of 'creation'. thus when the date (and time) is ...

Calculating "working days" for a given period - comp.lang ...
... comp.lang.javascript <URL:http://www.merlyn.demon.co.uk/js-index.htm> JS maths, dates ... Date and Time Calculation - comp.databases.filemaker... then gives me the ...

Matlab Toolbox path cache out of date - comp.soft-sys.matlab ...
Now, every time I start Matlab again, I get this message ... www.mathworks.com/support/sysreq/release2007a/index.html ... soft-sys.matlab Matlab Toolbox path cache out of date ...

create index online - comp.databases.informix
Hi all, I created a new index ONLINE. Thought that would cause no ... > Date: 04.11.2009 Time: 18:51:54 > > Program error at "/home/projekte/p3_neu/lib/f_vo_upd ...

Time and Date
Animated LIVE Countdowns for all occasions. Personalized LIVE Countdowns to Birthday, Retirement, Baby Due Date, Sports events and much more! Upgraded Time Difference ...

Index on Date/Time - Toolbox for IT Groups
Dear All, I have a Date/Time field that I want to index, however I only want to index the Date part of the field and not the time ...

7/21/2012 3:30:06 AM