Direct and Indirect accessing Table

[sudip]

Hello Friends,

We can access tables for data manipulation both Directly and Indirectly (using memory variables or temporary/memory tables).

I prefer indirect method because
1) Less data corruption.
2) Using SQL tables.

Can you please send your views regarding this

Thanks in advance

With best regards.

Sudip

[Rathinagiri]

In this regard, these are my views/experiences.

Previously, when I use dbf tables alone, I directly handled data without much of temporary variables.

As time passed by, I started using SQL record sets and I stored the record sets in temporary variables.

Now, I use SQL record sets but reduced the usage of temporary variables/arrays. ie., I store the values directly in HMG controls like textbox, grid etc., This had improved the coding and variable handling a LOT.

[sudip]

Now, I use SQL record sets but reduced the usage of temporary variables/arrays. ie., I store the values directly in HMG controls like textbox, grid etc., This had improved the coding and variable handling a LOT.

Great If your code directly stores table data in form controls (without storing the recordset into an array)? If yes (now you know what I am going to ask ) can you please send a small sample?

With best regards.

Sudip

[Rathinagiri]

Hi Sudip,

In this place, I am to say negative. Since harbour and SQL API's deals record sets in arrays, when getting the record sets ("select" queries), I am bound to use array variables.

[sudip]

Thanks a lot Friend
So, we may say that using SQL we use indirect accessing table using temporary array (unlike BROWSE)
If SQLRDD is capable to manipulate data in tables using ordinary xBase commands, we can use direct access with SQL tables also. Am I correct?
With best regards.
Sudip