FiveTech Software tech support forums

Marc Venken wrote:Maybe :

xbrNumFormat( "E", .t. ) // "E" for European, "A" for American and others
// .t. for showing thousand separators

but why the same source code on another procedure run ok ?

Maybe :

xbrNumFormat( "E", .t. ) // "E" for European, "A" for American and others
// .t. for showing thousand separators

... BRITISH SET CENTURY ON xbrNumFormat( "E", .t. ) // "E" for European, "A" for American and others // .t. for showing thousand separators USE ITEMS /* CCODE Character 10 DETAIL Character 50 PVP1 Numeric 14 5 PVP2 Numeric 14 5 PVP3 Numeric 14 5 ARTIVA Numeric 5 2 LASTCHANGE ...

... In a few words, ORM it is a set of classes to greatly simplify the use of SQL relational DataBases. An example is worth a thousand words: function Main()   local oUsers := Users():New( "www.fivetechsoft.com:3306",;                          ...

... for what I want. Ofcource you cant say that you can input data online, but as a Fwinner, I had to automate it ))) Now I can read hunderds of thousand articles, manipulated them offline for speed, and upload. (I use Prestashop as Webshop) very huge amount of users (and potential customers) ...

... it looks like is related to high system load or reaching the maximum users working. Also monitoring the server the system Interrupt raise to 4 thousand by hours sometimes. We have tried several solutions, making sure cables and switches are in optimal conditions, optimize the code to avoid ...

Silvio,

Since you are only using less than 10 records, filters are not a speed issue. If you were using a thousand records, then they would be a big speed issue.

Impressive Otto!

A picture is worth a thousand words.

James

Realistically, is there really any point to converting a large legacy FWH application to SQL files using ADORDD? I have a thousand existing installations using dbf files with zero problems. To move to a web app with an SAS model would really require starting from scratch and doing a ...

Marc Here is a screen shot of one of my WorkOrder Invoicing modules .. there is about 6 thousand lines of code and there is no way it would fit in this message .. I have included the .rc file for your review .. send me an email to r2.1955@live.com and I will share the ...

... speed, it seems faster, BUT for this case it's still slow going 30 minutes and does not go up or 5,000 records of a table with 50 columns and 13 thousand records in total). I'm sure that any direct SQL statement would be faster, but I do not know how to do it ?? Thank you for your attention

a thousand thanks

... safe better of me not tendras no answer when requesting help me . I hope not to bother and that this remains up here . Forgiveness and Apologies thousand Maestro Antonio .. Regards.. Pd. Use google translator for you to understand your language ..

... just a week or two ago we discovered that the ADORDD was doing a commit after each record during APPENDs. This was taking 11 hours to append 26 thousand records. Appending the same file using DBFs took 1 second. So, buffering before writing to disk provides a tremendous increase in speed. One ...

Maromano, In your tests have you been able to do an APPEND FROM... with several thousand records? I have tried my code twice and it crashed at 548 records once, and 1354 records once (after rebooting). So, I suspect this has something to do with memory. Both APPEND ...