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.
Search found 837 matches
- Wed Dec 23, 2015 2:16 pm
- Forum: FiveWin for Harbour/xHarbour
- Topic: Refresh Record Set
- Replies: 10
- Views: 1946
- 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!
- 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...
- 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 ?
- 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...
- 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 ...
- 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 ...
- 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...
- 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...
- 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...
- 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
- 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...
- 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...
- 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?
Está trabalhando ok?
- 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!
Thanks Done!