DataBases

Moderator: Rathinagiri

New Topic

59 topics

Announcements

Replies

Views

Last post

HMG 3.6 (64 bit version)

Last post by tonton2 « Wed Jan 17, 2024 2:42 pm
Posted in HMG 64 Bits
Replies: 40
by Rathinagiri » Wed May 10, 2023 12:06 pm » in HMG 64 Bits
1

2

3

4

5
First post

Dear HMG friends,

Thanks to Girigory a default 64 bit only version of HMG is created and I am sharing the setup file for your testing and comments....

Last post

hello everyone, is there any update to HMG 3.6 (64 bit)
40 Replies

350227 Views

Last post by tonton2
Wed Jan 17, 2024 2:42 pm
Good bye to our friend - Esgici - RIP

Last post by AlxSts « Fri Aug 05, 2022 1:45 pm
Posted in General Discussions
Replies: 43
by Rathinagiri » Wed Apr 28, 2021 9:40 am » in General Discussions
1

2

3

4

5
First post

Dear HMGians,

Hicabi-Karacorlu-Biyografi.jpg

With profound sadness, I am sharing this heartful news to you all.

One of our senior members Mr....

Last post

Hello.

it's never too late to thank Esgici for all his contribution to xBase world. Rest in peace.
43 Replies

512463 Views

Last post by AlxSts
Fri Aug 05, 2022 1:45 pm
HMG Virtual Summit 2020

Last post by vientopamperosur « Mon Feb 22, 2021 11:02 am
Posted in General Discussions
Replies: 30
by Rathinagiri » Sun Jul 05, 2020 8:33 am » in General Discussions
1

2

3

4
First post

Dear HMG Friends,

I feel very much nostalgic when I think of the day of starting the forum 12 years back.

Roberto had started the forum with his...

Last post

Es una excelente idea, me anoto
30 Replies

349545 Views

Last post by vientopamperosur
Mon Feb 22, 2021 11:02 am
HMG 3.4.4

Last post by mol « Tue Dec 19, 2023 1:17 pm
Posted in HMG Unicode version
Replies: 209
by Rathinagiri » Wed Mar 29, 2017 3:43 pm » in HMG Unicode version
1

…

17

18

19

20

21
First post

Whenever releasing a new version of HMG, it gives us new hope and paves way for the future with strong and stable code. This version is also not an...

Last post

Thank you Edward!
209 Replies

2951384 Views

Last post by mol
Tue Dec 19, 2023 1:17 pm
How to register in HMG Forum

Last post by Rathinagiri « Tue Apr 14, 2015 4:39 pm
Posted in Forum Help

by Rathinagiri » Tue Apr 14, 2015 4:39 pm » in Forum Help

As of now, to avoid spammers, user registration is disabled.

If you want to register in HMG Forum, kindly mail to srathinagiri@gmail.com /...

0 Replies

176409 Views

Last post by Rathinagiri
Tue Apr 14, 2015 4:39 pm
HMGSCRIPT 0.37

Last post by serge_girard « Sun Jun 09, 2013 6:14 pm
Posted in HMG News and Updates
Replies: 15
by Roberto Lopez » Sat Aug 04, 2012 12:47 pm » in HMG News and Updates
1

2
First post

Hi All,

I've completed the new dbf files support.

As I've already pointed, since the dbf files support was dropped from PHP standard distributions,...

Last post

Roberto,

I have been working/testing a few days with the HMG-Script 0.37 and I have a three remarks/questions:

1) Isn't it better to store...
15 Replies

299420 Views

Last post by serge_girard
Sun Jun 09, 2013 6:14 pm

Topics

Replies

Views

Last post

SQLCipher 3.2

Last post by Guest « Fri Feb 13, 2015 5:27 pm
Replies: 6
by Guest » Fri Feb 13, 2015 5:27 pm

SQLCipher , having the latest version of 3.2 is successfully ported to Harbour and I am attaching herewith the library for you.

SQLCipher is the...

6 Replies

4033 Views

Last post by Guest
Fri Feb 13, 2015 5:27 pm
Please help with syntax

Last post by Guest « Sun Mar 08, 2015 1:07 pm
Replies: 26
by Guest » Sun Mar 08, 2015 1:07 pm
1

