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

338941 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

470185 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

316034 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

2891679 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

164945 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

278721 Views

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

Topics

Replies

Views

Last post

Mediator with MySql

Last post by sudip « Fri Jan 01, 2010 5:59 pm
Replies: 10
by sudip » Mon Dec 28, 2009 9:23 am
1

2
First post

Hi Friends,

Again an old idea is running in my mind ;)

Recently I started writing software with Sql Database (mainly with Sqlite). Struggling with...

Last post

Yes. I invoke the SQL query as and when we require the data.

Your method has one very useful feature, for multi-user environment, you can always...
10 Replies

18427 Views

Last post by sudip
Fri Jan 01, 2010 5:59 pm
DBFCDX

Last post by Rathinagiri « Sat Aug 21, 2010 3:03 pm
Replies: 2
by manoharmaski » Sat Aug 21, 2010 4:58 am

First post

hi all

Can any one pl explain
REQUEST DBFCDX, DBFFPT
RDDSETDEFAULT( DBFCDX )
as is in CONTACTOS folder in HMG SAMPLES

Thanks in advnace
MANOHAR

Last post

Thanks for your explanation Esgici.

2 Replies

8626 Views

Last post by Rathinagiri
Sat Aug 21, 2010 3:03 pm
ADORDD

Last post by luisfrancisco62 « Sat Sep 18, 2010 9:45 am

by luisfrancisco62 » Sat Sep 18, 2010 9:45 am

hola:

como hago para utilizar la libreria ADORDD

gracias

0 Replies

7107 Views

Last post by luisfrancisco62
Sat Sep 18, 2010 9:45 am
sql strings a better way?

Last post by Rathinagiri « Mon Oct 15, 2012 9:24 am
Replies: 1
by metron9 » Mon Oct 15, 2012 6:57 am

First post

Is making the string qstring in this function to call the sql function the only way to do this or is there a better way?

oh, and is there a timeout...

Last post

I think once connected, the connection will be retained for further queries. So, you need not connect and close every time you access.

I checked...

1 Replies

8005 Views

Last post by Rathinagiri
Mon Oct 15, 2012 9:24 am
MYSQL

Last post by mol « Thu Dec 13, 2012 10:55 am
Replies: 23
by t57042 » Tue Dec 11, 2012 12:50 pm
1

2

3
First post

I am trying out the samples about MySql.
They are working fine on the localhost.

When I try to connect from another machine (I can see the c:drive...

Last post

IMHO locking is carried on automatically without our interference.

If we use begin transaction and end transaction sequence, ACID requirements are...
23 Replies

29256 Views

Last post by mol
Thu Dec 13, 2012 10:55 am
OrdCreate

Last post by esgici « Sat Jan 05, 2013 10:07 pm
Replies: 3
by arroya2 » Sat Jan 05, 2013 11:53 am

First post

Hola amigos quiero sustituir la orden Index que tiene una clausula For por la orden OrdCreate y no consigo que haga lo que debe hacer y os pido una...

Last post

I'm glad by help you :)

Happy new year Rafael :)

Saludos

3 Replies

8974 Views

Last post by esgici
Sat Jan 05, 2013 10:07 pm
From DBF/CDX to SQLite

Last post by Hazael « Wed Mar 20, 2013 2:47 pm
Replies: 11
by Hazael » Thu Jun 24, 2010 1:09 pm
1

2
First post

Hello,

I am trying to move from DBF/CDX to SQLite because of the many features and advantages I learned from here:
I was studing previous...

Last post

I would do also but I came to the conclusion that unless I will really have to use it I will never do the sample.
I imagine you are the same way and...
11 Replies

20277 Views

Last post by Hazael
Wed Mar 20, 2013 2:47 pm
HMG + SQLite

Last post by joposadas « Thu Apr 11, 2013 2:50 am
Replies: 4
by joposadas » Wed Apr 10, 2013 9:18 pm

First post

Grupo,

Estoy tratando de hacer un sistema en HMG + SQLite, he visto el ejemplo que esta en HMG pero no tiene lo que necesito, es decir un resultset...

Last post

Daniel,

Efectrivamente ahi no hay ningún arreglo y de hecho yo ya he hecho aplicaciones con HMG + MS-SQL y con HMG + Access y todo ha funcionado...

4 Replies

9237 Views

Last post by joposadas
Thu Apr 11, 2013 2:50 am
Problemas al compilar SQLite

Last post by joposadas « Fri Apr 12, 2013 8:43 pm
Replies: 2
by joposadas » Thu Apr 11, 2013 3:10 am

First post

Grupos

Por alguna extraña razón me esta dando este error (anexo jpg del error) al tratar de leer el archivo sample.db3 , es decir compilo con BUILD...

