FiveTech Software tech support forums

... Clave: 001 Sucursal: Independencia
Codigo: AB1013 Ubicacion: Centro
Fecha: 05/11/2024 Equipo: Refrigerador

El campo de la columna 3 es un Longtext de un RecordSet SQL

@ 3.5, .5 LISTBOX oLbx FIELDS "Folio: " + Transform(oRecordSet:Fields("Id"):value,"9999") + CRLF + "Codigo:" +
IIF ...

Estimados:
Tengo un texto de un RTF, lo copio y grabo en un campo LONGTEXT de MySql.
Luego, con el siguiente codigo, lo puedo ver perfectamente en un dialogo

DEFINE DIALOG oForm TITLE "Modelos" FROM 05,10 TO 35,120 OF oWnd
@ 35, 15 RICHEDIT5 oGet[3] VAR cText OF oForm PIXEL SIZE 400, 170
@ 05,30 ...

Oh thank youvery much but
I thought a value that contains what you see on video was expected
such as oData:cData or oData:cTextData or LongText Data.....


bye

What is the name to field "LONGTEXT"?

... funciona salvo cuando quiero recuperar el backup, el registro me devuelve 310 bytes menos que el original, por supuesto cuando quiero restaurar me dice que el backup está corrupto. E intentado con un campo longblob y longtext sin ningún resultado. Alguna pista donde mirar? Muchas gracias!.

Saludos

nageswaragunupudi wrote:

Code: Select all | Expand

{ "texto", "M", .... }

Can you read these?

http://forums.fivetechsupport.com/viewtopic.php?f=6&t=40352&sid=3e2c08a9401357287fe970a4458c428b

... T. )   aDatos := { ;               { "texto",        "LONGTEXT", 250, 0, .T., 0 }, ;             }   RETURN ( ::oCnx:createTable( "tbfichas ...

Hi,

I have lots of pdf file and I want to save them to related records in LONGTEXT field. It saves for a while and surprisingly after storing about 1580 mb, the application of oRs2:Save() function ends without any error. The hb_error file does not generated either.

How can I solve this problem ...

You can safely store large memos also in LONGTEXT fields. In case of binary data you can store in LONGBLOB fields.

Regarding the speed of retrieval, it is a good practice to exclude these fields in the SQL reading the data and access these fields only when needed.

In our tests, filters on LONGTEXT fields are working.

This is the test program:
#include "fivewin.ch"function Main()   local oCn, cSql, oRs   oCn   := FW_DemoDB( "ADO" )   TRY      oCn:Execute( "DROP TABLE testmemo" )&nbsp ...

... las ciudades.
Para poder guardar las imagenes tenes 2 opciones, o la pones como un dato en una tabla de tu base de datos en un campo longblob/longtext/mediumblog/mediumtext o lo guardas subes mediante ftp. Por lo que lei, guardar las imagenes en una tabla suele relentizar las busquedas despues ...

We did this test for LONGBLOB and LONGTEXT fields. Source code is provided in this post, which uses files available in fwh\samples folder and can be tested by any.

function BlobTable()   local cSourceDBF  := "c:\fwh\samples\wwonders.dbf"   local cBackUpFile := "c ...

tables with longblob and longtext fields and with images or
PDF files inside a longblob field.
As we said in our earlier post, these would be a little slower because we are backing up and restoring one record per one sql statement. While writing the code, we just wanted to play safe on memory ...

... for the benchmark, it's very impresive.

I'll be glad and very gratifully if you can make an other benchmark
using tables with longblob and longtext fields and with images or
PDF files inside a longblob field.

I want to update my fwh but it's very important to know the restore speed.

Thanks ...