Search found 1023 matches: existing

Return to advanced search

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

Yes. We need an existing valid XLSX file to start with. Obviously because ADODB connection can be connected to an existing valid xlsx file, can not connect to "nothing". i have change you last CODE to "create" ...
by Jimmy
Tue Aug 15, 2023 10:16 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2610

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

your Sample work great ... but it NEED existing *.XLSx i have try to use a "empty" *.XLSx but got Error : Table does not have expected Structure :cry: so i need to create Table before i can go "your Way" Yes. We need an existing ...
by nageswaragunupudi
Tue Aug 15, 2023 7:11 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2610

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

hi,

nageswaragunupudi wrote:Please try:

your Sample work great ... but it NEED existing *.XLSx

i have try to use a "empty" *.XLSx but got Error : Table does not have expected Structure :cry:
so i need to create Table before i can go "your Way"
by Jimmy
Tue Aug 15, 2023 6:22 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2610

Re: ADO / Excel / XBROWSE / FWAdoStruct() / Edit()

does Function FWAdoStruct(objRS) work only on "active" Record :?:

It should work on both existing and blank records, but let me check again.

Please post a DBF Structure here so that we both work on the same structure
by nageswaragunupudi
Sun Aug 13, 2023 10:36 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO / Excel / XBROWSE / FWAdoStruct() / Edit()
Replies: 8
Views: 270

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

using your Sample i got


Obviously the file should be an existing and valid xlsx file. Otherwise with what ADO connects?
If the file is a valid xlsx file, FW_AdoImportFromDBF() works.
by nageswaragunupudi
Wed Aug 09, 2023 7:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2610

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

...     oCon:Execute( cQuery )   Catch oError      MsgInfo( oError:Description, cTable )      Return .F.   End try --- than i open a existing *.XLSx and look at Structure   objRS := FW_OpenADOExcelSheet( cPathcFile, cSheet, cRange, lHeaders )   aStruct := FWAdoStruct( ...
by Jimmy
Wed Aug 09, 2023 2:02 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2610

METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

hi, when try to use "existing" PostgreSQL Table i have Problem with METHOD SavePQQ() it seems to work when use FWPG_ImportFromDBF() to create a "new" SQL Table --- in METHOD SavePQQ() it is "WHERE"   FOR n ...
by Jimmy
Wed Aug 02, 2023 8:29 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 765

Request For TDataRow Example for MariDB

Dear Rao Sir ,

I would request you to provide TDatarow Examples of Maridb to understand Tdatarow. I have tried existing examples which are not working for me.

Please provide the same. Thanks in advance..!

Thanks
Shridhar
by shrifw
Mon Jul 31, 2023 5:40 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Request For TDataRow Example for MariDB
Replies: 4
Views: 271

New FTDN July/Julio (FWH 23.07)

... are placed in FWH\samples and the 64 bits versions are placed at: FWH\dll\webview64\ * New: samples\webview1.prg shows how to use an existing window (or dialog, or control) to create a webview on such window. * New: samples\webview3.prg shows how to place a webview inside a dialog. ...
by Antonio Linares
Thu Jul 27, 2023 6:13 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN July/Julio (FWH 23.07)
Replies: 7
Views: 1079

Re: Graphics Lib for Mod_Harbour

This is great, is there any examples of using this in regular Fivewin for Harbour? I will be utilizing this for Mod_Harbour, but I am pretty sure I could use it in some of my existing applications as well.
by byron.hopp
Thu Jul 20, 2023 7:03 pm
 
Forum: mod_harbour
Topic: Graphics Lib for Mod_Harbour
Replies: 7
Views: 793

Re: XBROWSER ODBC / ADO -> read only ?

hi,
nageswaragunupudi wrote:Using fwh\samples\access.prg, the msaccess database of Read/Write.
We revised access.prg and here it is:

Please copy this program to 32-bit fwh\samples folder overwriting the existing access.prg and build with

Great, thx
by Jimmy
Tue Jul 18, 2023 8:26 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: XBROWSER ODBC / ADO -> read only ?
Replies: 3
Views: 200

Re: XBROWSER ODBC / ADO -> read only ?

... CENTERED   RELEASE FONT oFont   oRs:Close()return nil Please copy this program to 32-bit fwh\samples folder overwriting the existing access.prg and build with buildh access You can write modifications in xbrowse and also xedit()
by nageswaragunupudi
Tue Jul 18, 2023 5:38 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: XBROWSER ODBC / ADO -> read only ?
Replies: 3
Views: 200

Re: pudieron avanzar en ordenacion de un tree?

First, you need to modify the fwh program fwh\source\classes\linklist.prg In this program please replace the existing METHOD Sort() with this revised new method: METHOD Sort( lAsc, lRecurs ) CLASS TLinkList   local oPrev, oNext, n, aItems := {}   local oItem  ...
by nageswaragunupudi
Tue Jul 11, 2023 1:32 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: pudieron avanzar en ordenacion de un tree?
Replies: 11
Views: 667

Re: Create solid color bitmap array

If not, can someone suggest a BMP editor that will allow me to simply change the existing color to the value I need. I have a few tools but none of them want to cooperate. FWH provides the best tool, i.e., the function FW_MakeYourBitmap(...) function ColorBmps()  ...
by nageswaragunupudi
Tue Jul 11, 2023 10:10 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Create solid color bitmap array
Replies: 6
Views: 325

Create solid color bitmap array

... control because I need to show the array values in the dropdown. If not, can someone suggest a BMP editor that will allow me to simply change the existing color to the value I need. I have a few tools but none of them want to cooperate. Thank you.
by TimStone
Tue Jul 11, 2023 4:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Create solid color bitmap array
Replies: 6
Views: 325
PreviousNext

Return to advanced search