There is a typo on your line a ")" instead of a "}"
c.model like '%{edit9)%' or
551 2015-11-09 08:51:22
Re: List filtered rows in Grid (13 replies, posted in General)
552 2015-11-07 17:58:20
Re: Beta version 2.2 (28 replies, posted in General)
Could you please explain a little bit more about the improvements. I see no difference in using this version compared to 2.1. 
553 2015-11-07 15:18:32
Re: List filtered rows in Grid (13 replies, posted in General)
I guess it is a bug due to too many "OR" conditions. I tried the same query with different values and it always works in SQLStudio.
Did you try left join instead of searching in all tables at once?
554 2015-11-06 13:43:51
Re: List filtered rows in Grid (13 replies, posted in General)
The SQL query executes properly in SQLStudio. For some reason, the very same query does not work in the project.
556 2015-11-06 09:18:41
Re: Change Textbox background when Read Only (7 replies, posted in Script)
Thank you Dmitry,
it is all about syntax. I thought we could use AND clause between if and else but it is not the case.
It works.
557 2015-11-05 10:40:07
Re: Change Textbox background when Read Only (7 replies, posted in Script)
It does not work, it is expecting a ";" after the color code forever which already exists
558 2015-11-05 10:30:55
Re: How to extend time for hint text (12 replies, posted in Script)
Thanks for the example Dmitry, I had to stare at it several times to figure out that I was not talking about the same kind of Hint. I was talking about the hint into textboxes or comboboxes.
559 2015-11-04 15:28:39
Re: Change Textbox background when Read Only (7 replies, posted in Script)
Is there a way to possibly set 2 status on a condition without multiplying the number of script lines?
For instance I would like to set a field to read only if content <>0 AND being grayed out.
I managed to set the textbox to read only, how to set the background to grey (color := $003333FF) on same code line ?
Current code is:
if Admin.Edit_typ.Text<>'' then Admin.Edit_typ.ReadOnly := True else Admin.Edit_typ.ReadOnly := False;I tried to add
AND Admin.Edit_typ.color := $003333FF before
else without success. 
560 2015-11-04 15:21:07
Re: How to extend time for hint text (12 replies, posted in Script)
Both actually, using version 2.1
561 2015-11-04 13:19:29
Re: How to extend time for hint text (12 replies, posted in Script)
Actually, I did not understand how to implement it. I copied the code from here and I see no difference whichever method I choose...
562 2015-11-02 15:52:44
Re: CB and Pictures (5 replies, posted in General)
The way I add a picture in a post is to get the link without "&preview" to the attachment once published --> edit post 
563 2015-11-02 08:56:50
Re: CB and Pictures (5 replies, posted in General)
Oh my god, the picture is huge!!
565 2015-10-29 14:12:44
Re: Resize Windows (2 replies, posted in Script)
From my personal observation, there is no dynamism in the form so when you resize a form, you only move the external borders, that's it.
To change the background of a panel, select the form and change the property BgColor.
566 2015-10-27 08:10:34
Re: Edit.text And ComboBox.dbItemID Script To Report Clear Reset FrxDBDat (6 replies, posted in Script)
we do not see your screenshots, there are not properly linked or we do not have permission to read them from where they are stored.
567 2015-10-22 16:57:53
Re: Mandatory field on condition (9 replies, posted in Script)
Oh great, OpenCalendar does the trick, thanks a lot.
@Derek, I am running Windows 7 & 10...
568 2015-10-22 14:27:31
Re: Mandatory field on condition (9 replies, posted in Script)
Hi Derek,
thanks for the tip but unfortunately, it does not seem to work with the DateTimePicker object. It does not change color
569 2015-10-22 11:49:28
Re: Mandatory field on condition (9 replies, posted in Script)
Just a comment using version 2.1, focus on the object is not obvious at all. This is just cosmetics but a user could not spot which field is required.
570 2015-10-22 10:21:10
Re: Mandatory field on condition (9 replies, posted in Script)
Thank you Dmitry, I really need to dive into Delphi scripting as it is still not that obvious to me
571 2015-10-22 07:52:17
Topic: Mandatory field on condition (9 replies, posted in Script)
Hi all,
I am struggling finding a way to force a field to be mandatory on a condition.
I would like to set a date picker to become mandatory when a specific choice in a combobox is selected.
e.g:
My combobox Status has many choices but on choice with id = '4' , I want to force the user to set a Return date otherwise other scripts do not work properly.
Displaying a message would not suffice... we all know users
Any idea welcome.
572 2015-10-21 09:07:03
Re: New Forum Script (4 replies, posted in General)
Click on your name in a discussion.... or click on "Profile" at the top
Explore the features and use "Search" at the top
573 2015-10-21 09:03:56
Re: SQL type (2 replies, posted in SQL queries)
Myvisualdatabase uses SQLite and starting from version 2.03, you can also use MySQL.
574 2015-10-21 08:38:11
Re: New Forum Script (4 replies, posted in General)
When you want to get notified for a post, you just have to click on "Subscribe" or tick the checkbox "Subscribe to the post" when posting a new topic
To see full list of a member, click on his name ...
I would suggest to avoid writing your topic full in bold or capital letters in a forum this is not welcome.
575 2015-10-20 13:27:31
Re: Right To Lefty Languages (10 replies, posted in General)
AAaaaaah Ok, sorry I do have European regional setting, that's why