Search found 48 matches: hbrecno

Return to advanced search

Re: ADO RDD xHarbour

... at https://github.com/AHFERREIRA/adordd.git Performance enhancement opening tables. SET RECORDSET OPEN WHERE CLAUSE TO {{"MYTABLE","HBRECNO < 51000" },; {"MYTABLE2","HBRECNO BETWEEN 1 AND 50000" }} This SET together ADOWHERECLAUSE( nWa, cNewSql ) enable ...
by AHF
Wed Apr 12, 2017 10:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441923

Re: ADORDD FAQs

Buenos días Antonio (AHF)
Al principio me dio error porque el al activar SET HBRECNO puse 'id' en minúsculas, al poner "ID" en mayúsculas desapareció el error
SET ADO DEFAULT RECNO FIELD TO "id"

y luego active HBDELETED (como pone en el manual) :oops: y ya funcionó
by gautxori
Fri Apr 22, 2016 6:03 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADORDD FAQs
Replies: 87
Views: 19523

Re: ADO RDD xHarbour

Gunther,

Strange here its ok
Is the field HBRECNO in the table ?

What is your SET ADO CACHESIZE TO... ?
by AHF
Tue Oct 20, 2015 2:55 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441923

Re: ADO RDD xHarbour

... there are a error with ACCESS!!! Error description: Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: OPEN Args: [ 1] = C SELECT * FROM TABLE1 ORDER BY HBRECNO [ 2] = O ADODB.Connection [ 3] = N 2 [ 4] = N 3 [ 5] = N 0 Stack Calls =========== Called from: => TOLEAUTO:OPEN( 0 ) Called from: C:\adordd\adordd.prg ...
by byte-one
Tue Oct 20, 2015 2:39 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441923

Re: ADO RDD xHarbour

... with Access i read this error: Error description: Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: OPEN Args: [ 1] = C SELECT * FROM TABLE1 ORDER BY HBRECNO [ 2] = O ADODB.Connection [ 3] = N 2 [ 4] = N 3 [ 5] = N 0 Stack Calls =========== Called from: => TOLEAUTO:OPEN( 0 ) Called from: C:\adordd\adordd.prg ...
by byte-one
Tue Oct 20, 2015 12:20 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441923

Re: ADO RDD xHarbour

... at: 09/24/15, 15:00:39 Error description: Error ADODB.Connection/0 S_OK: EXECUTE Args: [ 1] = C UPDATE CUSTOMER SET FIRST = 'Test'Pieter' WHERE HBRECNO = 520 Stack Calls =========== Called from: => TOLEAUTO:EXECUTE( 0 ) Called from: adordd.prg => ADO_PUTVALUE( 1532 ) Called from: learn-database.prg ...
by pieter
Thu Sep 24, 2015 1:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441923

Re: ADO RDD xHarbour

... at: 09/24/15, 13:46:41 Error description: Error ADODB.Connection/0 S_OK: EXECUTE Args: [ 1] = C UPDATE CUSTOMER SET FIRST = 'Test'Pieter' WHERE HBRECNO = 516 Stack Calls =========== Called from: => TOLEAUTO:EXECUTE( 0 ) Called from: adordd.prg => ADO_PUTVALUE( 1532 ) Called from: learn-database.prg ...
by pieter
Thu Sep 24, 2015 12:00 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441923

Re: DBF to SQL converter program

... database (instead of the FW ADO function) to avoid getting the ID field. It does seem redundant to be getting two auto-increment fields (ID and HBRECNO) in tables created by the ADORDD. However, the HBRECNO should start at 1 and the ID field could start at any number so maybe they both could ...
by nageswaragunupudi
Tue Aug 25, 2015 5:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 17901

Re: DBF to SQL converter program

... database (instead of the FW ADO function) to avoid getting the ID field. It does seem redundant to be getting two auto-increment fields (ID and HBRECNO) in tables created by the ADORDD. However, the HBRECNO should start at 1 and the ID field could start at any number so maybe they both could ...
by James Bott
Tue Aug 25, 2015 3:57 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 17901

Re: DBF to SQL converter program

... it is my understanding that SQL automatically creates the ID field for any new table (but I'm a not sure). And the ADORDD automatically ads the HBRECNO field when it creates a table, so you have two new fields (both auto-incrementing). I believe you can use any auto-incrementing field instead ...
by James Bott
Tue Aug 25, 2015 2:16 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 17901

Re: DBF to SQL converter program

James, The sql tables have "ID" as first columnname(so it does not automaticly is changed to HBRECNO), I think it is not so difficult to change this to HBRECNO (Just a sql query). Is it true that hbrecno name has something to do with Adordd?, With the Dbf to Sql ...
by pieter
Tue Aug 25, 2015 7:17 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 17901

Re: DBF to SQL converter program

Pieter,

...the DBF TO SQL Converter works well.


Glad to hear that. Does it automatically add the HBRECNO field also?

James
by James Bott
Mon Aug 24, 2015 4:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 17901

Re: DBF to SQL converter program

James, Pieter, You also are going to need the "standard" HBRECNO auto-increment field so the tables work with ADORDD. Maybe you can specify a different auto-increment fieldname other than ID. You can work with ADORDD with any field name you want ...
by AHF
Thu Aug 13, 2015 3:53 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 17901

Re: ADO RDD xHarbour

James, Yes, I did a COPY TO a dbf, then built the SQL table from the structure of the DBF (and I did know that the HBRECNO field would be added automatically). Then I did an APPEND FROM the dbf. Fairly simple now that I have the code written. I forgot to mention that you can do ...
by AHF
Wed Aug 12, 2015 4:48 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441923

Re: ADO RDD xHarbour

Antonio F, Yes, I did a COPY TO a dbf, then built the SQL table from the structure of the DBF (and I did know that the HBRECNO field would be added automatically). Then I did an APPEND FROM the dbf. Fairly simple now that I have the code written. I am wondering about these two lists: ...
by James Bott
Thu Aug 06, 2015 7:00 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441923
Next

Return to advanced search