701 Topic by tcoton

(3 replies, posted in Script)

Hi there,

I am looking for a script which would check if the value already exists in a column and if so, display a warning without saving and/or a script to implement a maximum value to input in a field with a warning of same kind as before.

The aim would be to control what is going to be filled in a column.

If value a > 100 = block and display max value acceptable (no save) --> click ok and try something else
If value a already exists = display warning: value already exists. (no save) --> click ok and try something else
If value acceptable = save value

Go to forum: Script

702 Reply by tcoton

(4 replies, posted in General)

This is interesting. Couldn't it be part of an object property for the grids? I also need to sort my grids and as described everytime a change is made, I have to re-sort it again.

Go to forum: General

703 Reply by tcoton

(8 replies, posted in General)

Dynamic cell size is a must, so cool!!

Go to forum: General

704 Reply by tcoton

(4 replies, posted in General)

Wow nice script but when running under 1.50, the mouse cursor just goes behind the application's window when searching groupname with numbers!

Go to forum: General

705 Reply by tcoton

(16 replies, posted in Reports)

Looks great, thanks for implementing this Dmitry.

Any chance to see a much user friendly report designer some day? smile

Go to forum: Reports

706 Reply by tcoton

(5 replies, posted in SQL queries)

Mr_D, it seems to work within your application thanks a lot, I will a have a deeper look at it when trying to integrate that inside the massive SQL query I have around this specific one wink This is just the tiny part on which I was struggling a lot, many thanks for your time!

Go to forum: SQL queries

707 Topic by tcoton

(1 replies, posted in General)

Hi Dmitry,

I found a small bug in 1.50: you cannot change the Font colour of a button even though the property is available, whichever colour you pick-up, the text remains black.

Go to forum: General

708 Reply by tcoton

(5 replies, posted in SQL queries)

The most approaching coherent result I could get is with this query but I cannot manage the substr within:

select max(CAST(TelNr as integer)) as NB from Telephony t1
where t1.TelNr < 5987
and TelNr not in (' ','Basestation','Reserved')
and TelNr is not null
order by NB

Go to forum: SQL queries

709 Reply by tcoton

(5 replies, posted in SQL queries)

Thanks mr_d but when I run this query in SQLiteStudio, I get :[15:11:41] Error while executing SQL query: no such function: strtoint

select max(strtoint(substr(t1.TelNr,-5, 5))) from Telephony t1 where strtoint(substr(t1.TelNr,-5, 5)) < 5560

Go to forum: SQL queries

710 Topic by tcoton

(5 replies, posted in SQL queries)

Hi there,

I am struggling in getting the max value of an integer in a Text column.

The TelNr column has to contain text and numbers but I would like to retrieve a very specific value from this column.

As shown in the attached file, the numbers are not sorted in the right order and thus when I request the max value, I do not get the right result.

The point is that in my application, I have a query to check the next available telephone number depending on which number is already in the database BUT I want to limit the availability on the last 4 digits and it does not work due to the text type of this column.

Any suggestion apart from a re-design of the database and the application?

http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&amp;item=905

Go to forum: SQL queries

711 Reply by tcoton

(6 replies, posted in General)

Wow, this is far beyond my programming skills, it looks like you are using floating calculation, so maybe you would have to set the max decimal in a variable, I am not an expert for this here, just a guess from the top of my head.

http://www.delphibasics.co.uk/RTL.asp?Name=FloatToStrF

http://www.delphibasics.co.uk/RTL.asp?N … cyDecimals

Go to forum: General

712 Reply by tcoton

(6 replies, posted in General)

Ho do you get the result in last box? Do you use SQL query or calculated field?

Go to forum: General

713 Reply by tcoton

(6 replies, posted in General)

Do you mean that you want to round the result to only 2 decimals? So it should show 5,69...

Go to forum: General

714 Reply by tcoton

(187 replies, posted in General)

Single sign-on would be very helpful to manage permissions within an application as most of current companies are using Active Directory and managing login/passwords is just a chore.

Go to forum: General

715 Reply by tcoton

(2 replies, posted in General)

I would also be interested in the answer big_smile

Go to forum: General

716 Reply by tcoton

(2 replies, posted in General)

Hi,
I noticed the same issue when querying straight from sql. You can use the strftime function:

Select strftime('%d/%m/%Y', Birthdate) from yourtable

More details here: http://www.sqlite.org/lang_datefunc.html

Go to forum: General

717 Reply by tcoton

(10 replies, posted in General)

Yes, I noticed smile I had to re-download the application since I got an error while compiling the project.


Do you think we could store the picture into a "dictionary" table and be able to call the images depending on a value in a column?

I am thinking of replacing a value by a picture depending of a status set by a combobox

Go to forum: General

718 Reply by tcoton

(10 replies, posted in General)

So cool! I did not know it was implemented in 1.50.

Would it be possible to get a release note icluded in the package so every time we update the application we know about all the new features?

Go to forum: General

719 Reply by tcoton

(16 replies, posted in Reports)

Any news about the plan? I have some project coming on the table which might require a lot of reporting smile

Go to forum: Reports

720 Reply by tcoton

(10 replies, posted in SQL queries)

@r00t3d777


Actually it could be any project since I am using internal sqlite triggers, I just need to know how to retrieve the windows account currently connected to insert it in the log table via the trigger.

Go to forum: SQL queries

721 Reply by tcoton

(2 replies, posted in General)

Cool!! Thanks Dmitry

Go to forum: General

722 Topic by tcoton

(2 replies, posted in General)

Is it possible to display a small picture like an icon in a column in a grid?

I have attached a screenshot.

Go to forum: General

723 Reply by tcoton

(10 replies, posted in SQL queries)

What a shame.... it is way easier to populate a logging table without all the scripting

Here I have a simple example (I use SqliteStudio to create the triggers):

--  Create an insert trigger
CREATE TRIGGER insert_Maint_log AFTER INSERT  ON Maintenance
BEGIN

  INSERT INTO logs  (    
    Change_date,
    Maint_PcName,            
    Maint_id_Typ           ,
    sqlAction         ,
    Maint_details       ,
    Maint_date,
    src,
    username
    
      
        
    )

          values (
DATETIME('NOW'),
new.PCName,
new.id_Pc_Typ,
'INSERT',
new.Maint_Details,
new.Maint_date,Maintenance,
????????);

END;

Go to forum: SQL queries

724 Reply by tcoton

(9 replies, posted in General)

Dmitry, I have sent my project smile

Go to forum: General

725 Reply by tcoton

(9 replies, posted in General)

The problem is that, I tried the sizeable=true parameter but it messes up everything when you resize manually the windows, the main window is resized in one direction each time whereas the content does not resize nor move to adapt to the new size... so weird!!

So when I set sizeable=true to a form and afterward I want to resize the window to adapt to current resolution, the main window resizes on top of its content!!!

I will try to play with the anchors settings for each component, but I doubt it would fix the resolution issue...

Go to forum: General