FiveTech Software tech support forums

Auguri
Maurizio

? oCn:TableExists( "worksheet", "mastronipe", @cType )
Return .t.

? cType
Return BASE TABLE

Rao ,

::cError = "Table 'mastronipe.worksheet' doesn't exist"

but the table exists


03/07/25 09:21:44: FWMARIACONNECTION:EXECUTE_SQL( 6791 )
cCallStack( "<-", 3 ) = "FWMARIACONNECTION:EXECUTE( 7163 )
<-FWMARIACONNECTION:BACKUPTABLE( 9752 )
<-FWMARIACONNECTION:BACKUP( 9652 )
<-COPIA_1( 239 ...

Ciao RAO

happy to hear from you again.

No, I didn't explain myself well, I copy the entire database not individual tables .
oCn:Backup( cDataBase , cDest )

or
oCn:Backup( cDataBase , cDest ,bAction )

Maurizio

Hello,
I use the FwMaria backup program (vers.August-September 2024)

oCn:BackUp(cTable, cDestina )

With some databases this error occurs:
Stack Calls
===========
Called from: backupsql.prg => AEVAL( 0 )
Called from: .\source\internal\fwmaria.prg => FWMARIACONNECTION:BACKUPTABLE( 9754 )
Called ...

Our best wishes for a speedy recovery.
Maurizio

Ciao Otto
in the Harbour doc folder there is this file
xhb-diff.txt
Maurizio

Happy birthday Antonio

Maurizio

Hello Duch ,
I started from

C:\harbour\contrib\hbhttpd

Maurizio

Thanks RAO ,

? cLocate := oCn:ExprnDBF( "HIREDATE = ?", { DATE() } )
oRs:locate( cLocate )

This code works , where oCn is the connection and oRs is the recordset

but
? cFilter := oCn:ExprnDBF( "STATE = ? .AND. AGE >= ?", { "NY", 45 } )

where is the recordset ?

Maurizio

Thanks Vilian
it works correctly
Maurizio

Hello Rao ,
in a select when I search for a date I use
SELECT * FROM customer WHERE HIREDATE= " +DTOS(DATE())

How do I use the date search with locate?
I tried
cLocate := " HIREDATE = '" + DTOS(DATE()) + "'"

But I have this error

Error occurred at: 10/21/24, 10:57:32
Error description: Error ...

RAO
I tested with xHarobour 32 bits, Harbour bcc32, msvc32
with FWH2409 and FWH2307
All worked the same way without any problems.

as I said I have FW 24.07 (August 2024 purchased on 11.09.24) and the problem is there.
Before purchasing a new FW 24.09 version I would like to be sure it works ...

karinha
Thanks for the help but
You definitely don't use August 2024

Maurizo

Hello Rao ,


https://drive.google.com/file/d/1ZUATcFLR1x38sMbAvowTpt1dMGeidZeF/view?usp=sharing

if you use the PRG of Enrico's you have to change this line

// cSchema := 'FoglioStileAssoSoftware.xsl'
cSchema := 'http:\\www.nipeservice.it\FS\FoglioStile.xsl'

and

cFile := 'FATTURA.xml ...