Creating or modifying .dbfs

Moderator: Rathinagiri

User avatar
esgici
Posts: 4363
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 247 times
Been thanked: 91 times
Contact:

Re: Creating or modifying .dbfs

Post by esgici » Tue Mar 11, 2014 12:04 am

Javier Tovar wrote:Hi all,

I think this is what they are looking :D

I hope you do not bother Rathinagiri :D :D :D
DBU.zip
regards
Thanks !

Where found you it ?

Viva HMG :D
Viva INTERNATIONAL HMG :D

User avatar
esgici
Posts: 4363
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 247 times
Been thanked: 91 times
Contact:

Post by esgici » Tue Mar 11, 2014 12:25 am

esgici wrote:...
Where found you it ?
Yes, it is here :arrow:

Found by date ;)

Viva HMG, viva Rathi ! :D
Viva INTERNATIONAL HMG :D

Javier Tovar
Posts: 1274
Joined: Tue Sep 03, 2013 4:22 am
Location: Tecámac, México
Has thanked: 1 time
Been thanked: 2 times

Post by Javier Tovar » Tue Mar 11, 2014 12:30 am

OK Esguici :D

Regards

User avatar
esgici
Posts: 4363
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 247 times
Been thanked: 91 times
Contact:

Post by esgici » Sat Mar 15, 2014 12:25 pm

gfrae wrote:Is there an HMG module for creating, modifying etc. .dbfs or have they to be hard coded within .prgs? I have a number of former .dbfs from Clipper that I need to retain the data.
GFRae
Wonderful HMG IDE has also DB Management feature : http://vivaclipper.wordpress.com/2013/0 ... b-manager/" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false;

More, there are DB management tools in the internet; as an example : http://download.cnet.com/DBF-Commander/ ... 12356.html" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false;

Viva HMG :D
Viva INTERNATIONAL HMG :D

User avatar
andyglezl
Posts: 859
Joined: Fri Oct 26, 2012 7:58 pm
Location: Guadalajara Jalisco, MX
Has thanked: 7 times
Been thanked: 25 times
Contact:

Post by andyglezl » Sun Mar 08, 2015 4:10 am

Hola

FYI
Despues de dedicarle un buen tiempo a un problema que se me presentó con la busqueda en un indice,
me di cuenta que al crearlo con el DBA me dejaba de forma diferente el formato de fecha. Se podría corregir ?
----------------------------------------------------------------------------------------------------------------------------------
hello

FYI
After devoting some time to a problem that presented itself with the search in an index,
I realized that to create the DBA let me differently date format. You may correct?
Indices_DBA1.jpg
Indices_DBA1.jpg (91.58 KiB) Viewed 724 times
Indices_DBA2.jpg
Indices_DBA2.jpg (88.75 KiB) Viewed 724 times
Andrés González López
Desde Guadalajara, Jalisco. México.

User avatar
mustafa
Posts: 603
Joined: Fri Mar 20, 2009 11:38 am
Location: Alicante - Spain
Been thanked: 46 times

Post by mustafa » Sun Mar 08, 2015 11:52 am

Hello friends
I have taken leave of DBU unify the magnificent converter DBF to SQLite
also programmed by master Rathinagiri
viewtopic.php?f=5&t=2653&p=23787#p23787
that I have located in the Utilities menu as "Export DBF to SQLite"
hope you can be useful if you work with SQLite.
the original program "dbf2sqlite" I will find inside the folder of DBU
a greeting

Hola amigos
me he tomado la licencia de unificar en DBU el magnifico conversor de DBF a SQLite
tambien programado por el maestro Rathinagiri
que lo he situado en el menu de Utilities como "Export DBF to SQLite"
espero que les pueda ser útil si trabajan con SQLite.
el programa original "dbf2sqlite" lo encontrareis dentro de la carpeta de DBU
un saludo
Mustafa
Attachments
DBU.ZIP
(110.31 KiB) Downloaded 47 times

User avatar
esgici
Posts: 4363
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 247 times
Been thanked: 91 times
Contact:

Post by esgici » Sun Mar 08, 2015 1:13 pm

