26

(3 replies, posted in Reports)

Hi sparrow,
.
It is too bad we have that trollish behavior here...
.
Thank you again for this example.  It is a very useful demo.  I was unaware of this until now and I needed it a long time ago.
.
joshuA

Вы сделали еще один замечательный сайт. Хороший выбор для темы тоже. Все фотографии отображаются на моей стороне. Спасибо, что поделились.

Я пока не могу подписаться. Я надеюсь, что это скоро изменится.


You have made another great site.  Nice choice for the theme too.  All of the pictures are showing up on my side.  Thank you for sharing it.

I'm still unable to subscribe for now.  I hope this changes soon.

-joshuA

What's the status?
Where's the new site?


Каков статус?
Где новый сайт?


-joshuA

29

(2 replies, posted in General)

Hi unforgettable,

I reference https://www.sqlitetutorial.net/ a lot for SQL lite stuff.

As far as scripts, put your queries inside the SQLExecute() function.

And for calculated fields, surround the query in (parentheses).

-joshuA

30

(8 replies, posted in General)

Hi folks,

Thank you for these experiments.  Sometimes I have preference issues with the Datepicker too.  This gives me some more options big_smile

-joshuA

k245 wrote:

The problem is not Google, but RosKomNadzor.

My apologies for blaming Google, as I made an assumption there... neutral


Yes, it is easy to get overwhelmed when looking for themes.  There are thousands to choose from lol  I recommend to start with what type of elements are important for you (or that you prefer).  Colors and all that can be easily changed with CSS if necessary when the theme doesn't allow.

The search filter may help you decide and select which elements are available such as Features and Layouts.  Maybe that will help you get an idea for what you are looking for.


I will mention the Bootstrap Basic4 theme.  It is free and based on a popular web framework that I like.


vovka3003 wrote:

используйте классический редактор tinymce
use the classic tinymce editor

Можете ли вы объяснить это подробнее... это дополнение для WordPress? Из того, что мне удалось найти, есть аддоны, но похоже, что они также отделены от WordPress. Это так для вас?

Can you explain this further... is it an addon for WordPress?  From what I was able to find there are addons, but it looks like it is separate from WordPress as well.  Is that the case for you?


Thanks guys!
Спасибо, парни!

32

(3 replies, posted in General)

Hi FMR,

I can confirm it.  Same for me.  Not just your machine.  I'm using a 64-bit machine with Windows 11.

-Josh

33

(7 replies, posted in General)

Hi lemodizon,

There is a basic example on this page.  And if you click the button beside the Expression label, it will help you build other similar expressions using your table fields, etc.  Aside from that you will have to experiment and ask more specific questions as you go along.  Good luck!

-joshuA

34

(8 replies, posted in General)

Thanks for mentioning that.  I will keep it off unless I experience issues otherwise.  It seems like it is most useful when using reports.

-joshuA

Да, я поддерживаю концепцию WordPress. Это с открытым исходным кодом и бесплатно, если у вас есть доступный хостинг. И похоже, что у вас это уже есть.

Помимо переноса вашего контента на него, он будет выглядеть и работать так же, как интерфейс блоггера, к которому вы привыкли.

У вас такой замечательный контент, что я надеюсь, вы не позволите Google остановить вас.


Yeah, I second the notion for WordPress.  It is opensource and free as long as you have hosting available.  And it sounds like you have that already.

Aside from getting your content moved over to it, it will look and feel much like the blogger interface that you're used to.

You have such great content that I hope you don't allow Google to stop you.

-joshuA

36

(2 replies, posted in Reports)

Wow, there is a lot going on there...  I'll have to study what's going on to make that work.  lol
Thank you for creating that and sharing it too!
-joshua

37

(2 replies, posted in Reports)

Hi all,

This is kinda outside the intended purpose for MVD, but it works really well for ad hoc form overlays.  I could not find a way to call FastReport without creating a database tho (which would make this even better)...

Does anyone have any ideas for doing this?

-joshuA

derek,

Very well.  That's it.  Thank you for the example!

The image that I was using seemed to be scaling in some way.  That's the reason for my curiosity of those dimensions.  lol

-joshuA

Привет к245,
Могу я узнать размеры (ширину и высоту) логотипа в вашем примере.
Спасибо!


Hi k245,
May I know the dimensions (width and height) for the logo in your example.
Thanks!

-joshuA

40

(12 replies, posted in General)

Destiny,

