Number of real rows in a dataGrid

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

Post Reply
cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Number of real rows in a dataGrid

Post by cbarbal » Thu Sep 06, 2018 12:39 pm

I'm doing some tests with a FileMaker database. I use ODBC and I put the result in a dataGrid.

When I have all the FileMaker records in the dataGrid and I put:
the dgNumberOfLines of group "dgClients" into tLineas, the result is 1.767
If I do a SELECT that returns only 9 records, it continues saying that they are 1,767. With dgNumberOfRecords the same thing also happens.

What should I use to know the exact number of records that appear in the dataGrid?

Thanks for advance

Carles

Klaus
Posts: 13806
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Number of real rows in a dataGrid

Post by Klaus » Thu Sep 06, 2018 12:57 pm

Hi Carles,

hm, just tested here and it works as expected with different numbers of lines!?
Simulated 2001 rows and then 3 rows with LC 9 on macOS 10.13.6.

To be sure, you DO put the new data into the datagrid? 8)


Best

Klaus

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Number of real rows in a dataGrid

Post by cbarbal » Thu Sep 06, 2018 3:05 pm

Hi Klaus,

You have only 50% of reason. Today I had hung the LiveCode a couple of times, I had version 9.0.0 and 9.0.1 RC2, I have uninstalled the two versions I turned off the computer and I returned to do a clean installation from scratch with the 9.0.0. Works correctly.

I have macOS 10.12.6, I can not change the version for compatibility with previous versions of FileMaker. There are customers who can not afford to change the version every year, and I need backward compatibility.

Thanks for the reply,

Carles

Klaus
Posts: 13806
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Number of real rows in a dataGrid

Post by Klaus » Thu Sep 06, 2018 3:20 pm

Hi Carles,

ah, OK, get it! But don't worry, LC 9 supports these Mac versions:
10.9.x (Mavericks) on Intel
10.10.x (Yosemite) on Intel
10.11.x (El Capitan) on Intel
10.12.x (Sierra) on Intel
10.13.x (High Sierra) on Intel
and surely will until version 10.

Sometimes it helps, when you delete the LC preferences.
To find out where this is on your Mac, put this into the messagebox of LC:
put the filename of stack "revpreferences"

Then quit LC and delete that file and start again, helps with most "hiccups" of LC. :D

Best

Klaus

cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Re: Number of real rows in a dataGrid

Post by cbarbal » Thu Sep 06, 2018 3:34 pm

Hi Klaus,

Thanks for the tip.

FileMaker dixit: only 3 operating systems per version, the previous one, the current one and the one that will be released. If you do not like it, change to something else.

The current version of FileMaker, 17, is only compatible with
macOS High Sierra 10.13
macOS Sierra 10.12
It will also be with macOS Mojave 10.14, when they have the corresponding patch.

Regards,

Carles

Klaus
Posts: 13806
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Number of real rows in a dataGrid

Post by Klaus » Thu Sep 06, 2018 3:36 pm

cbarbal wrote:
Thu Sep 06, 2018 3:34 pm
FileMaker dixit: only 3 operating systems per version, the previous one, the current one and the one that will be released. If you do not like it, change to something else.
Ouch! :(

Post Reply

Return to “Getting Started with LiveCode - Complete Beginners”