how store Image into Database

[Jimmy]

hi,

i want to "store" Image into Database

Question :
which Type for DBF ? "M" or "V" or ?
which Type for SQL ? "BLOB" or ?

when store "Image" into
DBF using HEX or MEMOREAD ?
SQL using HEX with "pre-FIX" ?

when XBROWSEr / EDIT how to prevent FIELD from "type into" Image FIELD ... how to "Drop into" ?

which \Sample can show me how to begin under Fivewin

[nageswaragunupudi]

If you are using DBF via DBFCDX, use memo fields. ( DataType 'M' )
If you are using any RDMS use BLOB fields.

DBF:

Code: Select all  Expand view

FIELD->IMAGE := MEMOREAD( "picture.jpg" )

RDBMS:

Code: Select all  Expand view

oRs:image := MEMOREAD( "picture.jpg" )

If you are browsing in XBrowse, you can copy image from any source and paste into the cell.
This works for all datasources, viz, dbf, tdatabase, ado, fwmysql, dolphin, tmysql, postgre, arrays, etc.

[nageswaragunupudi]

If you are using DBF via DBFCDX, use memo fields. ( DataType 'M' )
If you are using any RDMS use BLOB fields.

DBF:

Code: Select all  Expand view

FIELD->IMAGE := MEMOREAD( "picture.jpg" )

RDBMS:

Code: Select all  Expand view

oRs:image := MEMOREAD( "picture.jpg" )

If you are browsing in XBrowse, you can copy image from any source and paste into the cell.
This works for all datasources, viz, dbf, tdatabase, ado, fwmysql, dolphin, tmysql, postgre, arrays, etc.

[Jimmy]

hi,

thx for Answer

This works for all datasources, viz, dbf, tdatabase, ado, fwmysql, dolphin, tmysql, postgre, arrays, etc.

found out
when want to use Postgre i NEED to use TPQserver / TPQquery as it is "hardcode" in Source

Code: Select all  Expand view

METHOD Load( lBlank ) CLASS TDataRow

   ELSEIF VALTYPE( ::uSource ) == 'O'
      IF ::uSource:ClassName == "TOLEAUTO"
         ...
      ELSEIF ::uSource:IsKindOf( 'TDOLPHINQRY' )
      ELSEIF ::uSource:IsKindOf( "TMSQUERY" )
      ELSEIF ::uSource:IsKindOf( "TPQQUERY" )
      ELSEIF ::uSource:IsKindOf( "TXBROWSE" )
   ELSEIF VALTYPE( ::uSource ) $ 'AH'

so i have to revise my CODE to use these CLASS to work with Fivewin Controls