miguelsanchez Posted October 8, 2007 Share Posted October 8, 2007 Hi all!! How to execute in Oracle INSERTs or UPTATEs? Thanks, Miguel. Link to comment Share on other sites More sharing options...
ptrex Posted October 9, 2007 Share Posted October 9, 2007 @miguelsanchezMaybe you can use the EXECUTE command ADO Executeregards,ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
miguelsanchez Posted October 9, 2007 Author Share Posted October 9, 2007 $sql = "update prestamo set prestamo.centro = '" & $id_centro_destino & "' where prestamo.id_agenda = '" & $id_agenda & "'" _update($sql) Func _update($sql) $adors = ObjCreate( "ADODB.RecordSet" ) With $adors .ActiveConnection = $ado .Execute = $sql .Open EndWith $adors.Close Return EndFunc Error??? >Running:(3.2.9.0):C:\Archivos de programa\AutoIt3\beta\autoit3.exe "C:\Scripts\Cambiar de Centro una Agenda\Cambiar Centro - Agenda.au3" C:\Scripts\Cambiar de Centro una Agenda\Cambiar Centro - Agenda.au3 (230) : ==> The requested action with this object has failed.: .Execute = $sql .Execute = $sql^ ERROR ->AutoIT3.exe ended.rc:1 >Exit code: 1 Time: 13.002 Link to comment Share on other sites More sharing options...
jvanegmond Posted October 9, 2007 Share Posted October 9, 2007 $sql = "update prestamo set prestamo.centro = '" & $id_centro_destino & "' where prestamo.id_agenda = '" & $id_agenda & "'" _update($sql) Func _update($sql) $adors = ObjCreate( "ADODB.RecordSet" ) With $adors .ActiveConnection = $ado .Execute( RecordsAffected, Parameters, Options ) .Open EndWith $adors.Close Return EndFunc \\ github.com/jvanegmond Link to comment Share on other sites More sharing options...
miguelsanchez Posted October 9, 2007 Author Share Posted October 9, 2007 .Execute( RecordsAffected, Parameters, Options ) Any example please?? Link to comment Share on other sites More sharing options...
ptrex Posted October 9, 2007 Share Posted October 9, 2007 @ Parameters and Option are these for example Global Const $adOpenDynamic = 2 Global Const $adOpenStatic = 3 Global Const $adLockReadOnly =1 Global Const $adLockPessimistic = 2 Global Const $adLockOptimistic = 3 Global Const $adLockBatchOptimistic = 4 Global Const $adUseClient = 3 Global Const $adSchemaTables = 20oÝ÷ Ù8b²+!£³)ík!¢é]m殶sdgVæ2öFõWFFU&V6÷&Bb33c¶EF&ÆRÂb33c¶D6öÂÂb33c¶EVW'Âb33c¶F46öÂÂb33c¶DFF b33c¶EVW'Ò6"3fײb33c¶EVW'fײ6"3 b4ö&¢b33c¶ôDòÒFVâ&WGW&â6WDW'&÷" b33c¶õ&V2ÒöFô÷Vå&V6÷&G6WB´ö&¤7&VFRgV÷C´DôD"å&V6÷&G6WBgV÷C² b4ö&¢b33c¶õ&V2ÒFVâ&WGW&â6WDW'&÷"" b33c¶õ&V2ä7W'6÷$Æö6FöâÒb33c¶EW6T6ÆVç@ b33c¶õ&V2ä÷VâgV÷CµUDDRgV÷C²fײb33c¶EF&ÆRfײgV÷C²4UBgV÷C²fײb33c¶EF&ÆRfײgV÷C²å²gV÷C²fײb33c¶F46öÂfײgV÷CµÒÒb33²gV÷C²fײb33c¶DFFfײgV÷C²b33²tU$RgV÷C²fײb33c¶EF&ÆRfײgV÷C²å²gV÷C²fײb33c¶D6öÂfײgV÷CµÒÒgV÷C²fײb33c¶EVW'fײgV÷C²gV÷C²Âb33c¶ôDòÂb33c¶D÷Vå7FF2Âb33c¶DÆö6´÷FÖ7F2 bW'&÷"ÒFVà VÇ6P &WGW&â6WDW'&÷"2Ãà VæD`¤VæDgVæ2²fÇC³ÓÓÒfwC²öFõWFFU&V6÷&B regards, ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now