LiveCode Forums.

Finally managed to stubborn my way into a solution with this. Seems to be working just fine, but if anyone has a better suggestion, I am all ears! Sample code is reproduced below.
Thanks -Paul

on IM08Connected pSocket
-- save the socket ID in a global variable
put pSocket into IM08SockeT ...

You don't seem overly boneheaded.

The fun is just starting. Do write back often. I bet you will be continually amazed at how neat, how rich, this thing is.

Do you know what Hypercard was? In other words, what decade of life are you in?

Craig Newman

Oh, been around the business for a bit over ...

All your points are easily handled with scripts in the dataGrid.


(grin) I expect it is easy, once one figures it out. The Datagrid seems very complex, though it is trivial to use it for say, retrieving and displaying data from a SQL database.

There is one thing you must change in your ...

I would use a datagrid. The cells certainly DO respond in the normal way to both tab and shift-tab. You can easily script the transfer to the next row when you are at the far right side.

I would NOT use hundreds of fields. This can be managed as well, but is inelegant.

Hi Craig - it is a data ...

I have a screen (card) that needs to be able to accept from zero to 200 separate fields the user may enter. (These are alternate references they may wish to link to the main record, and consist of 11 character fields.)

Something along these lines:

XXXXXXXXXXX XXXXXXXXXXX XXXXXXXXXXX XXXXXXXXXXX ...

I haven't used libJSON myself, but it has a pretty good reputation. What issues did you experience with it?

Probably mostly user error. It seemed to miss some data items last night, but checking it tonight, they are all there, so maybe it was just me being too tired.
I really wish it was ...

It isn't that hard to write a parser and encoder for JSON, but it sure would be nice to just be able to drop a few bucks and buy one.

I looked at the Libjson-1.xx download, but it is a few years old, has no real documentation, and uh - didn't work as expected. It is a couple of years old, and ...

Thanks Klaus, but I'm thinking it might be easier to make my app web-based and run it on the same server as the sqlite database.

It's a bit difficult to backtrack from where I am now.

--paul

Hi Paul -

You can run SQLite databases in a client/server configuration, there are several products out ...

Hi Paul,

can't you just use "revDatabaseColumnNames()"?
That will return a COMMA delimited list of all the columnnames for a give database table.

Check the dictionary for more info.


Best

Klaus

Told you I was a dB2 guy. Automatically sought a SQL based solution. :)

I missed that the ...

Well, finally figured out how to set the column headings. Whew!

But it still seems like there is a bit of a dearth of meta information about the tables in SQLite. How are you guys handling that?
Keeping a master table of tables with column label names, maxsizes, etc? Or am I just over thinking ...

Pretty basic question I am afraid, so apologies in advance if this is something simple and I just cannot find it in the documentation. Also, I'm a dB2 kind of guy, and I may be making assumptions that don't apply about SQLite and LiveCode. :)

I can create and manage a SQLite database now with no ...

The "If the Shiftkey is down" is really a cool testing idea, thanks!

I should have looked up wait in the Dictionary, "wait 0 ticks with messages" is a lot faster than "wait 1 tick with messages" :)

If I have not said how much I appreciate the pointers, well - I do! Thanks!
-Paul

No, I just wasn't clear because I was in a rush and wanted to be sure I got a thank you in there in a timely manner. I had written it up earlier, but lost that post.

Putting a wait in there with each iteration dramatically slowed down execution, so I added an if statement to only wait each 500 ...

I can do that -


ABCDEF XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


Number Pref Address Line 1 Address Line 2 Address Line 3 Address Line 4 Name

9999999999 999 XX XXXXXXXX XXXXX XX XXXX XX 99999-9999 XXXXXX,XXXXXXX ...

I wonder how you guys would do this? :)

A modest sized dataset, a text file of about 30,000 lines, formatted with fixed fields (no tabs).

Want to read it into a datagrid to enable fast finds, sorting by different columns, etc.

I can read the file into a variable (even pulling it from a webserver ...