Number of real rows in a dataGrid
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Number of real rows in a dataGrid
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
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
Re: Number of real rows in a dataGrid
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?
Best
Klaus
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?
Best
Klaus
Re: Number of real rows in a dataGrid
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
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
Re: Number of real rows in a dataGrid
Hi Carles,
ah, OK, get it! But don't worry, LC 9 supports these Mac versions:
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.
Best
Klaus
ah, OK, get it! But don't worry, LC 9 supports these Mac versions:
and surely will until version 10.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
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.
Best
Klaus
Re: Number of real rows in a dataGrid
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
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