Last post

Daniel,

Ya encontré el error y fue el siguiente:
Baje un administrador de SQLite ( y con éste abrí el archivo SAMPLE.db
y después de eso compile y...

2 Replies

8080 Views

Last post by joposadas
Fri Apr 12, 2013 8:43 pm
Preguntas de HMG + SQLite

Last post by Rathinagiri « Sat Apr 13, 2013 10:07 am
Replies: 3
by joposadas » Fri Apr 12, 2013 11:21 pm

First post

Grupo,

Estoy ya haciendo una pequeñas pruebas con SQlite, y a medida que las hago me surgen algunas preguntas:
He leído que hay versiones de SQLite...

Last post

You can see the documentation of HMGSQLite (or HMGSQL) in hmgsql/doc folder of HMG installation.

3 Replies

8805 Views

Last post by Rathinagiri
Sat Apr 13, 2013 10:07 am
OrdScope help

Last post by dhaine_adp « Sun May 05, 2013 1:24 pm
Replies: 4
by fouednoomen » Sat May 04, 2013 4:00 pm

First post

Dear All ,

How can I replace this function by OrdScope function

set filter to facture->cod_cli=client->cod_cli .and....

Last post

Hi Foued,

You can also used these commands:

USE EMPLOYEE ALIAS EMPLOYEE NEW VIA RDDSETDEFAULT()
INDEX ON ID Tag ID TO Employee
INDEX ON DOB Tag...

4 Replies

9366 Views

Last post by dhaine_adp
Sun May 05, 2013 1:24 pm
HMG + SQL

Last post by Rathinagiri « Thu May 16, 2013 3:04 pm
Replies: 7
by Rathinagiri » Thu May 16, 2013 5:54 am

First post

MySQL and SQLite are supported by Harbour long back and these libraries are officially included in HMG by Roberto Lopez from the version HMG 2.0....

Last post

Thank you Daniel. Now I have moved that topic into MySQL sub-forum.

7 Replies

12635 Views

Last post by Rathinagiri
Thu May 16, 2013 3:04 pm
write a file type jpeg image in a field of a mysql table

Last post by Rathinagiri « Mon May 27, 2013 9:34 am
Replies: 7
by jairpinho » Fri Jan 13, 2012 7:49 pm

First post

Hello Guys need to write a file type jpeg image in a field of a mysql table and then have to view this image, what query should I use to do what I...

Last post

I wanted to have a common function to convert a file into a SQL safe string and string into a file back.

Instead of re-inventing the wheel again, I...

7 Replies

12068 Views

Last post by Rathinagiri
Mon May 27, 2013 9:34 am
DSQLite

Last post by Amarante « Fri Aug 09, 2013 7:52 pm
Replies: 19
by Amarante » Tue Aug 06, 2013 5:23 am
1

2
First post

DSQLite

Português:
Dizem que na informática nada se cria, tudo se copia, sendo assim, inspirando-me em idéias de S. Rathinagiri, Dr Claudio Soto e...

Last post

Boas Novas, Testado com sucesso rodando sob Wine no Linux Mint com SQLite e MySQL. :P

---

Good News, Tested successfully running under Wine in...
19 Replies

21967 Views

Last post by Amarante
Fri Aug 09, 2013 7:52 pm
DB Validate

Last post by Pablo César « Sat Aug 10, 2013 3:16 pm
Replies: 4
by esgici » Sat Aug 10, 2013 11:39 am

First post

Hi all

Damaged data files are nightmare of programmers :(

This little work try testing a .dbf file for validation.

No perfect nor claim to find...

Last post

As you noticed, there are clever programs, works to repair tables. Yes, ia pity there is no solution does not pay ... :(

4 Replies

9674 Views

Last post by Pablo César
Sat Aug 10, 2013 3:16 pm
DMySQL

Last post by esgici « Tue Aug 13, 2013 4:09 pm
Replies: 6
by Amarante » Tue Aug 13, 2013 1:30 pm

First post

Continuando a ideia de DSQLite, onde podemos executar automaticamente a criação, navegação e formulários a partir do desenho do banco de dados, só...

Last post

Continuing the idea DSQLite, which can automatically perform the creation, navigation and forms from the design of the database, only now in MYSQL....

6 Replies

10219 Views

Last post by esgici
Tue Aug 13, 2013 4:09 pm
MySQL vs MariaDB

Last post by bpd2000 « Tue Sep 17, 2013 6:53 am
Replies: 5
by esgici » Mon Sep 16, 2013 2:12 pm

First post

mariadb_mysql.jpg

Goodgle said goodbye to which one ?

Last post

Thank you Rathi

5 Replies

10053 Views

Last post by bpd2000
Tue Sep 17, 2013 6:53 am
SQLite near error

Last post by IMATECH « Tue Oct 15, 2013 6:39 pm
Replies: 8
by dhaine_adp » Tue Oct 15, 2013 2:36 am

First post

Hello,

SQLite near error due to single quote ' that contains in text streams (strings). Example:
Danny's Files
Côte d'Ivoire
French words, etc.

I...

Last post

Hi Dani !

Nice job :)

and for good practices ( SQL standards )
Database object names ( Column, Table and DB ) have to be enclosed with Brackets...

8 Replies

12663 Views

Last post by IMATECH
Tue Oct 15, 2013 6:39 pm
Tamaño DBF-DBT / Size DBF-DBT

Last post by JALMAG « Sat Nov 09, 2013 11:42 am
Replies: 9
by JALMAG » Sat Nov 09, 2013 10:10 am

First post

Hola amigos, creo que no está documentado el tamaño de los archivos DBF-DBT-CDX (NTX) que puede gestionar Harbour, me refiero a si existe un tamaño a...

Last post

In HMG is the head master Roberto Lopez and masters Esgici & Rathinagiri, that is quite true
Best regards!

9 Replies

12865 Views

Last post by JALMAG
Sat Nov 09, 2013 11:42 am
CDX Format

Last post by dhaine_adp « Tue Nov 12, 2013 5:21 pm
Replies: 9
by GeoffBarnard » Mon Nov 11, 2013 3:58 pm

First post

Hello,

I'm new here. Just been checking out CDX indexes in samples, but format of CDX seems to be different to what I'm used to. The ones I've used,...

Last post

Hi Geoff,

For my main developments (still DOS based) I'm using Codebase (Sequiter) and C. Still maintaining one BIG system, plus various personal...

9 Replies

13456 Views

Last post by dhaine_adp
Tue Nov 12, 2013 5:21 pm
HELPME A ACCESAR A UNA DBF

Last post by LOUIS « Sat Mar 08, 2014 6:24 am
Replies: 7
by LOUIS » Tue Mar 04, 2014 7:05 am

First post

Hola a todos:
Como soy principiante, estoy tratando de hacer un mix entre consola y gui, para que la pantalla gráfica de entrada, le dé un poco de...

Last post

Mr. Esgici

Thank you very much, MsgInfo run OK ... ;) ... every day, step by step I learn some and I'm happy so much !!!

Javier Tovar

Soy...

7 Replies

10748 Views

Last post by LOUIS
Sat Mar 08, 2014 6:24 am
Creating or modifying .dbfs

Last post by esgici « Sat Mar 15, 2014 12:25 pm
Replies: 19
by gfrae » Thu Mar 06, 2014 9:38 pm
1

2
First post

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...

Last post

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...
19 Replies

20466 Views

Last post by esgici
Sat Mar 15, 2014 12:25 pm
How to compile this (sqlite sample)

Last post by Clip2Mania « Wed Sep 03, 2014 9:53 am
Replies: 8
by Clip2Mania » Mon Sep 01, 2014 3:03 pm

First post

Hi all,
I'm trying to compile the example attached (it's about sqlite) in HMG, but I can't get it working.
I keep on getting ' undefined reference...

