Search found 103 matches: datatype

Return to advanced search

Re: DBF to Excel Sheet, without Excel, using ADO ?

... of the limitations of creating Excel sheets using ADO. a) Whatever length we specify, all character columns are VarChar(255) b) Whatever numeric datatype, like int, numeric(w,d), etc we specify the columns are finally double only. c) Date fields accept both dates and datetime values. d) Use field ...
by nageswaragunupudi
Mon Aug 14, 2023 10:39 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2288

Re: DBF to Excel Sheet, without Excel, using ADO ?

... Fivewin Function like    FWAdoCreateTable( cTable, aStruct, oCn, .f. ) // --> lSuccess but it is not for Excel it have to with "Datatype" which Excel use https://learn.microsoft.com/en-us/sql/odbc/microsoft/microsoft-excel-data-types?view=sql-server-ver16 --- ...
by Jimmy
Wed Aug 09, 2023 10:20 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2288

Re: how store Image into Database

If you are using DBF via DBFCDX, use memo fields. ( DataType 'M' ) If you are using any RDMS use BLOB fields. DBF: FIELD->IMAGE := MEMOREAD( "picture.jpg" ) RDBMS: oRs:image := MEMOREAD( "picture.jpg" ) If you ...
by nageswaragunupudi
Sun Jul 23, 2023 11:49 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: how store Image into Database
Replies: 3
Views: 284

Re: how store Image into Database

If you are using DBF via DBFCDX, use memo fields. ( DataType 'M' ) If you are using any RDMS use BLOB fields. DBF: FIELD->IMAGE := MEMOREAD( "picture.jpg" ) RDBMS: oRs:image := MEMOREAD( "picture.jpg" ) If you ...
by nageswaragunupudi
Sun Jul 23, 2023 11:49 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: how store Image into Database
Replies: 3
Views: 284

Re: "ADODB.RecordSet" active in XBROWSE ?

so i need to "detect" which ist running ... how :?: if oBrw:nDataType == DATATYPE_RDD   // DBFelseif oBrw:nDataType == DATATYPE_ADO  // ADOelse///endif Please see \include\xbrowse.ch for the DATATYPE_??? defines. Another way: if !Empty( oBrw:oRs )   // ADO...
by nageswaragunupudi
Wed Jun 21, 2023 4:50 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: "ADODB.RecordSet" active in XBROWSE ?
Replies: 7
Views: 534

Re: HASH vs single variables

... you think a popup label of a king) In the popup I can change/add. Type = Return Type data Veld = VarName Data = content of Var (can me array,...) DataType = type that the data is made in (ex. Datatype = array, but Type = C as return value for program info = what's about...to remember afther time ...
by Marc Venken
Wed Jun 07, 2023 11:22 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: HASH vs single variables
Replies: 15
Views: 1060

Re: xBrowse footer picture

... :nFooterType := AGGR_SUM :cEditPicture := "€ 99,999.99" :cDataType := "N" END In case of empty arrays we need to inform the datatype of the column by setting cDatatype Or we wait for mr. Rao )))) Many thanks, Marc! :cDataType := "N" was the solution. :D btw. I never ...
by Detlef
Mon Apr 03, 2023 2:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse footer picture
Replies: 11
Views: 697

Re: xBrowse footer picture

... :nFooterType := AGGR_SUM :cEditPicture := "€ 99,999.99" :cDataType := "N" END In case of empty arrays we need to inform the datatype of the column by setting cDatatype Or we wait for mr. Rao ))))
by Marc Venken
Mon Apr 03, 2023 2:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse footer picture
Replies: 11
Views: 697

Re: Campo autoincremental en DBF

To create an auto-increment field, just use datatype "+" { "ID", "+", 4, 0 } That is enough. Please try it. Do not worry about the width of "4". They do not represent decimal digits. The value is stored as ...
by nageswaragunupudi
Fri Nov 04, 2022 11:12 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Campo autoincremental en DBF
Replies: 7
Views: 726

Re: datatype

METHOD FieldType( n, c ) INLINE If( c == nil, ::aStruct[ n ][ 2 ], ::aStruct[ n ][ 2 ] := c )
by James Bott
Tue Feb 15, 2022 3:53 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: datatype
Replies: 1
Views: 303

datatype

when I go to create the temporary order in memory (see this topic http://forums.fivetechsupport.com/viewtopic.php?f=3&t=41377&start=0&sid=125ed95a697356ee0ca6845b50441ee5 ) I load the types of the database columns I am going to save the data type in an array aTipos [ n ]:...
by Silvio.Falconi
Mon Feb 07, 2022 11:57 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: datatype
Replies: 1
Views: 303

Re: operador In

Code: Select all  Expand view

x IN aDatos
 

is permissible syntax in xHarbour and is very powerful.
I do not understand the reason for the runtime error, because we can use any datatype for x in this syntax.
by nageswaragunupudi
Mon Feb 22, 2021 10:15 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: operador In
Replies: 6
Views: 489

Re: Imprimir imagen guardada en tabla SQL

... 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
by nageswaragunupudi
Mon Dec 28, 2020 10:03 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Imprimir imagen guardada en tabla SQL
Replies: 11
Views: 2370

Re: Imprimir imagen guardada en tabla SQL

... .t.] )  aStruct is a normal DBF style structure array we are all very familiar with. Data type "M" creates a long text field and datatype "m" creates a long binary field. This function internally creates an sql statement appropriate for the RDBMS and its version and ...
by nageswaragunupudi
Fri Dec 25, 2020 4:12 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Imprimir imagen guardada en tabla SQL
Replies: 11
Views: 2370

Re: Imprimir imagen guardada en tabla SQL

This should work, if you created the table with FOTO as BLOB datatype.
by nageswaragunupudi
Mon Dec 21, 2020 12:10 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Imprimir imagen guardada en tabla SQL
Replies: 11
Views: 2370
Next

Return to advanced search