FiveTech Software tech support forums

Hi,

Thus to insure updates are visible to other processes, you must issue a COMMIT after all database update commands

Which is the problem ?

C.

" COMMIT Perform a solid-disk write for all active work areas Syntax: COMMIT Description: COMMIT is a database command that flushes Harbour buffers and performs a solid-disk write for all work areas with open database and index files. The solid-disk write capability is ...

... But I think this test is not meaningful because he commits after every data record update. Is it really necessary to always commit? Don't the database commands fetch the values from the buffer? Could you possibly clarify this situation? Thank you in advance, Otto https://carles9000.github.io/?search=M%C3%A9tricas ...

hi, i don´t think that SIZE of Database itself is a Problem but to "load" Data from Database can be a Problem e.g. when XBROWSE i do make "thumbnails" from PDF / Image as Preview which i store into Database and a Link ...

José:

Advantage Data Architect (ARC), de Advantage Database Software.

Si no lo encuentras te lo envío.

Saludos

Something like that:
In the open DBF (In exclusive mode), we add lines, but do not save them to disk.
These lines exist only while the database is open.

... 11.2\bin>mysql -u vdbnr8ds_backup -prestaurardb 0 <C:\Cuentas32\Backup\2023-09-26-H17-M18-Cuentas32BD.sql ERROR 1046 (3D000) at line 22: No database selected Como pueden observar, inserta un CERO a mitad de la instrucción (lo resalté en rojo) , y corta el nombre de la base de datos a restaurar ...

... a browser page, understand? I need to be from within the system to enter a document and they process it and return a code to be recorded in the database. I used xharbour 1.2.1 with http normally but they changed it to https so I thought that by updating xharbour I could use it but still giving ...

... ," " ,".\connect.ini") TRY FWCONNECT oServer HOST cServer ; USER cUser ; PASSWORD cPassword ; DATABASE cDBName CATCH oErr oServer:ShowError() END EndIf RETURN oServer Contenido del archivo connect.ini mysql] host=localhost user=root psw=160770 ...

Hi,

A DBF file is open (use MyFile). In some situations, it closes for no apparent reason. Is it possible to catch the moment of closing the database and find out what caused it to close ?

... ," " ,".\connect.ini") TRY FWCONNECT oServer HOST cServer ; USER cUser ; PASSWORD cPassword ; DATABASE cDBName CATCH oErr oServer:ShowError() END Else ?"NO FILE" // mensaje con la version 2023/07 EndIf RETURN oServer mi archivo de entorno ...

... all changes (add/modify/delete) we make to the RowSet (or RecordSet in ADO) are all made to the RowSet/RecordSet in memory, but not written to the database. After making all required changes, the we can decide to write all changes to the physical database or discard all changes. oCn:SaveBatch() ...

... image. Or this parameter can be any image-type bmp/jpg/png. If specified, a blob of that type is returned which can be used to save to a field of database or to a file. Example:    cImage := FW_StitchImages( "c:\fwh\bitmaps\olga1.jpg" , "c:\fwh\bitmaps\pngs\2.png", ...

... ( I mean for applications meant for West European Languages only. Only requirement for UTF8 is when writing to and reading data from Utf encoded database tables. We have other ways of handling that. Just an idea for you and other friends to consider.

Hello, with the native Fivewin I think it is: oRs:Fields:Count With ADO, oRs:Fields:Count(), whatever be the database. With FWH native MySql/Mara library, both work oRs:Fields:Count() or oRs:FCount(). The native library supports both complete ADO syntax as well as normal DB syntax ...