Thanks Bob, will come in handy when needed.
I use PHP as middleware, as others have to use it too and need access to
the DB. If i would use RevDB then they would not be granted access. And
the webspace provider is not allowing LC server on it's shared hosting.
So the data is coming in as deli
If you think that is awesome, have a look at sqlYoga, or any of the database
APIs by other devs in this group.
Bob S
> On Dec 11, 2018, at 05:01 , Andrew Bell via use-livecode
> wrote:
>
>> From: Bob Sneidar
>> To: How to use LiveCode
>> Subject: R
From: Bob Sneidar
To: How to use LiveCode
Subject: Re: remove empty lines in DG
Fortunately for you, I have a cursorToArray function already written:-)
YOU wrote that? Thank you thank you thank you! When I discovered that
script it completely changed my workflow by allowing me the
You would be better off gettign the data as a cursor then looping through the
cursor data to produce a dg compatible array, then setting the dgData. dgText
is ok if all you have to work with is delimited text data, but if you can get
an array, then you should use dgData.
Fortunately for you, I
I could delete the empty lines by dispatching delete to the DG.
But this was not a solution to the cause.
Now it seems it happens when fetching from the DB. Now as everything is
encrypted, i can't see which line in the DB is empty.
So have to check if i can find the exact lines causing it, wh
Thanks Bob
i will check out your suggestion.
Jerry
Op 8-12-2018 om 01:18 schreef Bob Sneidar via use-livecode:
This can happen if there are keys in the data that are not numbered. Try getting the
dgData of the datagrid and examining the array in the debugger. That should show you
your keys.
This can happen if there are keys in the data that are not numbered. Try
getting the dgData of the datagrid and examining the array in the debugger.
That should show you your keys. You can possibly do a repeat with i = 1 to and populate another array with the records
from the original array, th
Hi,
i don't know why but with one stack i have when the DG is populated,
empty lines at the top which i can't seem to remove.
Data is being fetched from a DB, then base64decoded, then decrypted. In
neither state i could find an empty line.
Now it seems only with this stack on windows.
The
