Search found 352 matches
- 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.
- 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...
- 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.
- 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.
- 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().
- 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...
- 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.
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.
Code: Select all
SELECT field1, field2, SUM(fieldn) AS field3 FROM tablename GROUP BY field1 ORDER BY field3;
- 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...
- 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: ...
- 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.
- 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...
- 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() ...
- 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 ...
- 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?
Can you share the file in some cloud based storage like googledrive, dropbox or any other one so we can download it?
- 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.
the file you are importing might be corrupted at some point or some data might not fit the expected pattern.