FiveTech Software tech support forums

I am filling out an Excel document provided to me from a Government entity. This sheet performs many validations and calculations upon entering the data. When I fill out the sheet via OLE it does not seem to trigger the validation or calculations, but if I open it and type ...

... in more or less the same time. I could write the entire 800,000 rows to DBF in about 10 seconds, much less than a minute. However I did not do any validations row-wise and cell-wise. If we do any such validations, we need to highly optimize the code because this code gets executed 800,000 times. ...

Regards Mr Rao
Reading the CSV file by passing it to an array() not even 15 seconds, 780,000 lines, reading as XLSX took a few hours
The recording if it takes 1 hour and a half, because there are validations before recording record by record.

Mr Rao. where can I get a complete reference to new syntax of xbrowse ? for example, how to write validations and button actions in the new syntax. I try like this but not working: @ 25,210 XBROWSE oBrwPrice SIZE -5,-5 PIXEL OF oFld:aDialogs[1] ; DATASOURCE orsPrice ...

... ways. Making some projects you can see that is possible to reuse all the code already made with harbour in windows. All the functions, the validations and data processing. This is incredible. You have nothing to rewrite. Yes, the forms are different and you must use another approach. It's ...

... ways. Making some projects you can see that is possible to reuse all the code already made with harbour in windows. All the functions, the validations and data processing. This is incredible. You have nothing to rewrite. Yes, the forms are different and you must use another approach. It's ...

... ways. Making some projects you can see that is possible to reuse all the code already made with harbour in windows. All the functions, the validations and data processing. This is incredible. You have nothing to rewrite. Yes, the forms are different and you must use another approach. It's ...

... ways. Making some projects you can see that is possible to reuse all the code already made with harbour in windows. All the functions, the validations and data processing. This is incredible. You have nothing to rewrite. Yes, the forms are different and you must use another approach. It's ...

... can not use indeterminstic values for comparison. For example ( price > 0 ) is accepted but not ( `date` <= CURDATE() ). These kind of validations are still required to be done in triggers only. Please note that using both features of calculated columns and check constrains most of ...

... front end does not do validation, the validation at the server level does not permit entry of invalid data. This is more secure than relying on validations in the front ends only.

... 1) Implementation of Transactions. 2) Database integrity at server level through a) Foreign key relationships b) Unique constraints c) column validations d) calculation of dependent columns e) updation of related tables f) ENUM type of column 3) Triggers and stored procedures Lack of support ...

... out of 20+ fields, the others are loaded in a personalized dialog when you want to see, edit, modify the record, mainly because there are a lot of validations in some fields and not every user has privileges to edit some of them. I use this approach with almost all the tables in a big ERP, just ...

... etc. I have a large clients table, but in a xbrowse I just show 4 fields out of 20+, in tDolphin, I have an extra dialog, a big one with lot of validations items, after that I save modifications and do: oDbCli:LoadQuery(.F.) oBrw:DrawLine() and only the current line in xBrowse is altered and ...

... assigned with the help dialog function. If the user selects a product, return the producitid. If the user cancels the operation, return nil. Edit validations function is like this: function valid ...( oGet, oCol ) if oGet:VarGet() is not valid oGet:cText := oCol:Value // restore the original value ...

... class also knows how to handle errors avoiding ugly runtime errros in the final application. Our work is limited to handling the edit dialog and validations, whatever be the datasource. Add: Same way as edit. The data is appended the table and record pointer is moved to the new record. Depending ...