andyglezl wrote: After devoting some time to a problem that presented itself with the search in an index,
I realized that to create the DBA let me differently date format. You may correct?
Hola Andres

DTOC() is a Clipper (Harbour) function and explicitly defined / documented :
Clipper / Harbour Documentation wrote:This function converts any date expression (a field or variable) expressed as <dDateString> to a character expression in the default format “MM/DD/YY”. The date format expressed by this function is controled in part by the date format specified in the SET DATE command
So, your question isn't about HMG nor DBA.

By the way, it will be possible to give more clear answer by seeing your code and data.

Did you tried DTOS() instead of DTOC() ? This will be more adequate for indexing purposes.

Happy HMG'ing :D
Viva INTERNATIONAL HMG :D

User avatar
esgici
Posts: 4363
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 247 times
Been thanked: 91 times
Contact:

Post by esgici » Sun Mar 08, 2015 1:19 pm

mustafa wrote:Hello friends
I have taken leave of DBU unify the magnificent converter DBF to SQLite
also programmed by master Rathinagiri
viewtopic.php?f=5&t=2653&p=23787#p23787
that I have located in the Utilities menu as "Export DBF to SQLite"
hope you can be useful if you work with SQLite.
the original program "dbf2sqlite" I will find inside the folder of DBU
a greeting
Muchas gracias hermano :)

SQL support is highly useful for all DB Managers and your work and dedication is highly appreciated as always :arrow:

Happy HMG'ing :D
Viva INTERNATIONAL HMG :D

User avatar
andyglezl
Posts: 859
Joined: Fri Oct 26, 2012 7:58 pm
Location: Guadalajara Jalisco, MX
Has thanked: 7 times
Been thanked: 25 times
Contact:

Post by andyglezl » Sun Mar 08, 2015 4:29 pm

Hola esgici, gracias.

Dejame explicar un poco mas.
Yo cree una tabla.dbf con el DBA con la siguiente estructura:
en la cual uno de los campos es tipo fecha, tambien cree un indice con la combinacion CODIGO+DTOC( FECHA )
y el DBA me genera el indice con la llave "0000104.03.2015".
------------------------------------------------------------------------------------------------------------------------------------
Esgici Hi, thanks.

Let me explain a little more.
I create a tabla.dbf with DBA with the following structure:
in which one of the fields is date type, also create an index with CODIGO + DTOC( FECHA )
and generates DBA me with the key index "0000104.03.2015".

IDBA-1.jpg
IDBA-1.jpg (72.39 KiB) Viewed 683 times
Yo en mi programa, activo el indice y busco por CODIGO+DTOC( FECHA ) esperando encontrar "0000104/03/2015"
porque utilizo "SET DATE TO BRITISH" y no lo encuentro porque la llave creada por el DBA es "0000104.03.2015"

Quiza si el DBA en las preferencias tuviera la forma de indicarle el formato para tomar la fecha...

Me parece buena esta herramienta y tambien se que hay otras opciones pero si por alguna razon la herramienta
que usas no cumple con lo que necesitas, pues dejas de usarla.
-----------------------------------------------------------------------------------------------------------------------------------
I in my program, active index and search by CODIGO + DTOC( FECHA ) hoping to find "0000104/03/2015"
because I use "SET DATE TO BRITISH" and can not find it because the key created by the DBA is "0000104.03.2015"

Maybe if the DBA preferences had the way to tell the form to make the date ...

I think good this tool and I also know that there are other options but if for some reason the tool you use does not comply with what
need, then stop using it.
Andrés González López
Desde Guadalajara, Jalisco. México.

User avatar
esgici
Posts: 4363
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 247 times
Been thanked: 91 times
Contact:

Post by esgici » Sun Mar 08, 2015 4:48 pm

Hola Andres

You are right, DBA should support a set of SET commands; sadly, I haven't time ( and energy :( ) for work on these (and other) improvements for now :(

You can make indexing by your own program

.OR.

use DTOS() instead of DTOC().

Happy HMG'ing :D
Viva INTERNATIONAL HMG :D

Post Reply