xbrdbu : new version

Franklin Demont
Posts: 166
Joined: Wed Aug 29, 2012 8:25 am

Re: xbrdbu : new version

Post by Franklin Demont »

desdesummer87 wrote:Greetings mister Franklin.
I beg you excuse my ignorance.. .: Would it be possible to get in XBRDBU, that to rename a field the restrained data did not get lost in the same...?

Thank you for your attention.
I give not attention till now on these matter. First impression : when a Dbf is active , Modify srtucture must at least load the active structure.
Personally i use a routine which uses a datadirectory (Text witch describes the dbf structure's) .
I adopted it from a library i bought +/- 1992 (* Copyright(c) 1991 -- James Occhiogrosso)
If you are intrested : i will send it when i have your e-mail adress.



Last week i worked on Edit (Copy record , Paste Record , Insert record Edit record)

Next week i hope to work on Modify structure
test
desdesummer87
Posts: 18
Joined: Thu May 19, 2011 4:50 pm

Re: xbrdbu : new version

Post by desdesummer87 »

Thank you very much for your kindness.. I will follow the future modifications attentively.

Greetings.
Franklin Demont
Posts: 166
Joined: Wed Aug 29, 2012 8:25 am

Re: xbrdbu : new version

Post by Franklin Demont »

Otto wrote:Hello Franklin,
thank you. Please excuse me. I mixed up the official new Fivewin DBU with the xWDBU clone.
You are right. In the xBRWDBU there is now all the functionality xWDBU had.
But the version is not very stable. Some functions freeze. Where should we report the errors.
Which version should now become the xWDBU replacement.

Best regards,
Otto
Otto

Today me too had some problems. Eliminating each oMsgBar:aItems[n]:refresh() solved the problem.

Only oMsgBar:refresh() seems to be allowed

FRank
test
Franklin Demont
Posts: 166
Joined: Wed Aug 29, 2012 8:25 am

Re: xbrdbu : new version

Post by Franklin Demont »

desdesummer87 wrote:Thank you very much for your kindness.. I will follow the future modifications attentively.

Greetings.
a New version is available at : http://rapidshare.com/files/3521880066/XBRDBUFD2.ZIP
(version from 17/2/2013 19h)
I believe that the most important items are now present :

Changes from FRANK DEMONT are included with the define FD

This version has omitted the defines to simplify the code !!!
Also unused code is omitted.
In the menu are the unfinished items disabled

Version from 5/2/2013

1) Xbrdbu uses only files from his own , no files from fwh as
WindowsXP.Manifest , bmp-files , some ch-files

2) Added : launch parameter cDbfFile
From command line : xbrdbu.exe cDbfFile

3) Added : Static Var : hIndex
Hash variable , holding the data to (re)index

4) Index menu and his actions : changed

NEW

5) Index management
Open Index
Close index
Index Order
Filter by scope
Change/add index

6) Utilities
Browse columns (columns configuration)
Relations
Establish Filter
Count
Statistics
Append From
Copy To
Delete
Recall
Pack
Zap

Added in this version (16/2/2013)


Messagebar from oDbfWnd : enhanced
Append From , Copy To : Format Clipboard Appended

7) Edit
Copy Record
Paste Record
Insert record : If Ordcount() == 0 , not present in old xbrdbu
Append record
Edit rec : from fivedbu
8) File
New / modify structure : New module , based on xbrowse
This module has many checks as :
Existing field : type cannot change
Field from a index expression : only len or dec can change


Frank Demont
Last edited by Franklin Demont on Sun Feb 17, 2013 6:02 pm, edited 3 times in total.
test
desdesummer87
Posts: 18
Joined: Thu May 19, 2011 4:50 pm

Re: xbrdbu : new version

Post by desdesummer87 »

Thanks again for its attention, but the problem persists. When publishing the name of a field, the data contained in him erase.

Nevertheless, quietly grateful.

desdesummer87.
Franklin Demont
Posts: 166
Joined: Wed Aug 29, 2012 8:25 am

Re: xbrdbu : new version

Post by Franklin Demont »

desdesummer87 wrote:Thanks again for its attention, but the problem persists. When publishing the name of a field, the data contained in him erase.

Nevertheless, quietly grateful.

desdesummer87.
Sorry , i am afraid that i don't understand the problem.

Frank
test
User avatar
cnavarro
Posts: 5792
Joined: Wed Feb 15, 2012 8:25 pm
Location: España

Re: xbrdbu : new version

Post by cnavarro »

