TOAD

[foviedo]

Does anyone know how to enter data into the database using TOAD?
because it is blocked and will not let me enter data directly

 

[DBohner-(db)]

Fov,

When you figure out how to do it - I raise a flag and suggest you reconsider....

E1 does a lot of validation on the Apps and UBE side - before it, generally, inserts/updates the record. That validation goes against UDCs, Data Definitions and Additional Setup.

Inserting through either SQL or Toad has caused numerous clients - days to resolve... Just make sure you know your data! I can share a story - but it took weeks to resolve (every time we fixed the data, the user would update through TOAD, again)....

You might scan the TOAD Wiki:
http://www.asktoad.com/DWiki/doku.php/faq/answers/general

Things to consider:
* Insert is only for Empty Tables?
* Append is for tables with Data Already in them
* Unicode Conversion may be an issue with the use of TOAD

YMMV

(db)

 

[foviedo]

thank you for the reply.
is just to test a new application that requires data.