pcsoft.us.windevCopyright 2026, PC SOFT20 Dec 2017 10:42:00 Z16 Dec 2017 08:57:00 ZHello everybody. Maybe I overread it. Is there a function that can determine the highest value of a field in an HFSQL database? Best Regards Stefan30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63740/read.awp20 Dec 2017 10:42:00 ZThanks for the comments. I think I will use the variant of markus.k Thanks to all who contributed here. Best Regards Ste…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63740/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63740/read.awpDatabase Field Value [WD 22]guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63694/read.awp17 Dec 2017 01:52:00 ZHello Stefan If you index the field then HReadLast() should return the highest value Regards Alhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63694/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63694/read.awpDatabase Field Value [WD 22]guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63690/read.awp16 Dec 2017 11:53:00 ZHI Stefan, not sure what exactly you would like to achieve, but using a query would do the trick i guess? something like: …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63690/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63690/read.awpDatabase Field Value [WD 22]guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63689/read.awp16 Dec 2017 10:43:00 ZHi, the easiest and fastest way is to save the value in a second table. Then just compare new values with this value, if it is …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63689/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63689/read.awpDatabase Field Value [WD 22]guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63688/read.awp16 Dec 2017 10:10:00 ZHi Stefan, I'm sorry, there's no WLanguage function for limiting the values of fields within an HFSQL database. I'd suggest y…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63688/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63683-database-field-value-63688/read.awpDatabase Field Value [WD 22]