FiveTech Software tech support forums

... clave primaria y las sentencias que le preceden son: cSqlA := "SELECT * FROM latabla WHERE (TIPUSOLI = 'A' OR TIPUSOLI = 'B') AND ESTAT = 1 LIMIT 1" (Pongo 'LIMIT 1' porque quiero trabajar registro a registro). La clave primaria es fundamental para la modificación UPDATE y el borrado ...

... clave primaria y las sentencias que le preceden son: cSqlA := "SELECT * FROM latabla WHERE (TIPUSOLI = 'A' OR TIPUSOLI = 'B') AND ESTAT = 1 LIMIT 1" (Pongo 'LIMIT 1' porque quiero trabajar registro a registro). oQry := oConDB:Query( cSqlA ) While oQry:nRecCount > 0 ../... resto de ...

... I don't think I have ever dealt with the situation where we needed to remove an option for all future records. Is the purpose of the combobox to limit users to specific choices, or are these just suggestions? Maybe if you provided more details, I could offer more relevant suggestions. James

... a DBF RDD loads only 20 records into memory. Opening 20 databases with ADORDD loads 20 entire databases into memory. Yes modifying your code to limit the range of the records loaded is the best solution and that is a viable option if you have a program written for a single customer. However, ...

James, adordd is in big changes and will only read from table once when it opens it. You can also use with a query to limit the range of the set. After loading the set it only re read the table again when new additions by others are made. Next week Ill post a new version with big ...

... was no problem since I had many gigabytes of available RAM and the XML might reach 10 MB. In theory that might be OK, but in practice there was a limit. I then decided to add to the XML with an FWRITE after each pass. That was still a goodly amount of data ( the loop was on customers, and this ...

... in the heap. If originaly the original heap had 1000 bytes we got the heap split in two fragments, one of 100 byte and other, free, of 900. That limit of 1000 bytes is not real, it's for the sake of the example, usually it is way bigger than that, in the order of Gb, but an small heap is needed ...

... and it is written to the same point each time. I checked and there is no error in the database. I figure that the FWRITE( ) function must have a limit in file size. I'm using the latest xHarbour.com for this build. There is plenty of memory on the computer. In fact, it has happened on two different ...

Hua,

make -fyourmake.mak flag1=demo flag2=limit

From your makefile:

$(flag1)

$(flag2)

... lo que traes en una consulta, es el estado de una tabla de MySql, en el momento que haces la consulta y segun los filtros que le apliques (WHERE, LIMIT, Etc). La consulta te queda en el objeto Query que hayas creado, y para obtener una actualización de los datos de la consulta, tienes que refrescar ...

... index more adecuate. please create index only for fields using in where statement. for example: select user code, name from user where num_usr='1' limit 1 here the column num_usr must index type unique. for acelerate the select. i each table in my databasea have a int column not negative not null ...

... on the invoice-number. Each time a customer add a new invoice I check for the last invoice number (Query with a desc order on invoice-number and a limit of 1). Then I add directly an empty record with that invoice number to the table. So, if someone else whant to add an invoice, he will get a higher ...

... Corporate environment and it all boils down to security. 1) You can use a local SMTP transport within a business, however most large Corporations limit SMTP traffic from ONLY KNOWN DNS targets such as multi function machines ( copiers that scan .pdf to e-mail ). And the other achilies heal is ...

... going into the table and the verification of the file being re-created as it is being read out of the table. I have found that it is best to limit the file size to 1 gb or less if you are storing it in a Sql table. There are pros and cons to storing binary data vs just referencing a datafile ...

... any deleted records. Use DBFCDX Let it have only one Tag in the cdx file. Preferably on a small numeric column. Prepare a small simple xbrowse. Limit the columns to what we can see on the screen. Do not add any features of xbrowse. Let us see the performance. And then decide what all we can ...