topic-32746

Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: DBF editors
Posted: Wed Aug 03, 2016 09:14 PM

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

Franklin Demont

Posts: 166

Joined: Wed Aug 29, 2012 08:25 AM

Re: DBF editors
Posted: Fri Aug 05, 2016 06:09 PM

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

test

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: DBF editors
Posted: Sat Aug 06, 2016 07:38 AM

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

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

Re: DBF editors
Posted: Sat Aug 06, 2016 08:15 AM

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

Franklin Demont

Posts: 166

Joined: Wed Aug 29, 2012 08:25 AM

Re: DBF editors
Posted: Sat Aug 06, 2016 10:16 AM

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

test

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: DBF editors
Posted: Wed Aug 24, 2016 09:39 AM

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

Posts: 723

Joined: Tue Sep 04, 2007 08:45 AM

Re: DBF editors
Posted: Thu Aug 25, 2016 06:03 AM

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 (fw): Select all Collapse

   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

Posts: 166

Joined: Wed Aug 29, 2012 08:25 AM

Re: DBF editors , new version
Posted: Sun Sep 11, 2016 03:03 PM

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

test

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: DBF editors
Posted: Mon Sep 12, 2016 08:07 AM

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)

FiveTech Support Forums