DBF editors

[Otto]

Hello,
after trying many DBF editors I find that

XBRDBUFD3 https://code.google.com/p/fivewin-contr ... P&can=2&q=

is for daily work a very good editor.

Does someone know from whom this code is.

Best regards,
Otto

[Antonio Linares]

Otto,

Franklin Demont

viewtopic.php?p=142240#p142240

[Antonio Linares]

viewtopic.php?p=144765#p144765

[Otto]

Dear Antonio,
thank you.
Do you know if there is newer version.
Best regards,
Otto

[Antonio Linares]

It seems as XBRDBUFD6 is the most recent one

but the rapidshare link is broken

[cnavarro]

It seems as XBRDBUFD6 is the most recent one

but the rapidshare link is broken

https://bitbucket.org/fivetech/fivewin- ... DBUFD6.ZIP

[Otto]

Hello,
does someone know if
Franklin Demont
still is working on DBF editor.
Thanks in advance
Otto

[Franklin Demont]

Otto and other fw users

Last two years i am not anymore active in FWH , last and unique client has gone.

Next days i will try to see if i can still do something on FWDBU.

Otto , which problem has to be resolved ?

Frank

[Otto]

Hello Franklin,

Thank you for your answer.
I am searching a substitute for my wDbu which is not compatible with 64 bit.
I found you dBase Editor and for me it has all I get from wDbu.

The program works fine. Thank you.
I am asking as we have developed some tools as full text search in memofields, automatic source code generator for xBrowse, EasyReports and more.

It would be fine if we could integrate this into the editor.

I think it is time to favorite one dBase editor for the community. And for me yours at the moment is the completest.

I mean we need: name, logo, helpfile, API, a person/team who is keeping the source code.

Maybe “frankly dBase” could be a good name. 
The word by word translation to German sounds good – but I do not know if “franky dBase” would hit the sense for a native speaker.

Best regards,
Otto

[Antonio Linares]

Otto, Franklin,

I think it would be great if we could merge FWH\samples\FiveDBU.prg and Franklin FWDBU functionality

https://bitbucket.org/fivetech/fivewin-contributions/downloads/fivedbu_20160412.zip

[Franklin Demont]

Otto , Antonio

Till , two year ago i worked on fwdbu , espacially on :

1) restoring and saving DBF configuration
2) Copy to and working with ADO-format , using some code from fivedbu

It has not been fully tested , stopping with fivewin at that moment

Frank

[Otto]

Dear Antonio,

Franklin editor is working fine.

I think it is a good program to substitute wDBU 16 bit.
1. most of the code is from the provided original Fivewin samples
2. the prg-file provided compiles with out any error.
3. functionality is very complete.

Can you please try to open a dbf-file and then select modify structure.
This gives an error:

oBrw:aRow[5] returns 0 and then the Program errors out.

Thanks in advance and best regards,
Otto

/*
XBROWSE( oBrw )

? EVAL( bNew )
? lNew
? oBrw:aRow[5]
*/
@ 115 , 185 BUTTON oBut[3] PROMPT "Delete Record";
OF oDlg SIZE 55,15 PIXEL;
WHEN EVAL(bNew) .AND. ( lNew .OR. ! oBrw:aRow[5] ); //arow[5] if .T. this field is used in a indexkey
ACTION (aDel(aStruct,oBrw:nArrayAt,.T.) , oBrw:nColSel := 2 ,;
oBrw:Refresh() , oBrw:SetFocus() , lChanged := .T. )

[HunterEC]

Franklin:

There's a little bug: when you don't have any DBF / file opened and open the File Menu and THEN move the mouse pointer over to Navigation errors out with the following error:

Code: Select all | Expand

   Error occurred at: 08/25/2016, 02:00:04
   Error description: Error BASE/1004  No exported method: LARRAY
   Args:
     [   1] = U   

Stack Calls
===========
   Called from:  => LARRAY( 0 )
   Called from: xbrdbu.prg => (b)MAINMENU( 255 )
   Called from: .\source\classes\MENU.PRG => TMENU:INITIATE( 431 )
   Called from: .\source\classes\WINDOW.PRG => TMDIFRAME:INITMENUPOPUP( 2584 )
   Called from:  => TMDIFRAME:HANDLEEVENT( 0 )
   Called from: .\source\classes\WINDOW.PRG => _FWH( 3182 )
   Called from:  => WINRUN( 0 )
   Called from: .\source\classes\WINDOW.PRG => TMDIFRAME:ACTIVATE( 995 )
   Called from: xbrdbu.prg => MAIN( 65 )
 

[Franklin Demont]

Hello ,

I was on holiday for some weeks.

During holidays i started to work on this project again , trying to incorporate fivedbu (working with ADO)

So i work on a module to create and modify ADO tables , using the command as :

'ALTER TABLE Customer ADD COLUMN NewField VARCHAR(20) NOT NULL DEFAULT "" ''

Creating this column a logical inputfield indicates NULL or NOT NULL , a Characterfield the Default value.

But modifying the structure we has to read this two data from the ADO Data set. How it can be done ?

Frank

[Otto]

Hello,
function copy to delimited errors out.
I think the parameter nMode == 1 should be logical parameter and TRUE.
Best regards,
Otto


ELSEIF nFormat == 3
// Delimited

? cFileName

//__dbDelim( nMode == 1 , cFileName , cDelim , aFld , ;
// bFor , bWhile , nNext , nRec , lRest)


__dbDelim( .T. , cFileName , cDelim , aFld , ;
bFor , bWhile , nNext , nRec , lRest)