FiveTech Software tech support forums

... 3307 ) IF oo:lConnect ? 'Connected !', '<b>Versión RDBMS MySql', oo:Version() ELSE ? oo:cError ENDIF cSql := "select * from contrib limit 5" IF !empty( hRes := oo:Query( cSql ) ) ? '<br><b>Total Select: </b>', oo:Count( hRes ) aData := oo:FetchAll( hRes ) endif ...

hOLA,

SELECT * FROM tabla ORDER BY reg_control LIMIT 1 // 1er registro
SELECT * FROM tabla ORDER BY reg_control DESC LIMIT 1 // ultimop registro

donde reg_control es un campo tipo autonumerico

DBF has file size limitation of 2 GB. ADS removed this limitation even for DBFs. Our colleagues who are using DBFs for this purpose are aware of these limitations and their volumes are within 2 GB. When we program for Corporate clients, ...

DBF has file size limitation of 2 GB. ADS removed this limitation even for DBFs. Our colleagues who are using DBFs for this purpose are aware of these limitations and their volumes are within 2 GB. When we program for Corporate clients, ...

Hi, sorry for the delay. redefine EDIT gnum var vnum id 4002 of d_loc2 UPDATEgnum:setlimittext(10) It gives me this error while compiling: Error E0030 Syntax error "syntax error at 'EDIT'" If I put away the UPDATE statement, It's compile fine, but ...

... You will find many other featues, if you keep exploring. Please also note that the dialog is made on scroll panel and therefore there is no limit for the number of fields. This dialog also provides for navigation of the database.

to force minimum version to compile add this flag :
-mmacosx-version-min=10.12 ( for 10.12 for sample )
This limit your app to macox10.12 and higher.
I use 10.13 if you need to know if an app works, I have no problem testing it.
cheers.

If we have more 30000 bytes, memoedit readonly does not show.

If you are using FWH2006, even larger text is displayed without any limit.
(Note: MEMOEDIT function is renamed as FW_MEMOEDIT)

... a medida que va creciendo la base de datos, por lo que requiero únicamente cargar al inicio de la aplicación algunos registros, puede ser usando LIMIT o un WHERE, dependiendo del mes activo o el id del cliente... etc... Por lo que requiero hacer algo similar a una paginación para que los recorset ...

... table. With do while !eof(). There're 35000 records. All the records went read, but in the table only a few are inserted. I try with the clause limit 1,35000, just for testing and nothing happened. Best regard Thank you. Enviado desde mi Redmi Note 8 Pro mediante Tapatalk

... la tabla e inserto cada registro en la tabla mysql. Con reccount() verifico que pase por todos, pero no los ingresa todos. Solamente unos 100. Uso LIMIT 1, 35000. Con otros dbf de menos registros no pasa. Como puedo solucionarlo? Gracias. Enviado desde mi Redmi Note 8 Pro mediante Tapatalk

Anyone has any solution to limit the number of lines?

TIA

... fields that I have to make sure the character count does not exceed the maximum table field length .. The reason I want to enforce a strict field limit is the text will eventually fit into an program generated e-mail. I do not want someone writing a 1000 char message that I have to format in a ...

... What I do not understand is the inconsistency, since I think that the greater the number of days, the price should be less, up to a certain limit. For example, if the price for a week is 40 (5.71 per day), for 15 days it should be less (per day), and so on. However, it is my particular concept, ...

... What I do not understand is the inconsistency, since I think that the greater the number of days, the price should be less, up to a certain limit. For example, if the price for a week is 40 (5.71 per day), for 15 days it should be less (per day), and so on. However, it is my particular concept, ...