FiveTech Software tech support forums

Hola, necesito guardar el texto de un Richedit en SQL Server, lo declare como varbinary(max) nvarchar(max) cualquiera de las 2 maneras me da error.

Podrían decirme como hacerlo

Saludos
Jorge

... =; ModTime HB_FT_MODTIME,8 ADS_MODTIME Raw,n HB_FT_STRING,n (+HB_FF_BINARY) ADS_RAW Q; VarChar,n HB_FT_VARLENGTH,n ADS_VARCHAR; ADS_VARCHAR_FOX VarBinary,n HB_FT_VARLENGTH,n (+HB_FF_BINARY) ADS_VARBINARY_FOX; ADS_RAW CICharacter,n HB_FT_STRING,n ADS_CISTRING

... You can choose OLE and then store any binary data in the field. But when we create the table using SQL, better we use the datatype VARBINARY or LONGBINARY. Also see https://codekabinett.com/rdumps.php?Lang=2&targetDoc=sort-index-binary-data-access-database

Hola la imagen está como VarBinary (max) y no funciona. This depends on the MSSQL server version. For versions less than 9.0, we need to use    [FOTO] IMAGE  and for later versions, we can use    [FOTO] VARBINARY(max)  ...

Hola la imagen está como VarBinary (max) y no funciona. This depends on the MSSQL server version. For versions less than 9.0, we need to use    [FOTO] IMAGE  and for later versions, we can use    [FOTO] VARBINARY(max)  ...

Hola la imagen está como VarBinary (max) y no funciona. This depends on the MSSQL server version. For versions less than 9.0, we need to use    [FOTO] IMAGE  and for later versions, we can use    [FOTO] ...

Hola la imagen está como VarBinary (max) y no funciona. Lo solucione guardando la imagen en un temporal.jpg e imprimir desde ese temporal y funciona perfecto. Saludos. Jorge Not necessary. This is an example for MSSQL. This sample uses ...

Hola la imagen está como VarBinary (max) y no funciona.

Lo solucione guardando la imagen en un temporal.jpg e imprimir desde ese temporal y funciona perfecto.

Saludos.
Jorge

Rao

I am using MS Sql Server .. there is no "Blob Type" .. however VarBinary(max) works for me ..

Rick Lipkin

Jorge Make sure your Sql Field value in your table is VarBinary(max) There is an easier way of coding inserting pictures, files .. into a Sql VarBinary(max) field .. however this code works for me .. // open file //nHANDLE := FOpen( cFILE )IF ...

... { " Seguir " }, "Atención" ) END TRY El error que da: No se permite la conversión implícita del tipo de datos varchar(max) a varbinary(max). Utilice la función CONVERT para ejecutar esta consulta. Saludos Jorge.

... original file ?? I may have interpreted your question incorrectly .. however, This is how I store and retrieve a file from Sql Server .. 1) Use VarBinary(Max) field type 2 here is the code to save your file ( any file ) to a VarBinary(max) field in your table ... this is my code .. note this ...

You can use either TINYBLOB and VARBINARY(n). Only depends on your taste.

... From my experience, the only way to store any file in a Sql table is to import the picture as a binary file (AppendChunk) into a ( sql server ) VarBinary(Max) or equivalent. The data is stored as bytes and have to be re-assembled back in it original form ( GetChunk )to be viewed... so I don't ...

... length of the data written to the binary field. It is not necessary. oField:ActualSize indicates the actual size of data written in the VarChar or VarBinary field. GetChunk() and AppendChunk() are meant for those dialects which can not handle large amounts of data like we do in (x)Harbour. We can ...