Search options (Page 6 of 34)

What are you using? Abiword is a word processor, it is not designed to process spreadsheets. The button 'open to excel' is actually opening a CSV file. so if you want to open CSV files with a word processor, you must tell Windows to associate CSV files to a word processor.

I think that if you do not have Excel installed, Windows will ask you which program you want to use, set it to open by default. Have you tried?

That answers part of the question, is there a very specific code behind the buttons so that when we use the "Show Form" action, it automatically performs a grid.dbupdate on any grid displayed on the form opened?

If there is a way for the device to send data to an external database or copy the data from the device to the database, I don't see why not. It depends on the device connectivity and protocol openess but I'd rather use MySQL to manage patient data or even better a time series database system like Influxdb which coupled with Grafana can provide very nice real time and recorded graphs. Both are open source, which means free professional products. I use it to monitor my homemade weather sensors and lots of IT companies use it to monitor their infrastructure in real time.

https://grafana.com
https://grafana.com/grafana/
https://grafana.com/grafana/plugins/dat … e-plugins/

https://www.influxdata.com/influxdb/

What are you trying to achieve with your conversion?
I do not understand the "SQLDateTimeToDateTime" part, usually you convert a date time to a date or to a string not to date time.
According to the error, your column format might not be a "date time" but a "date" field only, hence the impossible conversion.

@k425, vovka3003 and sparrow,

A big thank you, UUID was my initial idea but I have no idea how to implement it with MVDB since you need to use sha or md5 is there a hash feature in MVDB?

I will try the 2 other solutions whichever is simpler and more capable of uniqueness of the generated UIDs.

Thanks, that does the job but I need to fill just one text box at a time, I am struggling to adapt this to a textbox instead of a memo.

There is an open source version of FastReport now, any chance to see an ultimate version of MyVisualDatabase implementing it? https://github.com/FastReports/FastReport

It does work with text fields but if the field is integer, it skips the zeros when scanned!!

Ici: http://myvisualdatabase.com/help_fr/Introduction4.html

ou depuis l'interface de MVDB Menu en haut --> Help --> Help (ce sera en anglais par là)

On ne peut pas vraiment parler de manuel en tant que tel mais plutôt un guide.

La commande INSERT INTO va toujours ajouter une ligne, c'est une commande SQL pour ajouter des lignes. Pour mettre à jour une ligne déjà existante, il faut utiliser "UPDATE" comme montré au post #2 par pavlenko.vladimir.v sauf qu'il faut enlever le deuxième "WHERE ID= your id" parce qu'on ne peut pas mettre deux fois "where" dans une requête SQL.

UPDATE table SET column = 'value' WHERE condition

https://www.sqlite.org/lang_update.html

if ( Frmservices.TableGrid1.SelectedRow >= 0 ) then
    SQLExecute('UPDATE devis SET prix="'+ SQLEXecute('SELECT prix FROM services WHERE id='+Frmservices.TableGrid1.sqlValue)+'")');