LiveCode Forums.

It's set to Table

Anyone know why this is happening? There certainly seems to be enough space to display the entire string the Db sends to it. The link is to a zip file with a screencap in it.

https://www.dropbox.com/scl/fi/bgzgh98v60p2j08gij7zn/truncatedString.zip?rlkey=ulyh7tpjslsasjzlsutm5c2ek&st=dnlnsmql&dl=1

It's now happening with Windows 10. The Windows log registers every event as follows:

Faulting application name: TekProtect.exe, version: 6.4.2.0, time stamp: 0x6102893c
Faulting module name: Print.PrintSupport.Source.dll, version: 10.0.19041.1806, time stamp: 0x02b082be
Exception code: 0xc0000005 ...

The only thing I can think of is the subkeys are not numbered, they are named.

Bingo. A name may include alphabetic characters or numerals or punctuation or any combination of those. But it only has one name.


I just looked back through the other programs I've produced with Livecode and I ...

bogs wrote: Wed Jan 01, 2020 7:56 pm I know you had a lot of responses and sent a lot of replies, but did you see this response from Axwald, which might be the one that explains your dilemma?

I did, thanks. But it's going to take me a little while to comprehend it all.

...I got the routine cmdCursor2Array from these pages but here it is too:
command cmdCursor2Array pCursor, @pOutArrayA
## Get the names of all the columns in the database cursor
put revDatabaseColumnNames(pCursor) into theFields
if theFields begins with "revdberr," then
put item 2 to -1 of ...

Someone suggested it would be good to know how the array is created.


on mouseUp mouseButt
if mouseButt = 1 then
if gvConnectID is not a number or gvConnectLite is not a number then
cmdConnect
end if

// Go get the last run time
put the prFile of this stack into tvFile
put the effective ...

Maybe then you can see if there is anything different to the array then you expected that could explain the outcome of your script? This has helped me working with array's.
Regards,

Paul


The only thing I can think of is the subkeys are not numbered, they are named. But I assumed indexing them ...

Well, we are at least getting somewhere. When you do step through, does the very first line:
put myArray[x][1] into tvMake
put anything into tvMake?

...

Craig


No. However, after reading everyone's comments I think we may be circling the problem. Could the "indexing" problem be due to having ...

I just tried bogs' statement below and it returns "true."

Not to take undue credit, the statement actually was modified directly from the dictionary example :wink:

Fortunately, it appears you are at least starting with a real array. Did you also check it before you start running that loop ...

Would this work?



repeat for each key tKey in myArray
put myArray[tKey] into tLineData
put tLineData[1] into tvMake
put tLineData[2] into tvModel
put tLineData[3] into tvCompName
put tLineData[4] into tvProdNum
put tLineData[5] into tvSerial
put tLineData[6] into tvOSName
put ...

The symptoms described for both cases would be met if the variable myArray is not actually an array.

How is that variable populated?


It's populated through a query to the database. When I step through each line myArray shows up in the variables section as an array. In other words it has 71 ...

I agree, both seem fine for an array. And yet one will not run at all and the other assigns no data to the variables. Do you have any thoughts on that?

It seems Livecode is really buggy. I had a problem a while back that every "answer" statement would cause the stack and the IDE crash and no one ...

Hi all...

As usual, I'm hoping this is some quirk of Livecode that has a simple fix. I'm writing a routine that updates our company database with data from the SQLite db file associated with our remote support software. The database calls are working fine and the result (using test parameters) is ...

Once again, Klaus to the rescue. Although my data source was much different from this example I was able to get it to work by making logical assumptions to restructure the code. Thanks so much!