Page 1 of 4

DBF editors

PostPosted: Sat Jul 23, 2016 6:02 pm
by 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

Re: DBF editors

PostPosted: Sat Jul 23, 2016 6:52 pm
by Antonio Linares
Otto,

Franklin Demont

viewtopic.php?p=142240#p142240

Re: DBF editors

PostPosted: Sat Jul 23, 2016 6:53 pm
by Antonio Linares

Re: DBF editors

PostPosted: Sat Jul 23, 2016 7:00 pm
by Otto
Dear Antonio,
thank you.
Do you know if there is newer version.
Best regards,
Otto

Re: DBF editors

PostPosted: Sat Jul 23, 2016 7:02 pm
by Antonio Linares
It seems as XBRDBUFD6 is the most recent one

but the rapidshare link is broken

Re: DBF editors

PostPosted: Sun Jul 24, 2016 10:55 am
by cnavarro
Antonio Linares wrote:It seems as XBRDBUFD6 is the most recent one

but the rapidshare link is broken


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

Re: DBF editors

PostPosted: Wed Aug 03, 2016 9:14 pm
by Otto
Hello,
does someone know if
Franklin Demont
still is working on DBF editor.
Thanks in advance
Otto

Re: DBF editors

PostPosted: Fri Aug 05, 2016 6:09 pm
by 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

Re: DBF editors

PostPosted: Sat Aug 06, 2016 7:38 am
by 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

Re: DBF editors

PostPosted: Sat Aug 06, 2016 8:15 am
by 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

Re: DBF editors

PostPosted: Sat Aug 06, 2016 10:16 am
by 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

Re: DBF editors

PostPosted: Wed Aug 24, 2016 9:39 am
by 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. )

Re: DBF editors

PostPosted: Thu Aug 25, 2016 6:03 am
by 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 view
  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 )
 

Re: DBF editors , new version

PostPosted: Sun Sep 11, 2016 3:03 pm
by 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

Re: DBF editors

PostPosted: Mon Sep 12, 2016 8:07 am
by 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)