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 -- write th...

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 30 yea...

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 thinking, sin...

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 entry...

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 XXXX...

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 commercial...

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 doesn'...

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 ther...

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 ColumnNames call...

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 this ...

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 pro...

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 recor...

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 9999999999 ...

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) ve...