Hi,
I know using SQL is great but it requires the additional SQL components and .NET Framework 2 to work. On some devices, this requires installation of .net framework to be installed which may be cumbersome for end-customers. I also observed that it affects the initial loading time as well.
Using CSV is the current workaround for me. But this requires using the TABLES control to load the whole chunk of data to it.. and in a way, utilising memory space.
Is there a way where I can simply retrieve a specific line in a text file (consisting of standard CSV or whatever data strings) without using Tables? I wrote a simple ReadLine sometime back.. but this requires reading all the lines from first line to the 'n' line. This is fast if the number of lines are small. But if it grows bigger, it becomes slower.
Does anyone has any workaround for this? if not, perhaps can Erel add that into say, v6.06 as it'd be much much faster..
Rgds
WZSun
I know using SQL is great but it requires the additional SQL components and .NET Framework 2 to work. On some devices, this requires installation of .net framework to be installed which may be cumbersome for end-customers. I also observed that it affects the initial loading time as well.
Using CSV is the current workaround for me. But this requires using the TABLES control to load the whole chunk of data to it.. and in a way, utilising memory space.
Is there a way where I can simply retrieve a specific line in a text file (consisting of standard CSV or whatever data strings) without using Tables? I wrote a simple ReadLine sometime back.. but this requires reading all the lines from first line to the 'n' line. This is fast if the number of lines are small. But if it grows bigger, it becomes slower.
Does anyone has any workaround for this? if not, perhaps can Erel add that into say, v6.06 as it'd be much much faster..
Rgds
WZSun
Last edited: