FiveTech Software tech support forums

Mr. Rao and friends I apologize, after several nightmare nights, I have finally solved the problem, the problem was in the last line of this code. [code] oRsWrk := FW_OpenRecordSet(oApp:oCon,"SELECT " +; "*," +; "RUB_DES," +; "CON_DES " +; "FROM " +;...

I get this error Error description: (DOS Error -2147352567) WINOLE/1007 [MySQL][ODBC 5.1 Driver][mysqld-5.1.53-community]Undeclared variable: oRsWrk (0x80004005): Microsoft OLE DB Provider for ODBC Drivers Args: [ 1] = C SELECT * INTO oRsWrk FROM oRsDet oRsWrk and oRsDet are RecordSets. You should ...

First please let me know if you built my sample program as it is (without any changes) and tested it? Did it work or not?

Mr. Rao: First of all, thank you very much for your support. Whit this code       oApp:oCon:Execute( "SELECT * INTO oRsWrk FROM oRsDet" )  I get this error Error description: (DOS Error -2147352567) WINOLE/1007 [MySQL][ODBC 5.1 Driver][mysqld-5.1.53-community]Undeclared variable: o...

Ok. This can be done in different ways. Let us now try the 1st method. FWH provides a cloud server for our testing. Let us use this server for our tests. Creating temporary table with data from the permanent table: oCn:Execute( "SELECT * INTO [TBL_TEMP] FROM [TBL_PERM]" ) Copying b...

Mr. Rao:

Yes, I want to copy the records from a non-temporary table and pass them to a temporary table to modify them
and then return them to the non-temporary table

There are 5 records in the non-temporary table and only 2 are passed to the temporary table

Best regards

Do you want to copy all records from one table to another table and display them in XBrowse?

Nothing to worry. You are not alone.
We are always here to support you in ever way.
At times we may take some time to respond.
Pls wait for my next posting

Mr. Rao & Friends: Thanks to your advice, the first problem is solved, but now the problem is when retaking the recorded records and displaying them in an xBrowse, it only shows 2 of 5 records This is my code       IF lCrealo         DO WHILE ! oRsDet:EOF()            oRsWrk:AddNew(&...

Code: Select all  Expand view

TRY
   oRsWrk:UpDate()
CATCH
   ? "Error"
   FW_ShowAdoError( oCn )
END
//   oRsWrk:ReQuery()
 

No need to use ReQuery() after oRs:Update().

Amigos del foro, les cuento: En una aplicación, hay un PRG que me tiene vuelto loco, me explico, con el siguiente código agrego un registro a la tabla, el problema es que todo funciona al 100% pero solo agrega dos registros, si agrego un tercer registro no lo graba :oops: , tengo otros PRGs con la m...

... archivo "tgdiplus.prg" y me hice la misma pregunta, porque esta activándose el método SAVE() de esa clase, si no se esta usando?? Esta raro, raro. Saludos. Carlos.

raro

... Lo unico inconveniente corregi varios archivos de src\codepage y src\codepage ya que cuando corri en proceso parece que le coloco un caracter raro y generaba error al compilar Thanks Enrico I worked. only problem I fixed several files of src\codepage and src\codepage since when I ran in process ...

... esas dbf. No será, que no las puede crear de manera automática o se debería hacer el llamado a un método antes de intentar abrir el archivo. Lo raro es que desde Easy Report como tal, abre sin problemas cualquier reporte que intentemos abrir. Sabes cual es el nombre como tal de las dbfs, para ...