... is the delay in a select with many many records . I saw that browse for SQL ( like Mysql-Front) use this process SELECT * FROM dabase.client LIMIT 100 when I go over the 100 records automatically there is another select SELECT * FROM dabase.client ORDER LIMIT 100,100; it would be nice to ...
... 33< 44 45 46 5 6 The SET RELATION does a SEEK on 3 iin the service file so the pointer is at 3 but there is no upper limit, so you will also see 4, 5, and 6 in this case. So, I do not understand why yours is limited to 3 unless it is an artifact of your test method. ...
Please explain how you solved it using SET RELATION. That just keeps the records synced but it doesn't limit the display to a set of data (e.g. one customer). I think SCOPED RELATION. Command syntax: SET RELATION TO ......... SCOPED Function: OrdSetRelation( .... ) Hi Mr. ...
Please explain how you solved it using SET RELATION. That just keeps the records synced but it doesn't limit the display to a set of data (e.g. one customer).
Uwe, Please explain how you solved it using SET RELATION. That just keeps the records synced but it doesn't limit the display to a set of data (e.g. one customer). Also, speed could be affected by the database scope and/or the browse. Have you checked the speed of just the scope ...
ok ok I understood !! we have this limit !!! if you cannot create a report drill down, we must always be patient if some customers in the future ask us it, we must have patience to convince our customers that this type of report can not 'be ...
... a < ZONK > the game will be stoped and the reached values are set to 0 loosing the values 3. 2 players are gambling for POINTS 4. A trial-limit : Points are counted after reaching the limit of trials 5. adding any game-images ( to be loaded from a subdirectory ) 6. a DBF to add player-names, ...
... 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). 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 ...