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...

... "C:\Users\alerc\AppData\Local\Temp\pip-build-env-k67z_tif\overlay\Lib\site-packages\setuptools\build_meta.py", line 480, in run_setup super(_BuildMetaLegacyBackend, self).run_setup(setup_script=setup_script) File "C:\Users\alerc\AppData\Local\Temp\pip-build-env-k67z_tif\overlay\Lib\site-packages\setuptools\build_meta.py", ...

... have to check the forum regularly yourself, just activate the forum notifications. It's clear, we are now all experienced FIVEWINNERS, FIVEWIN is super stable, and the standard situations are solved. But for those of us who don't just want to coast into retirement, there's a need for future topics ...

... You stop checking the forum regularly. It's actually the beginning of the end. It's clear, we are now all experienced FIVEWINNERS, FIVEWIN is super stable, and the standard situations are solved. But for those of us who don't just want to coast into retirement, there's a need for future topics ...

... hahahahaha. I asked for a PRACTICAL EXAMPLE with Fonte(.PRG) where you use this subclass model that you post. There is no way to fool the biggest super power of FIVEWIN BRASIL. hahahahahahaha. ¡¡Maestro Otto, maestro Otto!! ¿Estás tratando de engañarme? jajajajaja. Pedí un EJEMPLO PRÁCTICO con ...