Recent content by d4jaj1

Hello, Using Oracle SQL Worksheet, I can perform this code as a single transaction: CREATE USER "TEST" IDENTIFIED BY "FTP" DEFAULT TABLESPACE "USR"; GRANT "CONNECT" TO "MEEE" When I attempt to use this in a DOA 3.4.3 TOracleQuery, I get an invalid character due to the semi-colon. How do I...

Hello, I'm using an OracleQuery in an Midas app to Update records with a standard SQL string at runtime: sql.add('UPDATE DTAESYS.EXAMS SET PAID = ''Y'', PAID_DATE = TO_DATE(' + DATETOSTR(DATE) + ', ''MM/DD/YYYY'') WHERE INVOICE_NUMBER= ' +...

Yea, I had a question about this too. So basically, if you aren't using Oracle 8i (we're using 8.05), connection pooling isn't an option? Correct?

Hello, I have retrieved a bunch of record from an Oracle query I need to locate a specific record by on field and retrieve the value of another field in the same record. If I was using the OracleDataset component I could use the standard Dataset.Locate function. Is there an equivalent method...

Hello, I'm trying to use the CommandText feature of a ClientDataset to temporarly override the SQL code on my application server. On the App server, I have a OracleDataset with 2 Variables attached to a DataSetProvider. The datasetprovider's commandtext option is set to true. On the...

Hello, I'm trying to convert some code I was using as part of an OracleDataset to OracleQuery for performance reasons. How do I correctly convert this code to the OracleQuery version? FOR j := ...etc.... if AnsiCompareText(trim(uploadasheets.fields[j + 7].value), trim(GetAnswerKey.Fields[j +...

Hello, For simple seaching of data (e.g., SELECT Statements), which is faster : TOracleDataSet or TOracleQuery? Is there really any performance difference between the two - assuming the same select statement is used? Thanks

Hello, I'm still fairly new to DOA 3.3.3 and all of its features. I have two questions regarding the OracleQuery Component and Transactions. The code below sits on an App server and processes (creates) invoices for all exams that have not already been invoiced. In short, it * Finds all...

Okay, I figured out what I was doing wrong. I placed the code on the DCOM's AfterConnect event instead of the logon. I thought AfterConnect occured after teh UserName & Password were verified and teh database opened. I now know (I think) it only referes to to connecting to the remote data...

Hello, I'm very new to DOA and I'm trying to create a custom login screen for my client application and can't seem to get it to work properly. To make this explanation easier, I'm using the 3-tier demo provided in the DOA installation. Basically, all I did was add another form with 2 edit...

Well, that must have been it, though I was sure I was entering them correctly. I t works fine now and I feel like an idiot now. Sorry to waste your time.

Hello, I'm new to DOA (and Oracle for that matter), so this may seem like a stupid question but.... For some reason, I'm having a really hard time setting the Connected property of the OracleSession component to True at Design-Time. My first attempts all ended with Access Violations on ORA805...