2

3
Hi everybody.
I am working my way through some old DOS programs and converting them to run in a windows 32/64 bit enviroment.
One program that I'm...
26 Replies

13893 Views

Last post by Guest
Sun Mar 08, 2015 1:07 pm
DSQL - Dynamic SQL

Last post by Guest « Sun Apr 05, 2015 6:05 am
Replies: 21
by Amarante » Sun Apr 05, 2015 6:05 am
1

2

3
Finally today I had the day off and could produce a small application to demonstrate the use of my DSQL routines.
The application is called MySongs....
21 Replies

13864 Views

Last post by Guest
Sun Apr 05, 2015 6:05 am
Re: Help to improve clause in SQL Select

Last post by Pablo César « Fri Apr 17, 2015 8:46 pm
Replies: 28
by Amarante » Thu Apr 09, 2015 2:18 pm
1

2

3
First post

Friends of the forum,
I have a select that is very slow and precise improve it so I ask your help.

Consider two tables:

CREATE TABLE Propriedade...

Last post

Nice
28 Replies

16590 Views

Last post by Pablo César
Fri Apr 17, 2015 8:46 pm
DBFCDX or SQLite

Last post by Hazael « Thu Jul 23, 2015 1:35 pm
Replies: 17
by Tristan » Wed Oct 14, 2009 2:11 am
1

2
First post

Hi All,

Which better HMG+DBFCDX or HMG+SQLite ? :)

Regards,
Tristan

Last post

One thing I like about SQLite is the possibility to use it with SQLCipher to have the database secure.
More about it here:

And here is a good topic...
17 Replies

11196 Views

Last post by Hazael
Thu Jul 23, 2015 1:35 pm
SQLite

Last post by Hazael « Thu Jul 23, 2015 1:36 pm
Replies: 7
by jairpinho » Mon Aug 29, 2011 10:46 pm

First post

Hola a todos, tengo problemas con SQLite para crear una lista de nombres de tablas de una base de datos utilizando inhibidores de la HMG 3.0.38...

Last post

Thanks for sharing your code

7 Replies

5843 Views

Last post by Hazael
Thu Jul 23, 2015 1:36 pm
firebird + HMG

Last post by Hazael « Thu Jul 23, 2015 8:26 pm
Replies: 22
by joposadas » Fri Jan 17, 2014 6:25 pm
1

2

3
First post

Grupo,

Actualmente estoy desarrollando una aplicación con SQLite sin embargo ésta tiene la limitante de que solo un usuario puede estar actualizando...

Last post

I really like Firebird but it is true that MariaDB is more flexible since you can use as remote database in the cloud, as local database, network,...
22 Replies

16316 Views

Last post by Hazael
Thu Jul 23, 2015 8:26 pm
SQLCipher ported to Harbour (Windows)

Last post by Hazael « Thu Jul 23, 2015 8:27 pm
Replies: 101
by Rathinagiri » Thu Feb 09, 2012 7:35 am
1

…

7

8

9

10

11
First post

I am happy that I could port SQLCipher to Harbour (Windows) successfully:

