FiveTech Software tech support forums

... it only loads about 100,000 records, is it possible that the BackUp has a clause (WHEN) to condition the process?, as well as: BackUp( [source], [dest], [bProgress], [cCondition], [nRecsInBatch], [nMaxBufperSQL] ) where cCondition := "WHERE year(fecha_doc) > 2023", something like ...

... it only loads about 100,000 records, is it possible that the BackUp has a clause (WHEN) to condition the process?, as well as: BackUp( [source], [dest], [bProgress], [cCondition], [nRecsInBatch], [nMaxBufperSQL] ) where cCondition := "WHERE year(fecha_doc) > 2023", something like ...

... Act="C" > <Orig Type="POL" Code="SGSIN" Departs="2019-06-28T06:00:00" /> <Dest Type="POD" Code="PHDVO" Arrives="2019-07-05T08:00:00" />

... Act="C"> <Orig Type="POL" Code="SGSIN" Departs="2019-06-28T06:00:00"/> <Dest Type="POD" Code="PHDVO" Arrives="2019-07-05T08:00:00"/> </Sch> <Sch Id="8528968ce125968263df42d67c05e57a" ...

Marc Vanzegbroeck wrote:Hi,

To know the last inserted ID, you could do

oQry=oSQL:execute("SELECT LAST_INSERT_ID() AS lastinsert")
msginfo(oQry:fields(0):value)

It is a lot simpler with FWMARIADB.
Simply

Code: Select all  Expand view

? oCn:InsertID()
 

Hi,

To know the last inserted ID, you could do

oQry=oSQL:execute("SELECT LAST_INSERT_ID() AS lastinsert")
msginfo(oQry:fields(0):value)

This is made even much simpler in the next version (17.12)

Code: Select all  Expand view

oRs:GoTo( n )
aRow := oRs:CopyRec()
oRs:Append( aRow )
 

The code I posted removes ID field.
Please try my code exactly without changes

Dear Mr.Rao, Please see this example   oRs   := oCn:RowSet( "customer" )   oRs:Goto( 10 )  // we want to copy this rec and append   aRow  := oRs:CopyRec()   ADel( aRow, 1, .t. ) // ID field. We need to remove it   oRs:Append( aRow )   oRs:Edit(&#...

Dear Mr.Rao,

Thanks you so much. I will try.

Regards,
Dutch

I have a question. aFields := oCn:TableStructure(tablename) -> arrayaRows  := oCn:QueryResult('select * from '+tablename) -> array  Is it returning same structure and sequence? Yes Please see this example   oRs   := oCn:RowSet( "customer" )  &n...

Dear Master, My purpose is to write some data in a new records after ::copytable(). Example ========== I need to copy the hotel reservation of a guest and change some data in a new record such as New Arrival date, New Departure date for next arrival period. How can I search or filter the new record....

Let us consider this: aRow := oCn:QueryResult('select * from '+cTable+' where '+cWhere )oCn:Insert( cTable, nil, aRow )  I understand you are reading one or more rows from a source table and trying to insert into a destination table and also that both tables have the same struct...

Dear Master,

I try to copy from one to another by

Code: Select all  Expand view

oCn:CopyTable('orgTable','desTable', , ,'id=1')

Code: Select all  Expand view

aRow := oCn:QueryResult('select * from '+cTable+' where '+cWhere )
oCn:Insert( cTable, nil, aRow )
 

How do I know the 'id' of destination record?

Thanks in advance.
Dutch

... us to use it as WHERE clause expression so we will end with the same speed problem. The only way out is to have a hb_adorddcopyto( origin file, dest file, where clause ). Here its very fast because its pure SQl treated as above. But I dont know if it is worth while to build such function because ...