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
Direct and Indirect accessing Table
Moderator: Rathinagiri
Direct and Indirect accessing Table
With best regards,
Sudip
Sudip
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Direct and Indirect accessing Table
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.
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.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Direct and Indirect accessing Table
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?rathinagiri wrote: 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.
With best regards.
Sudip
With best regards,
Sudip
Sudip
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Direct and Indirect accessing Table
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.
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.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Direct and Indirect accessing Table
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
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
With best regards,
Sudip
Sudip