Here are the steps I have followed to port it to Harbour: (My System is...

Last post

OK, it would be nice to know what is the problem (alhtough Windows XP is being left behind more and more...)
101 Replies

57810 Views

Last post by Hazael
Thu Jul 23, 2015 8:27 pm
Error with Sqlite with old project

Last post by Rathinagiri « Wed Jul 29, 2015 4:03 am
Replies: 1
by sudip » Tue Jul 28, 2015 12:35 pm

First post

Hello,

I am trying to compile Sqlite project with HMG after a long time. I am getting some errors. Can anyone please help me?
With best regards....

Last post

This just means that libsqlite3.a is not included in the compiling/linking process.

Please add this line to your project .hbc file.

libs=sqlite3

1 Replies

3706 Views

Last post by Rathinagiri
Wed Jul 29, 2015 4:03 am
SQLCipher 3.3.1

Last post by serge_girard « Mon Aug 03, 2015 4:18 pm
Replies: 4
by Rathinagiri » Sun Aug 02, 2015 4:18 pm

First post

Dear Friends,

Happy friendship day!

Today I am happy that I could port, compile and generate the latest version of SQLCipher library (3.3.1 -...

Last post

Thanks Rathi !

Serge

4 Replies

3987 Views

Last post by serge_girard
Mon Aug 03, 2015 4:18 pm
A very basic mysql example

Last post by dragancesu « Fri Feb 26, 2016 5:00 pm
Replies: 9
by martingz » Thu Mar 21, 2013 12:19 am

First post

Juan Carlos
Leopoldo
Andres
Envio una aplicacion que podran ver como conectar al servidor de mysql, y su uso de inserts y update muy basicos pero...

Last post

When install webserver like wamp,xampp then often can access from localhost but not other ip address

9 Replies

6208 Views

Last post by dragancesu
Fri Feb 26, 2016 5:00 pm
HMG ODBC Best Practices

Last post by melliott42 « Fri Mar 11, 2016 5:01 pm
Replies: 4
by melliott42 » Fri Mar 11, 2016 2:48 pm

First post

Hello,

I realize HMG is mainly an amazing GUI. Though there are many ways to do things I may not be using the best suited for HMG now in 2016....

Last post

Thats great feedback Rathinagiri! Thanks.

As I migrate apps to 64-bit HMG and start to create new ones it is a good time to reevaluate.

4 Replies

3165 Views

Last post by melliott42
Fri Mar 11, 2016 5:01 pm
SQLCipher 3.11.0

Last post by Rathinagiri « Tue Apr 26, 2016 7:19 am
Replies: 7
by Rathinagiri » Sun Apr 24, 2016 5:10 pm

First post

Dear friends,

Now I have ported the latest SQLCipher for SQLite version 3.11.0 to Harbour.

You can download the library from below....

Last post

All the sqlite functions apply to this library also.

Only a wrapper of encryption is available.

7 Replies

5154 Views

Last post by Rathinagiri
Tue Apr 26, 2016 7:19 am
Is it possible improve this statament?

Last post by paulomhouse « Tue Jul 05, 2016 5:37 pm
Replies: 10
by paulomhouse » Tue Jul 05, 2016 2:03 pm
1

2
First post

Hi Everyone.

I have a statement select above what is working. But very slowly.

Database: Postgresql

Can you help to improve?

I think the problem...

Last post

I need to show all items with value greater than 0 even if not in the second table.
T of Subquery is a rest to user insert in a19item.

Have I made...
10 Replies

6018 Views

Last post by paulomhouse
Tue Jul 05, 2016 5:37 pm
SQLCipher with Borland

Last post by baxajaun « Fri Aug 26, 2016 3:18 pm
Replies: 6
by baxajaun » Fri Aug 26, 2016 9:35 am

First post

Good morning !

Has anyone built SQLCipher with Borland 7 ? Do you want share with us how do it ?

Thanks in advance !

Best regards,

Last post

Hi Rathinagiri,

thanks again.

Regards

6 Replies

3926 Views

Last post by baxajaun
Fri Aug 26, 2016 3:18 pm
How to put Chinese characters into dbf file

Last post by Tiger « Mon Oct 24, 2016 11:41 am
Replies: 7
by Tiger » Thu Oct 20, 2016 11:32 am

First post

Hi I have a stupid question if it is possible to import the excel file that contant the Chinese characters to dbf file. When I need to deal with the...

Last post

Hi Rathi,

I think the CSV file is OK, because if I use the import method from EXCEL then the Chinese characters can be displayed correct. But if I...

7 Replies

5039 Views

Last post by Tiger
Mon Oct 24, 2016 11:41 am
I need an example of using Virtual Grid with DBF's

Last post by EduardoLuis « Fri Mar 03, 2017 2:32 pm
Replies: 6
by mjaviergutierrez » Thu Mar 02, 2017 5:17 pm

First post

I need an example of using Virtual Grid with DBF's, please , thanks

Last post

Javier: PD. Hace muchos años atras tuve a un coterraneo tuyo como cliente (soy abogado), un extraordinario músico de la trova rosarina Lalo de Los...

6 Replies

3580 Views

Last post by EduardoLuis
Fri Mar 03, 2017 2:32 pm
Postgres or MariaDb

Last post by serge_girard « Mon Mar 13, 2017 11:52 am
Replies: 8
by karweru » Sun Mar 12, 2017 5:56 pm

First post

Dear Friends,

I have been using Sqlite for many years now. However, I have an urgent need to move to PostGres or MariaDb and is desperate for a...

Last post

Maybe Gilbert...

See this post:

8 Replies

5384 Views

Last post by serge_girard
Mon Mar 13, 2017 11:52 am
MariaDb ADO Connection Errors

Last post by dragancesu « Sun Apr 16, 2017 3:56 pm
Replies: 4
by karweru » Sat Apr 15, 2017 3:49 pm

First post

Happy Easter everyone,

I have recently been able to connect to a mariaDb through an ADODB connection and is able to programmatically create tables,...

Last post

I think that there is nothing simpler than natural links, one dll that's all

ADO is designed to work with MS databases, ODBC database to give...

4 Replies

3445 Views

Last post by dragancesu
Sun Apr 16, 2017 3:56 pm
dbfcdx and oplocks

Last post by mol « Wed Apr 19, 2017 8:36 am
Replies: 8
by mol » Sat Apr 15, 2017 5:22 pm

First post

Hi!
From some time my application (still based on dbfcdx) works slowly in the network.
I know it's caused by SMB2 protocol.
It's possible to turn off...

Last post

Dane na mailu :)
Hi!
Data on your mail.

8 Replies

5304 Views

Last post by mol
Wed Apr 19, 2017 8:36 am
Indexing a DBF

Last post by asharpham « Tue Mar 27, 2018 1:58 am
Replies: 19
by asharpham » Sun Mar 25, 2018 12:30 pm
1

2
First post

I'm experienced with Clipper but am an absolute novice with HMG/Harbour. My attempts to open a DBF file with an Index (NTX) utterly fails.

The line...

Last post

Thanks again guys. Wow! Dragan, you've gone all out. I'll scan your code carefully and see what I can learn.

Much obliged,
Alan
19 Replies

8593 Views

Last post by asharpham
Tue Mar 27, 2018 1:58 am
Clipper conversion

Last post by serge_girard « Tue Apr 03, 2018 2:43 pm
Replies: 13
by Templar » Mon Apr 02, 2018 11:23 am
1

2
First post

Hello everyone. This is my first posting so forgive me if I'm getting it wrong. I am using HMG to update an ancient Clipper 5.2 application. Most of...

Last post

Templar, Is your first name perhaps Simon?

Serge
13 Replies

6278 Views

Last post by serge_girard
Tue Apr 03, 2018 2:43 pm
Directory function

Last post by Templar « Sun Apr 08, 2018 8:29 pm
Replies: 4
by Templar » Fri Apr 06, 2018 10:46 am

First post

The Clipper DIRECTORY() command used to display the date a folder (in those far-off days still called a Directory...) was created. Now it returns the...

Last post

Hello Drigory
Thanks for that. Looks useful. I have not yet got into the other library functions, so maybe I will have to start on that. It looks...

4 Replies

2594 Views

Last post by Templar
Sun Apr 08, 2018 8:29 pm
dates

Last post by Templar « Mon Apr 16, 2018 1:52 pm
Replies: 5
by Templar » Fri Apr 13, 2018 6:49 pm

First post

Consider this:
DD:=CTOD( 12/04/2018 )
DC:=DTOC(DD)
@1,1 SAY LEN(DC)

This returns a value of 8, because it reduces the year to two figures. If I want...

Last post

preparing for any Y3K problems.... !

A mi me gustaría poder vivir esos años para ver si se resolvió el problema... :o :lol:...

5 Replies

4473 Views

Last post by Templar
Mon Apr 16, 2018 1:52 pm
"Workarea not in use" Error

Last post by ROBROS « Sun Oct 21, 2018 7:58 am
Replies: 16
by asharpham » Thu Mar 29, 2018 8:01 am
1

2
First post

I have these 2 lines of code:
USE Library NEW
dbGoBottom()
which compiles fine but gives me this runtime error:
Workarea not in use: DBGOBOTTOM ....

Last post

Hi Nikos,
That is what I found:

So, you are right
Best Regards
Robert
16 Replies

7740 Views

Last post by ROBROS
Sun Oct 21, 2018 7:58 am

New Topic

59 topics

Return to Board Index

Forum permissions

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum