Search found 352 matches

by ADutheil
Sat Sep 21, 2013 11:31 am
Forum: FiveWin for Harbour/xHarbour
Topic: Nag Screen
Replies: 9
Views: 1575

Re: Nag Screen

Did U try the code I sent? Works OK for me.
by ADutheil
Fri Sep 20, 2013 9:36 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Nag Screen
Replies: 9
Views: 1575

Re: Nag Screen

Silvio, try this: your code .......... nSecs := 20 // The seconds u wuant to wait. MsgMeter( { | oMeter, oText | CountDown( nSecs, oMeter, oText ) }, "          " + allTrim( str( nSecs ) ) + " SECONDS", "PLEASE WAIT..." ) ........ your code FUNCTION CountDown( nSecs, oM...
by ADutheil
Wed Sep 18, 2013 2:35 am
Forum: FiveWin for Harbour/xHarbour
Topic: Seek or scope for not empty dates
Replies: 9
Views: 1523

Re: Seek or scope for not empty dates

You could create 2 distincs tags with FOR clause, one FOR priorita and the other FOR !priorita. Otherwise I can´t see how to get rid of the IF.
by ADutheil
Sun Sep 15, 2013 12:54 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Seek or scope for not empty dates
Replies: 9
Views: 1523

Re: Seek or scope for not empty dates

If you have an index based on filed->DATE you might soft seek ou bottom scope to the first day of the epoch your are set.
by ADutheil
Fri Sep 13, 2013 6:28 pm
Forum: FiveWin for Harbour/xHarbour
Topic: MySQL-query question
Replies: 8
Views: 2241

Re: MySQL-query question

Yes it is the field that stores the id of each record from the table. It´s a primary key I created to fake Harbour recno().
by ADutheil
Fri Sep 13, 2013 5:18 pm
Forum: FiveWin for Harbour/xHarbour
Topic: MySQL-query question
Replies: 8
Views: 2241

Re: MySQL-query question

Marc, Here is the way to keep the recordnumber (SQL_ROWID in my sample) without stored proc. SELECT STATEID, SALARY, RANK, IDS    FROM    (    SELECT SUMMARY.*, @prev := @curr, @curr := SUMMARY.SALARY,    @rank := IF( @prev = @curr, @rank, @rank + 1 ) AS RANK    FROM    (    SELECT `STATE` AS STATEI...
by ADutheil
Fri Sep 13, 2013 10:11 am
Forum: FiveWin for Harbour/xHarbour
Topic: MySQL-query question
Replies: 8
Views: 2241

Re: MySQL-query question

Try to add ORDER BY vtotaal to your query. You´ll get the totals ranked.

Code: Select all

SELECT field1, field2, SUM(fieldn) AS field3 FROM tablename GROUP BY field1 ORDER BY field3;
But I think if you use GROUP you can´t keep the record number without creating a stored procedure to keep them into na array.
by ADutheil
Sat Sep 07, 2013 6:10 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Strange problems since loading FWH 13.07
Replies: 39
Views: 13387

Re: Strange problems since loading FWH 13.07

Included missing French and Portuguese translation. May my ancestors forgive me! static nLanguage := 0   // Initially will be set by LanguageID() function // 1 English, 2 Spanish, 3 French, 4 Portugese, 5 German, 6 Italian static aStrings := { ;    { "Attention", "Atención", &quo...
by ADutheil
Sat Sep 07, 2013 1:40 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Strange problems since loading FWH 13.07
Replies: 39
Views: 13387

Re: Strange problems since loading FWH 13.07

Antonio, I just tested FiveDBU and could not change language to portuguese. Seems that it looks for German (DE). http://img35.imageshack.us/img35/2668/lwfg.png Uploaded with ImageShack.us FIVEdbu changed to German and on exit it asked to copy and paste some code. May be you can use the following:   ...
by ADutheil
Fri Sep 06, 2013 9:52 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Converting CVS files
Replies: 46
Views: 17635

Re: Converting CVS files

I have no idea, sorry.
by ADutheil
Fri Sep 06, 2013 1:02 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Converting CVS files
Replies: 46
Views: 17635

Re: Converting CVS files

Worked here: E:\Projetos\Hunter>dir  O volume na unidade E é Novo volume  O Número de Série do Volume é FE0F-23B7  Pasta de E:\Projetos\Hunter 06/09/2013  09:59    <DIR>          . 06/09/2013  09:59    <DIR>          .. 06/09/2013  09:56    32.285.970.683 HUNTER.dbf 06/09/2013  08:28           705.5...
by ADutheil
Fri Sep 06, 2013 11:44 am
Forum: FiveWin for Harbour/xHarbour
Topic: Converting CVS files
Replies: 46
Views: 17635

Re: Converting CVS files

Hunter, Try this: #include "fileio.ch" //ADVANCE CENTER FOR CHIROPRACTIC, ACUPUNCTURE, NUTRITION, LTD. REQUEST DBFCDX FUNCTION Main LOCAL hCsv LOCAL cLine, aLine LOCAL nI := 0 RDDSetDefault( "DBFCDX" ) set( 4, "mm/dd/yyyy" ) set( 5, 1930 ) SET DATE AMERICAN //CriaDBF() ...
by ADutheil
Fri Sep 06, 2013 1:37 am
Forum: FiveWin for Harbour/xHarbour
Topic: Converting CVS files
Replies: 46
Views: 17635

Re: Converting CVS files

I don't think the 4GB limit for a DBF is still valid with Harbour. I wrote a little program to begin testing it and easily created a 7GB DBF. REQUEST DBFCDX FUNCTION Main LOCAL hCsv LOCAL cLine LOCAL nI := 0 RDDSetDefault( "DBFCDX" ) set( 5, 1930 ) CriaDBF() USE HUNTER NEW EXCL ALIAS HUNT ...
by ADutheil
Wed Sep 04, 2013 12:21 am
Forum: FiveWin for Harbour/xHarbour
Topic: Converting CVS files
Replies: 46
Views: 17635

Re: Converting CVS files

Hunter,

Can you share the file in some cloud based storage like googledrive, dropbox or any other one so we can download it?
by ADutheil
Fri Aug 30, 2013 3:26 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Converting CVS files
Replies: 46
Views: 17635

Re: Converting CVS files

HunterEC,

the file you are importing might be corrupted at some point or some data might not fit the expected pattern.