SQL Database + Array RDD

[sudip]

Hello All,

I found very good results using SQL and Array RDD.

Previously I was storing temporary data from sql tables into arrays - not the whole table, I was storing key fields into an array and ran query each time when array pointer is changed - when I was storing details directly into form's controls (as per Rathi's tips ). Today I changed this key field array with an array table, along with a few other fields (eg, document number, date etc) for automatically maintaining index. I found very good results

Array RDD also can be used with latest development of grid

I am thinking about the reason for the better result. Using Array RDD should have more overheads than using array only

Can anyone please share his/her experience regarding this

Thanks in advance.

With best regards.

Sudip

[esgici]

Dear Sudip

Please could you being more specific about "Array RDD" ?

Is this an official Harbour RDD or not ?

If so, where I can find information on it ?

TIA

Regards

--

Esgici

[sudip]

Yes Esgici,

It's official Harbour RDD Please check the example HMG\SAMPLES\RDD.SQL\array

With best regards.

Sudip

[fchirico]

Hello All,

I found very good results using SQL and Array RDD.

Previously I was storing temporary data from sql tables into arrays - not the whole table, I was storing key fields into an array and ran query each time when array pointer is changed - when I was storing details directly into form's controls (as per Rathi's tips ). Today I changed this key field array with an array table, along with a few other fields (eg, document number, date etc) for automatically maintaining index. I found very good results

Array RDD also can be used with latest development of grid

I am thinking about the reason for the better result. Using Array RDD should have more overheads than using array only

Can anyone please share his/her experience regarding this

Thanks in advance.

With best regards.

Sudip

Español:
En estos días estuve trabajando en desarrollar una aplicación que me permita conectarme a una bas MS-SQL y grabarlos en una base DBF. Lo hé logrado y he logrado crear la DBF con los tipos de datos que corresponden ( no lo he logrado aún para el tipo de datos BIGINT ). La salida de la importación lo hago en un control GRID

En cuanto mi trabajo me permita lo publicare en el foro.


English:
In those days I was working on developing an application that allows me to connect to a MS-SQL bas and record in a database DBF. I succeeded and I managed to create a DBF with corresponding data types (I have not yet attained to the data type BIGINT). The output of the import control what I do in GRID

As my job allows me I'll publish in the forum.

[fchirico]

Sudip, perdón, yo no lo hice con RDD-Array, lo hice con TODBC(), una clase que tiene su tiempo en Harbour, pero permite conocer el tipo de dato que viene de MS-SQL.

[fchirico]

Sudip, perdón, yo no lo hice con RDD-Array, lo hice con TODBC(), una clase que tiene su tiempo en Harbour, pero permite conocer el tipo de dato que viene de MS-SQL.

In English:

Sudip, sorry, I did not do with RDD-Array, it was with TODBC (), a class that has its time in Harbor, but allowed to know the type of data that comes from MS-SQL.

[sudip]

English:
Hi Fchirico,
I don't use MS Sql. I mainly use SQLite, and a few months back MySql. I use C2SQL() function written by Rahithagiri
With best regards.

Sudip

Spanish:
Hola Fchirico,
Yo no uso de MS SQL. Uso principalmente de SQLite, y hace unos meses, MySql. Yo uso C2SQL () función escrita por Rahithagiri
Con mis mejores deseos.

Sudip

[Vanguarda]

Hi my friends,

Topic very interesting Sudip, thanks for begin this.

I´ll add in my favorites.

With best regards,

[Rathinagiri]

English:
Hi Fchirico,
I don't use MS Sql. I mainly use SQLite, and a few months back MySql. I use C2SQL() function written by Rahithagiri
With best regards.

Sudip

Spanish:
Hola Fchirico,
Yo no uso de MS SQL. Uso principalmente de SQLite, y hace unos meses, MySql. Yo uso C2SQL () función escrita por Rahithagiri
Con mis mejores deseos.

Sudip

Sorry Sudip. I had not created c2sql() function. It is from Harbour MySQL library sample, I think.

[sudip]

Thank you Rathi ... I didn't know it.
With best regards.
Sudip