Search found 136 matches

by montymay
Fri Jun 16, 2017 10:44 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Datagrid border color
Replies: 3
Views: 1373

Re: Datagrid border color

I too noticed today, more than five years after the first post, that there does not seem to be a way to change the border color of the datagrid from its default color, black. I take the silence to be a negative answer to the question. :D

Monty
by montymay
Wed Jun 14, 2017 11:15 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Combing first name and surname into a datagrid table
Replies: 2
Views: 703

Re: Combing first name and surname into a datagrid table

Thanks, Klaus, your amended line works perfectly.

Monty
by montymay
Tue Jun 13, 2017 12:45 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Combing first name and surname into a datagrid table
Replies: 2
Views: 703

Combing first name and surname into a datagrid table

I have a sqlite database in which surnames and first names are in different columns. I want to populate a datagrid table such that the first name and surname are put into one datagrid column in that order, separated by a space. Is that possible? Can anyone suggest the script or a tip on how to do it...
by montymay
Fri Mar 31, 2017 12:48 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Keeping links in sqlite
Replies: 4
Views: 939

Re: Keeping links in sqlite

Hi Klaus, Thank you for your response. Although my primary interest is hyperlinks in the text, as a test, I put word "abc" into field "xyz", styled it bold, using the menu command, and then used your command, i.e., "put the htmltext of fld "xyz" into a variable, and then used the query "UPDATE myTab...
by montymay
Fri Mar 31, 2017 11:34 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Keeping links in sqlite
Replies: 4
Views: 939

Keeping links in sqlite

I am developing an app that is basically the front end to a sqlite database. At times I would like to put links to web content into the text of LC fields such that when I update the corresponding database field, the links are preserved, i.e., when the script retrieves the text from the database the ...
by montymay
Mon Feb 27, 2017 11:47 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Sorting a Datagrid Column
Replies: 2
Views: 482

Sorting a Datagrid Column

I am developing the the front end to a database that accesses more than 3000 documents that begin in 1950 and continue to the present year, named in the following format: item 1: the last two digits of the year of publication and the order of publication in that year as a four-digit number, e.g., 14...
by montymay
Mon Feb 27, 2017 11:18 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Script of Datagrid Group triggered by Click in Scrollbar
Replies: 3
Views: 846

Re: Script of Datagrid Group triggered by Click in Scrollbar

Hello Gerrie, Your script did not work for me, but it gave me an idea that seems to work so far, but maybe it will have unforeseen consequences. Here's my modification: put the clickLoc into tLoc --put (the dgProp["show hscrollbar"] of me) and within(scrollbar 1 of me, tLoc) into hScrollClicked --pu...
by montymay
Sat Feb 25, 2017 9:31 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Script of Datagrid Group triggered by Click in Scrollbar
Replies: 3
Views: 846

Script of Datagrid Group triggered by Click in Scrollbar

Hello I'm getting to know datagrid tables for the first time and have encountered a problem: when I click on the vertical or horizontal scrollbar to go up or down, or left or right, the script for the datagrid group is triggered. Clicking a line of my table successfully takes me to the intended card...
by montymay
Sat Feb 11, 2017 8:03 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Populating Datagrid (Form) with Results of Search of SQLite
Replies: 2
Views: 681

Populating Datagrid (Form) with Results of Search of SQLite

I have a SQLite database of records. Each record has 13 fields. I want to put the results of a search query into the following datagrid form, which has just six text fields and one image: Capture.JPG My search code is thus: global gDatabaseID on mouseup put fld "query" into theSearchString get revDa...
by montymay
Wed Jan 25, 2017 12:10 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Code for Updating SQLite database table
Replies: 1
Views: 404

Code for Updating SQLite database table

Hello fellow LiveCoders I have a SQLite database table. I have written code that successfully updates existing records but I can't find code that will create new records. I searched this forum and found the following code--abridged for display here--that I amended to reflect my application, but it d...
by montymay
Sat Sep 24, 2016 11:46 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Code for Updating database upon Closing Card
Replies: 6
Views: 884

Re: Code for Updating database upon Closing Card

Thanks Jean-Marc and Mikey. Going with Jean-Marc's suggestion, I wrote the following script: global gDatabaseID on closecard put fld "pcfnum" into tPCFnum --the identifier of the correct row repeat with i=1 to 13 --the number of fields the user may have modified put the short name of fld i into tNam...
by montymay
Sat Sep 24, 2016 10:03 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Code for Updating database upon Closing Card
Replies: 6
Views: 884

Code for Updating database upon Closing Card

Hello: Searched the forum and couldn't find this problem. Users in my application will be entering text into empty fields or modifying text in other fields in one card. Before entry or modification, the text of fields containing the text will have been downloaded from a sqlite database when the card...
by montymay
Thu Sep 08, 2016 7:37 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Transitioning between substacks
Replies: 4
Views: 1194

Re: Transitioning between substacks

Hello Craig and Jean-Marc, Thank you for your responses. Following your suggestion, I resized my mainstack from fullscreen (1920 x 980) to 1920 x 60 pixels so that each of my substacks appears below the mainstack. My mainstack script successfully opens one of the substacks. But the problem now is th...
by montymay
Wed Sep 07, 2016 8:15 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Transitioning between substacks
Replies: 4
Views: 1194

Transitioning between substacks

My application consists of one mainstack that is without decorations and is full screen, at the top of which are two rows of buttons with which to navigate to a substack corresponding to each button. Each substack, also without decorations, is the same size as the mainstack except for the area occup...
by montymay
Sun Sep 04, 2016 8:13 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Converting field data to a database
Replies: 11
Views: 1569

Re: Converting field data to a database

Hello Mikey, Thank you for your last post in response to my request for help. From it and other readings I realize I am in way over my head and definitely must study SQL in depth, but for now it would be much appreciated if you could give one last explanation of your script, in particular, the meani...

Go to advanced search