Buenas tardes
Da un error en la linea 214 - > When .... en el inicio de la aplicacion en la opcion Edit si no se ha abierto ninguna base de datos
Un saludo y gracias

Translate google

good afternoon
Give an error on line 214 -> When .... at the start of the application in the Edit if not opened any database
Regards and thanks
C. Navarro
Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo
Si alguien te dice que algo no se puede hacer, recuerda que esta hablando de sus limitaciones, no de las tuyas.
Franklin Demont
Posts: 166
Joined: Wed Aug 29, 2012 8:25 am

Re: xbrdbu : new version

Post by Franklin Demont »

cnavarro wrote:Buenas tardes
Da un error en la linea 214 - > When .... en el inicio de la aplicacion en la opcion Edit si no se ha abierto ninguna base de datos
Un saludo y gracias

Translate google

good afternoon
Give an error on line 214 -> When .... at the start of the application in the Edit if not opened any database
Regards and thanks
I am Sorry.

Line 194 MENUITEM "&Edit"

Should be MENUITEM "&Edit" WHEN ! EMPTY(alias())

Also MENUITEM "&Navigation" WHEN ! EMPTY(alias())

Frank
test
Franklin Demont
Posts: 166
Joined: Wed Aug 29, 2012 8:25 am

Re: xbrdbu : new version

Post by Franklin Demont »

desdesummer87 wrote:Thanks again for its attention, but the problem persists. When publishing the name of a field, the data contained in him erase.

Nevertheless, quietly grateful.

desdesummer87.
I think that i understood the problem : when a fieldname is changed the data from this field is lost.

This i a behaviour from (x)harbour's APPEND FROM command.

First we creata a empty database with the new structure , then the old data are appended.

When the name is changed , (x)harbour can not know to which field the data belong's

Also the position from the field can not be used , fields can be erased or changed in order.

Only possibilty : use the backup file to update the new file with a little routine where you specify which field in the backup should update which field in the new one

OR as in the good old days from DBASE

1) Modi struct , append newfield (the newname) (Modify structure , file menu)
2) REPL newname WITH oldname (utilty's)
3) Modi Struct , delete oldfield
If the order from the fields is important you can also this change , using copy record, delete record , insert record and paste record


Frank
Last edited by Franklin Demont on Sun Feb 17, 2013 2:41 pm, edited 1 time in total.
test
Franklin Demont
Posts: 166
Joined: Wed Aug 29, 2012 8:25 am

Re: xbrdbu : new version (17/2/2013)

Post by Franklin Demont »

Last edited by Franklin Demont on Sun Feb 17, 2013 6:04 pm, edited 1 time in total.
test
User avatar
cnavarro
Posts: 5792
Joined: Wed Feb 15, 2012 8:25 pm
Location: España

Re: xbrdbu : new version

Post by cnavarro »

El enlace no funciona
Muchas gracias por tu esfuerzo y trabajo

The link does not work
Thank you very much for your hard work
C. Navarro
Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo
Si alguien te dice que algo no se puede hacer, recuerda que esta hablando de sus limitaciones, no de las tuyas.
Franklin Demont
Posts: 166
Joined: Wed Aug 29, 2012 8:25 am

Re: xbrdbu : new version

Post by Franklin Demont »

Sorry , i tested it from here and it is ok.
At this moment i can see that 6 downloads have been done.

Mail me at FranklinDemont@gmail.com , and i will send it.

Frank
test
User avatar
Bayron
Posts: 815
Joined: Thu Dec 24, 2009 12:46 am
Location: Philadelphia, PA

Re: xbrdbu : new version

Post by Bayron »

Error when opening an empty database and hitting the Source Button...

Code: Select all

Application
===========
   Path and name: C:\Users\Maya\Downloads\4Shared\XBRDBUFD2\xbrdbu.Exe (32 bits)
   Size: 2,884,608 bytes
   Compiler version: Harbour 3.1.0dev (Rev. 17025)
   FiveWin  Version: FWH 12.02
   Windows version: 6.1, Build 7600 

   Time from start: 0 hours 0 mins 25 secs 
   Error occurred at: 17-02-2013, 12:25:33
   Error description: Error BASE/1132  Bound error: array access
   Args:
     [   1] = A   { ... }
     [   2] = N   6

