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
26 2022-08-01 23:54:17
Re: Report WO Overlay (3 replies, posted in Reports)
27 2022-06-24 00:17:08
Re: Курсы обучения и статьи о разработке приложений (239 replies, posted in Russian)
Вы сделали еще один замечательный сайт. Хороший выбор для темы тоже. Все фотографии отображаются на моей стороне. Спасибо, что поделились.
Я пока не могу подписаться. Я надеюсь, что это скоро изменится.
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
28 2022-06-23 02:33:16
Re: Курсы обучения и статьи о разработке приложений (239 replies, posted in Russian)
What's the status?
Where's the new site?
Каков статус?
Где новый сайт?
-joshuA
29 2022-06-16 16:59:51
Re: Differences (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 2022-06-08 11:34:16
Re: Date field to read 00/00/0000 (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
-joshuA
31 2022-06-03 18:17:43
Re: Курсы обучения и статьи о разработке приложений (239 replies, posted in Russian)
The problem is not Google, but RosKomNadzor.
My apologies for blaming Google, as I made an assumption there...
Yes, it is easy to get overwhelmed when looking for themes. There are thousands to choose from 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.
используйте классический редактор 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 2022-06-02 20:51:14
Re: ToWords and Number 12 Misspelling (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 2022-06-02 11:52:08
Re: How to use the calculated field (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 2022-06-02 11:47:57
Re: Table Dictionary (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
35 2022-06-02 11:45:02
Re: Курсы обучения и статьи о разработке приложений (239 replies, posted in Russian)
Да, я поддерживаю концепцию 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 2022-06-01 17:54:19
Re: [SOLVED] ad hoc Forms (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.
Thank you for creating that and sharing it too!
-joshua
37 2022-06-01 02:42:21
Topic: [SOLVED] ad hoc Forms (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
38 2022-05-28 18:22:05
Re: Как скрыть окно подключения к Mysql (7 replies, posted in Russian)
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.
-joshuA
39 2022-05-28 16:13:07
Re: Как скрыть окно подключения к Mysql (7 replies, posted in Russian)
Привет к245,
Могу я узнать размеры (ширину и высоту) логотипа в вашем примере.
Спасибо!
Hi k245,
May I know the dimensions (width and height) for the logo in your example.
Thanks!
-joshuA
40 2022-05-27 14:22:55
Re: TextBox display (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 2022-05-27 13:17:31
Re: TextBox display (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 2022-05-27 09:10:08
Re: TextBox display (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 2022-05-27 08:57:50
Re: Table Dictionary (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 2022-05-24 11:29:36
Re: Table Grid (10 replies, posted in General)
Nicely done lemodizon.
Thanks for sharing too.
-joshuA
45 2022-05-23 00:20:18
Re: Table Grid (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 2022-05-21 13:13:43
Re: [SOLVED] User Input On A Report (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 2022-05-20 12:07:44
Re: [SOLVED] User Input On A Report (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 2022-05-20 02:16:06
Re: Table Dictionary (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 2022-05-20 02:05:35
Re: [SOLVED] User Input On A Report (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. 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
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
-joshuA
50 2022-05-19 19:04:45
Topic: [SOLVED] User Input On A Report (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