Search found 132 matches

by montymay
Fri Mar 31, 2017 11:34 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Keeping links in sqlite
Replies: 4
Views: 851

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: 456

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: 795

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: 795

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: 613

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: 381

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: 803

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: 803

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: 1087

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: 1087

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: 1441

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...
by montymay
Wed Aug 31, 2016 4:53 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Converting field data to a database
Replies: 11
Views: 1441

Re: Converting field data to a database

Thank you Mikey and Klaus, Reading your responses, I'm beginning to see how to correctly create a CSV file, but also beginning to see how "reiterating through the cards" is better. Taking as my template the script from the LC lesson on sqlite, I wrote the following script. on mouseup set the default...
by montymay
Mon Aug 29, 2016 2:53 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Converting field data to a database
Replies: 11
Views: 1441

Converting field data to a database

I have a stack of thousands of cards containing twelve fields. Too many cards! I now want to convert the data into a database by (1) creating a delimited text file and then (2) loading it into a SQLite database, but some LC fields are multi-lined, e.g., field "cites". (See script below.) Correct me ...
by montymay
Mon Aug 22, 2016 2:51 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: revBrowser Question
Replies: 6
Views: 862

Re: revBrowser Question

Hi Klaus:

I knew there was a way. Thanks for much for the answer.

Monty
by montymay
Sun Aug 21, 2016 10:33 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: revBrowser Question
Replies: 6
Views: 862

revBrowser Question

Hello forum readers: I have a card on which I want to display different PDFs. On the card I have different buttons that upon clicking will open a particular PDF. I could put the following script on each button (note: the line numbers are not part of the script): 1 global gBrowserID 2 on mouseup 3 re...

Go to advanced search