Two of the fish didn't have date / time, but this loads the last one.

You will need to format the string based on the sqlite strftime.  I added a link in the comments.

-joshuA

41

(12 replies, posted in General)

Destiny,

Somehow, you will need to reference the same date field on Form1 as on Form2.  Without seeing your situation, it's hard to make suggestions.  I have provided another example that might be helpful.


Glad it was helpful for you lemodizon.

-joshuA

42

(12 replies, posted in General)

Hi Destiny,


If I understand your question, you could use the form's OnShow event with something like:

Form1.Edit1.Text := FormatDateTime('yyyy-mm-dd',Form1.DateTimePicker1.DateTime);
Form1.Edit2.Text := FormatDateTime('hh:mm:ss',Form1.DateTimePicker2.DateTime);

-joshuA

43

(8 replies, posted in General)

Hi again lemodizon, and all


I appreciate your mentioning that book (in your Table Grid thread) because it prompted me to go through it (which I have yet to do).  Which leads me to the reason I'm even commenting again on this one.


For me, Page 89 clearly described the purpose for setting a table as a dictionary.  The example there is better than any other explanation that I have yet seen on the forums even (view the attachment).  Aside from what is going on "under the hood", because there has been much detail given for that in other threads.

-joshuA

44

(10 replies, posted in General)

Nicely done lemodizon.

Thanks for sharing too.
-joshuA

45

(10 replies, posted in General)

Hi lemodizon,


This is not a complete solution, but hopefully it provides some ideas to work with.


Most tablegrids are attached to a table in the database, so in my example, I added a TMP table to hold the changes "to be committed".  This gives you a table full of items that need to be updated, so you'll have to fill-in the SQL to make that happen.


While it is possible to add items manually to a tablegrid, I believe that defeats their purpose.  Someone correct me if I am wrong about that.

-joshuA

46

(5 replies, posted in Reports)

Well- for anyone else interested in the answer to my last question, I was able to find a detailed explanation for it.

And it is, as I was expecting- a form of escaping characters.  But I wanted to share what I found...


While this is noted in the FastReport PDF manual on page 87, it doesn't go into any details about why... which is what I was curious about.

The online manual has a page about modifying variable values.  And I'll paste the content below:


It should be noted, that when accessing a report variable its value is calculated if it is of string type. That means the variable whose value is 'Table1.“Field1”' will return a value of a DB field and not the 'Table1."Field1"' string. You should be careful when assigning a string-type value to a report variable. For example, this code will raise the exception “unknown variable 'test'” when running a report:

frxReport1.Variables['My Variable'] := 'test';

because FastReport is trying to calculate a value for variable 'test'. The right way to pass a string value is:

frxReport1.Variables['My Variable'] := '''' + 'test' + '''';

In this case the variable value, string 'test', will be shown without errors. But keep in mind that:

  • a string should not contain single quotes : all single quotes must be doubled;

  • a string should not contain #13 or #10 symbols.

In some cases it is easier to pass variables using a script.


-joshuA

47

(5 replies, posted in Reports)

So there are four ' single quote characters.
The two outer quotes are obvious- they enclose the two other quote characters.
Theses inner two are ones in question.  Is the first inner one like an escape character for the second inner one?
Thanks

48

(8 replies, posted in General)

hi lemondizon,


jean has detailed it nicely here, but I found this thread with a simpler explanation for ya too.

-joshuA

49

(5 replies, posted in Reports)

hi sparrow, hi derek,


Thank you both as always!  And I learned from both of your examples...


sparrow:
Thanks for the link and the example.  I usually do search the forums first, but I wasn't sure what to search for in this case.  For some reason "report variables" didn't come to mind. hmm  My apologies for that tho.


derek:
Nice, I always like your approach of doing things from MVD.  I have been trying to design my projects this way too.

In my working project, I have too many things controlling the tablegrid output, and I couldn't get the simple Report to work correctly.  I'm going see if I can figure out why that is, so I may have further questions about that big_smile


another question:
When declaring that report variable, what are all of those single quotes doing?

frmMain.frxReport.Variables['FromMemo'] := ''''+s+'''';

Why are they necessary, aside from breaking the script lol

-joshuA

50

(5 replies, posted in Reports)

Hi folks,

I was wondering if it would be possible to send a field (in this case a memo) containing a one-time use per report- like for a custom header for instance.

I'm not sure how to send the field over to the report since it's not part of a table in the database.

Any help or ideas would be appreciated.
-joshuA