Recent content by marge0512

Would this example work for Update as well? That is my next attempt. Thanks!

Got it! Thank you so much!!

Thank you! I noticed something though....when I had my integer fields set as integer in the Variables Editor, the numbers would save as, for example, 45.00 instead of 45.12 in the table. When I changed them to string, it would save as it should. Their type is Number(10, 2) in Oracle. Why would...

I'm finally getting back to work on this project..... Thank you for this info! This really helped and it works. I do have another question though (of course)......does it matter what type the variables are set at in the Variables Editor? To better explain...if a field is set in the Oracle...

Thank you!!! That's what I was doing wrong.....I had .CommitOnPost set to true. As soon as I unchecked that...it worked fine. I do have another question though, before I was directed to use this forum, another forum that was helping me said that I should have .CachedUpdates set to true but...

Thanks for responding! Can I do the same thing with the TOracleDataSet instead of the TOracleQuery and if not, would you mind explaining so I would understand?

Hello, I am using Delphi2010 and TOracleDataSet to access tables in Oracle. My question is how do I insert rows to multiple tables? I was told to use the AppendRecord method. Here is an example: Example of value statements (this has been shortened obviously): Suffix := trim(edSuffx.text)...