Search found 114 matches

by cbarbal
Thu Dec 20, 2018 7:06 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: "Select distinct" in a LiveCode variable or field
Replies: 9
Views: 5208

Re: "Select distinct" in a LiveCode variable or field

Hi,

I suppose a possible solution is to have an empty Excel file and fill it out.

Carles
by cbarbal
Thu Dec 20, 2018 6:37 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: "Select distinct" in a LiveCode variable or field
Replies: 9
Views: 5208

Re: "Select distinct" in a LiveCode variable or field

Hi, I understand that "write to file" is for an existing file, the difference is that FileMaker creates it for you. There are clients that need an Excel file because their administrative manager asks for it, and they do not have the application. I do not have it installed either and if I need to ope...
by cbarbal
Thu Dec 20, 2018 5:46 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: "Select distinct" in a LiveCode variable or field
Replies: 9
Views: 5208

Re: "Select distinct" in a LiveCode variable or field

Hi Craig, In principle I will do with SQL, since the data is in a database, is related to the subject of the post https://forums.livecode.com/viewtopic.php?f=7&t=31904 . Now I am in the process of seeing how I can reproduce what I do in FileMaker in LiveCode and every day I learn new things. In an a...
by cbarbal
Wed Dec 19, 2018 7:13 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: "Select distinct" in a LiveCode variable or field
Replies: 9
Views: 5208

Re: "Select distinct" in a LiveCode variable or field

Hi Craig, This is part of the text. In the original there are 142 lines, there may be more or less. Aldea Mar 7875 2016-12-14 F-1 ... Aldea Mar 7876 2016-12-14 F-1 ... Llenguadoc 62 7790 2016-10-12 ... Llenguadoc 62 7812 2016-11-01 ... Llenguadoc 62 Llenguadoc 62 Llenguadoc 62 Olimpiades 37 7759 201...
by cbarbal
Wed Dec 19, 2018 4:23 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: "Select distinct" in a LiveCode variable or field
Replies: 9
Views: 5208

"Select distinct" in a LiveCode variable or field

Hi all, There is a query in SQL that returns me the expenses of a series of properties and places it in a variable, it can be a field if it goes better. Is it possible to obtain a single name of each property and the number of records of each one, of this variable or field? With the name it would be...
by cbarbal
Tue Dec 18, 2018 3:33 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to create a new label field programmatically?
Replies: 2
Views: 2043

How to create a new label field programmatically?

Hi all, I found a response from dunbarx on a mailing list, but it gives me an error: Set up the templateField as a label field Error description: set: no property specified I have also looked at the Scripting Conference "Controls" of Klaus Major and I do not have it completely clear if it is necessa...
by cbarbal
Tue Dec 18, 2018 11:50 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Report in LiveCode
Replies: 14
Views: 7991

Re: Report in LiveCode

Hi Richard, I guess jacque refers to this post https://forums.livecode.com/viewtopic.php?f=7&t=31898&start=15 In principle, the beginning of the post was another topic and it gets a bit confusing if you look for print report. Now I am in the testing phase with hide and show part of the groups. There...
by cbarbal
Sun Dec 16, 2018 8:02 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Standalone with SQLite and Mac
Replies: 23
Views: 12534

Re: Standalone with SQLite and Mac

Hi jacque,

It's what I had thought, create a substack with the measurements of an A4 portrait. Create a series of groups that were visible or not depending on whether it is a record, is the total of the property or the grand total.

Thanks for the advice

Carles
by cbarbal
Sun Dec 16, 2018 12:36 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Report in LiveCode
Replies: 14
Views: 7991

Re: Report in LiveCode

Hi,

I have noticed that the initial template that I have put is not what corresponds to the description of the first post. I use both of them but this one is a bit more complex
FileMaker Pro Advanced001.jpg
Sorry,

Carles
by cbarbal
Sun Dec 16, 2018 12:16 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Report in LiveCode
Replies: 14
Views: 7991

Re: Report in LiveCode

Hi Craig, The types that can be exported and imported are: csv, dbf, fmp12, htm (export only), mer, xlsx, tab or txt, xml. But as Klaus says this is not the issue. What I try to find out if I can leave FileMaker and replace it with LiveCode, which I start to doubt. But I need everything I do with Fi...
by cbarbal
Sun Dec 16, 2018 10:56 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Standalone with SQLite and Mac
Replies: 23
Views: 12534

Re: Standalone with SQLite and Mac

Hi bogs, First of all thank you for your help. For my Quartam it is something that does not have any kind of support. If you try to buy this message comes out. Unable to complete your request... The Quartam product line is not available through the eSellerate system. For more information, please con...
by cbarbal
Sat Dec 15, 2018 7:05 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Standalone with SQLite and Mac
Replies: 23
Views: 12534

Re: Standalone with SQLite and Mac

Hi bogs, They are not tabs are labels. When you create a layout (card) in FM it creates by default a header, a body and a footer, you can add other parts. They are part of the same layout. The Quartam Reports page is not updated since 2013. It talks about the next 2.0 version, 5 years have passed an...
by cbarbal
Sat Dec 15, 2018 11:25 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Standalone with SQLite and Mac
Replies: 23
Views: 12534

Re: Standalone with SQLite and Mac

Hi bogs,

Klaus refers to this report :D

https://forums.livecode.com/viewtopic.php?f=7&t=31904

Regards,

Carles
by cbarbal
Sat Dec 15, 2018 11:22 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Report in LiveCode
Replies: 14
Views: 7991

Report in LiveCode

Hi all, How can I play this FileMaker report in Livecode? The report looks for the expenses of a property between two dates and puts the detail of each expense. When the expenses of a property end. puts the totals of the expenses and taxes and starts a new sheet with the following property. A proper...
by cbarbal
Fri Dec 14, 2018 4:46 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Standalone with SQLite and Mac
Replies: 23
Views: 12534

[SOLVED]Re: Standalone with SQLite and Mac

As Herr Doktor Klaus told me :D There is something incompatible with the creation of the SQLite standalode, not with ODBC, on my Mac. I started from an external disk, with the same operating system but different programs, and it worked. Now I have the problem with the reports that have to be passed ...

Go to advanced search