Hello experts
Is there a way to delete a row of a grid with a text file as data source (and affect the file also)?
If i delete the contents of a row, the file still has the line with the delimiters only, so the grid shows empty row.
My point is to delete the entire line as the SQL DELETE command should do in the case of a database.
Example:
lets say i have the following file linked to the grid:
a;1;11
b;2;22
c;3;33
by deleting the contents of line 2 i will have:
a;1;11
;;
c;3;33
but i would prefer to have:
a;1;11
c;3;33
There is of course a way to do this by vbscripting but If i use scripting for deleting the line then i am forced to exit the screen that holds the grid because the file is in use by the grid, so that is not exactly a good idea.