Search found 837 matches

by AHF
Wed Dec 23, 2015 2:16 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Refresh Record Set
Replies: 10
Views: 1946

Re: Refresh Record Set

If you create a new recordset to edit the record better is to clone ex oRsNew := oRs:Clone and then you need to do nothing ADO will keep both synchronized (with same data) till you issue again :requery on the original.
Please remember that you will need to close both sets.
by AHF
Wed Dec 23, 2015 2:11 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Merry Christmas
Replies: 15
Views: 2680

Re: Merry Christmas

Merry Christmas to all!
by AHF
Wed Dec 23, 2015 2:08 pm
Forum: FiveWin para Harbour/xHarbour
Topic: ADORDD. Set Filter. Muy lento.
Replies: 4
Views: 952

Re: ADORDD. Set Filter. Muy lento.

Rafa, Google translator: Primera meta de ADORDD es aplicaciones dbf portuarias a SQL como tey son. SET FILTER es obligatorio para lograrlo. Existen situación en la que los filtros no se pueden traducir a SQL declaraciones ex SET fFILTER TO MyFunc () por lo que deben trabajar como rdd dbf. El ADO_SKI...
by AHF
Tue Dec 22, 2015 2:59 pm
Forum: FiveWin for Harbour/xHarbour
Topic: UTF-8
Replies: 5
Views: 725

Re: UTF-8

Did you try hb_translate ?
by AHF
Fri Dec 11, 2015 11:18 am
Forum: FiveWin para Harbour/xHarbour
Topic: Comenzar con SQL
Replies: 5
Views: 810

Re: Comenzar con SQL

Google translator: Si desea convertir las aplicaciones que utilizan DBF to SQL: ADS SQLRDD ADORDD ADORDD es el que garantiza el 100% de compatibilidad con el código de su aplicación. No es necesario cambiar una sola línea de código y DBF desde cargado a SQL en cuestión de minutos. Usando RDD puede c...
by AHF
Tue Dec 08, 2015 3:15 pm
Forum: FiveWin para Harbour/xHarbour
Topic: Nuevo ADORDD
Replies: 55
Views: 15363

Re: Nuevo ADORDD

New build adordd ver 1.0 at https://github.com/AHFERREIRA/adordd.git Corrected new Bugs due to changes previous build: 1) ADO_SQLSTRU with firebird numeric fields precision fieldlen was wrong 2) ADO_FIELDSTRUCT integers doesnt take any extra position. 3) ADO_PUTVALUE trim spaces to check data width ...
by AHF
Tue Dec 08, 2015 3:14 pm
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1030
Views: 137899

Re: ADO RDD xHarbour

New build adordd ver 1.0 at https://github.com/AHFERREIRA/adordd.git Corrected new Bugs due to changes previous build: 1) ADO_SQLSTRU with firebird numeric fields precision fieldlen was wrong 2) ADO_FIELDSTRUCT integers doesnt take any extra position. 3) ADO_PUTVALUE trim spaces to check data width ...
by AHF
Mon Dec 07, 2015 12:57 pm
Forum: FiveWin para Harbour/xHarbour
Topic: Nuevo ADORDD
Replies: 55
Views: 15363

Re: Nuevo ADORDD

New build adordd ver 1.0 at https://github.com/AHFERREIRA/adordd.git New: 1) SET ADODBF INDEX LIST FIELDTYPE NUMBER TO {{ "Table",{ "numfiled", nlen },{"numfield", nLen } } } adordd need a precise indication of the len of numeric fields used in index expressions. This i...
by AHF
Mon Dec 07, 2015 12:56 pm
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1030
Views: 137899

Re: ADO RDD xHarbour

New build adordd ver 1.0 at https://github.com/AHFERREIRA/adordd.git New: 1) SET ADODBF INDEX LIST FIELDTYPE NUMBER TO {{ "Table",{ "numfiled", nlen },{"numfield", nLen } } } adordd need a precise indication of the len of numeric fields used in index expressions. This i...
by AHF
Mon Dec 07, 2015 12:30 pm
Forum: FiveWin for Harbour/xHarbour
Topic: ADORDD FAQs
Replies: 87
Views: 20462

Re: ADORDD FAQs

In SET ADO FIELDRECNO TABLES LIST TO what table name must a put here? The dbf table name or the table name built by adordd with path. Solution: In all adordd SETs where you place a table name its always the table name used by former rdd (adsrdd, dbfcdx ,ect) adordd will make all necessary conversio...
by AHF
Fri Dec 04, 2015 8:41 am
Forum: FiveWin para Harbour/xHarbour
Topic: O.T: Pequeño problema con una sentencia SQL
Replies: 4
Views: 628

Re: O.T: Pequeño problema con una sentencia SQL

Try this:

Code: Select all

SELECT name,  nacimiento,  saneamiento,  notas,  id ;
FROM   device AS cer INNER JOIN dev ON  user_device =dev.device AND cer.id = dev.userId ;
WHERE  cer.id = "1" LIMIT 0, 25 

 
by AHF
Thu Dec 03, 2015 5:26 pm
Forum: FiveWin for Harbour/xHarbour
Topic: ADORDD FAQs
Replies: 87
Views: 20462

Re: ADORDD FAQs

Table structure its not exactly the same as in DBF mainly numeric fields. I uploaded tables with FW_AdoImportFromDBF Solution: If field sizes are not exactly the same as in the DBfs this brings problems in adordd code and does not allow proper working ex. index expressions. You must upload your tab...
by AHF
Thu Dec 03, 2015 8:46 am
Forum: FiveWin for Harbour/xHarbour
Topic: ADORDD FAQs
Replies: 87
Views: 20462

Re: ADORDD FAQs

I cant seek case sensitive strings! Is it a bug? So must I SET ADO UDFS when I use UPPER or LOWER in index expression? Solution: It seems as far as I know that ADO :find used for dbseek by ADORDD its not case sensitive. I don't know if it is DB engine limitation or ADO itself. It seems to be ADO. S...
by AHF
Mon Nov 30, 2015 1:44 pm
Forum: FiveWin para Harbour/xHarbour
Topic: Ejemplo ADORDD solo SQL
Replies: 10
Views: 1850

Re: Ejemplo ADORDD solo SQL

Ruben,

Está trabalhando ok?
by AHF
Mon Nov 30, 2015 9:34 am
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1030
Views: 137899

Re: ADO RDD xHarbour

Gunther,

Thanks Done!