Stack Calls
===========
   Called from:  => ARRAY:__OPARRAYINDEX( 0 )
   Called from: .\source\classes\XBRCODE.PRG => CEDITCONST( 941 )
   Called from: .\source\classes\XBRCODE.PRG => TXBRCOLCODE:PRGVARCODE( 752 )
   Called from: .\source\classes\XBRCODE.PRG => TXBRCOLCODE:PRGCODECMD( 689 )
   Called from: .\source\classes\XBRCODE.PRG => TXBRCOLCODE:PRGCODE( 564 )
   Called from: .\source\classes\XBRCODE.PRG => (b)TXBRCODE_PRGCODE( 239 )
   Called from:  => AEVAL( 0 )
   Called from: .\source\classes\XBRCODE.PRG => TXBRCODE:PRGCODE( 239 )
   Called from: xbrdbu.prg => VIEWCODE( 1037 )
   Called from: xbrdbu.prg => (b)BRWBTNBAR( 794 )
   Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:CLICK( 465 )
   Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:LBUTTONUP( 656 )
   Called from: .\source\classes\CONTROL.PRG => TCONTROL:HANDLEEVENT( 1690 )
   Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:HANDLEEVENT( 1407 )
   Called from: .\source\classes\WINDOW.PRG => _FWH( 3159 )
   Called from:  => WINRUN( 0 )
   Called from: .\source\classes\WINDOW.PRG => TMDIFRAME:ACTIVATE( 980 )
   Called from: xbrdbu.prg => MAIN( 76 )
 
=====>

Bayron Landaverry
(215)2226600 Philadelphia,PA, USA
+(502)46727275 Guatemala
MayaBuilders@gMail.com

FWH12.04||Harbour 3.2.0 (18754)||BCC6.5||UEstudio 10.10||
Windows 7 Ultimate

FiveWin, One line of code and it's done...
Franklin Demont
Posts: 166
Joined: Wed Aug 29, 2012 8:25 am

Re: xbrdbu : new version

Post by Franklin Demont »

Bayron wrote:Error when opening an empty database and hitting the Source Button...

Code: Select all

Application
===========
   Path and name: C:\Users\Maya\Downloads\4Shared\XBRDBUFD2\xbrdbu.Exe (32 bits)
   Size: 2,884,608 bytes
   Compiler version: Harbour 3.1.0dev (Rev. 17025)
   FiveWin  Version: FWH 12.02
   Windows version: 6.1, Build 7600 

   Time from start: 0 hours 0 mins 25 secs 
   Error occurred at: 17-02-2013, 12:25:33
   Error description: Error BASE/1132  Bound error: array access
   Args:
     [   1] = A   { ... }
     [   2] = N   6

Stack Calls
===========
   Called from:  => ARRAY:__OPARRAYINDEX( 0 )
   Called from: .\source\classes\XBRCODE.PRG => CEDITCONST( 941 )
   Called from: .\source\classes\XBRCODE.PRG => TXBRCOLCODE:PRGVARCODE( 752 )
   Called from: .\source\classes\XBRCODE.PRG => TXBRCOLCODE:PRGCODECMD( 689 )
   Called from: .\source\classes\XBRCODE.PRG => TXBRCOLCODE:PRGCODE( 564 )
   Called from: .\source\classes\XBRCODE.PRG => (b)TXBRCODE_PRGCODE( 239 )
   Called from:  => AEVAL( 0 )
   Called from: .\source\classes\XBRCODE.PRG => TXBRCODE:PRGCODE( 239 )
   Called from: xbrdbu.prg => VIEWCODE( 1037 )
   Called from: xbrdbu.prg => (b)BRWBTNBAR( 794 )
   Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:CLICK( 465 )
   Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:LBUTTONUP( 656 )
   Called from: .\source\classes\CONTROL.PRG => TCONTROL:HANDLEEVENT( 1690 )
   Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:HANDLEEVENT( 1407 )
   Called from: .\source\classes\WINDOW.PRG => _FWH( 3159 )
   Called from:  => WINRUN( 0 )
   Called from: .\source\classes\WINDOW.PRG => TMDIFRAME:ACTIVATE( 980 )
   Called from: xbrdbu.prg => MAIN( 76 )
 
This error was already reported , see http://forums.fivetechsupport.com/viewt ... 37#p139286

at 19 h i published a new download link:

http://rapidshare.com/files/3521880066/XBRDBUFD2.ZIP
test
desdesummer87
Posts: 18
Joined: Thu May 19, 2011 4:50 pm

Re: xbrdbu : new version

Post by desdesummer87 »

Si. Ese es el problema que procuraré solventar del mejor modo posible.. Gracias de nuevo por su dedicación.
=====================================================================
If. That one is the problem that I will try to solve as good as possible.. Thanks again for its dedication.
Post Reply