Last post

Thanks Mustafa!

Problem is, I once downloaded this (nice) example, but wasn't aware of the updates :oops:
Thanks for helping me out! All works...

8 Replies

11853 Views

Last post by Clip2Mania
Wed Sep 03, 2014 9:53 am
SQL Help

Last post by andyglezl « Tue Nov 18, 2014 1:48 am
Replies: 9
by MGOLDFARB » Sun Sep 21, 2014 4:58 pm

First post

The following query seems to have the desired result when I execute it from MS SQL Server Management Studio:

insert into epictest.dbo.prtcrd...

Last post

Hola Franco
Ya anteriormente habia preguntado esto, no te sirvio lo de la vez anterior ?

Creo que estas mezclando naranjas con manzanas , estas...

9 Replies

12291 Views

Last post by andyglezl
Tue Nov 18, 2014 1:48 am
Getting Table Struct with TMySqlServer:TableStruct()

Last post by Rathinagiri « Sun Dec 14, 2014 4:08 am
Replies: 1
by hmgchang » Sun Dec 14, 2014 2:42 am

First post

Dear Masters,

REef. to this :

*******************************************************************************
* MySql Harbour Contribution Library...

Last post

You can pass on the 'Describe...' query to the sql server the same way you are sending any other 'select...' query.

1 Replies

7509 Views

Last post by Rathinagiri
Sun Dec 14, 2014 4:08 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