My Visual Database — A need help....

Re: A need help....

null@example.com (Hedan) — Mon, 17 May 2021 09:43:58 +0000

Hi again,

I am ashamed.
I use the program myself in my own computer, so it´s difficult to run on another. Some of the code are hardcoded.God forbid
-
I KNOW, not so good ... Working to get rid of it.

I have spent hours of troubleshooting and one thing is clear... Something is wrong with "Order by" in the TableGrid settings. See "Sort.jpg" or something is wrong with the database file (index) itself. I THINK.

Hedan

Re: A need help....

null@example.com (jean.brezhonek) — Sat, 15 May 2021 16:41:30 +0000

Hello Hedan, Hello Derek

It is true that the year 2020 was a year at Covid.
Are you sure this damn virus hasn't infected your program?
More seriously, send us your project so that we can see the reasons for this curious display up close.

Re: A need help....

null@example.com (Hedan) — Sat, 15 May 2021 11:32:25 +0000

Hi,

Its very strange. What´s wrong with the year 2020??

If I set the sorting of the TableGrid to "No", everything looks good
If I set the sorting to "Main_Table.Adr" (Customer address), everything looks good
If I set the sorting to "Order by" and sorting field same as above it works for 2019, 2021, 2022 but not for 2020.

What i really want is a sort like Customer Adress and the Date as second sort field.

If I set the sorting to "Order by" and sorting formula to "Main_Table.Adr, Main_Table.Date" it works for 2019, 2021, 2022 but not for 2020.

Is there another way to specify a second sort field?

Regards

Hedan

Re: A need help....

null@example.com (derek) — Fri, 14 May 2021 09:22:56 +0000

Hello Hedan,
You need to upload your project (zip it without the .exe file) in order for someone to look at what the problem is.
Derek.

Re: A need help....

null@example.com (Hedan) — Fri, 14 May 2021 07:57:26 +0000

Hi,

It's more complicated than that. Yesterday i found another view in the database showing every year. Here every record has "0,00" in the tablegrid.

As I mentioned earlier, when i open the record in my form, everything is OK.

Summer greetings
Hedan

Re: A need help....

null@example.com (CDB) — Fri, 14 May 2021 06:42:43 +0000

Hmm, 2020 was a leap year, if you use 2024 do you get the same problem?

A need help....

null@example.com (Hedan) — Thu, 13 May 2021 07:31:51 +0000

Hi;

Something very strange have happend to my application.

I keep track of my income and expenses.

The tablegrid that i use to display my records contains a column displaying the amount of money. Suddenly that column displays "0,00" as the amount
when i click on the year 2020. The year 2019 and 2021 displays correct. See image,

Another tablegrid i have displayis all record in the database. In the column for the amount every record is "00,00"

If i open the record the amount is as i should.

What can i do??