Recent content by mwlang

Actually, a TClientDataSet will do the job...Look in the demos\midas folder as I believe there are a few examples that will give you an idea of how to accomplish what you want.

hmmm...what you say makes sense... I guess it all boils down to coding style and philosophy. Since I do all business logic (a.k.a. SQL manipulations) on the server side rather than the client side, I'm passing the variables to the client and the client is only smart enough to populate the...

I don't know about events firing just before a variable's used, but you could write your script per the usual standards.... insert into X values (:var1, :var2); insert into Y values (:var3); Then generate variables from SQL (on the variable dialog of object inspector). Then before calling...

Could you explain what you mean by controlling the variables from the client data set? As far as I can tell, the values applied to parameters on the client side are still being plugged in to the corresponding variables correctly on the server side.

Using D5 and MIDAS, I encountered a problem with D5 that I didn't have with D4. In my AppServer, I have some server side session info that I plug into a variable for a TOracleDataSet's SQL during a provider's OnDataRequest Event that was being cleared out by a call to DeleteVariables in the...

I haven't tried working with BLOBs and CLOBs, but did see a SetComplexVariable in on-line help the other day. Perhaps that is your ticket.

Thanks, that explains it. It would be nice to see this as an addendum to the TOraclePackage documentation in the on-line help.

Marco, I will be sending a sample project to the support e-mail address that demonstrates this problem. If you could take a look at it and let me know the problem, I would appreciate it very much.

What is the DOA equivalent to the BDE TStoredProc component? The closest I found was the TOraclePackage, but our DBA did not put any of our stored procs in a package so I have no idea how to utilize this component with our database as-is.

You have to add RowID to your select clause. Check the on-line help for TOracleDataSet for more information.

I am having trouble with D5 and Midas where the server becomes unresponsive when attempt to open the 2nd Oracle session on the server. I have set up the remote data modules (RDM) to be multi-instance, apartment threaded. I have set up a base RDM on which I have placed an TOracleSession...

It took me a bit to figure that out...I've just gotten too used to the TQuery component auto-generating the Params whenever you type an SQL statement with binding variables in it. With the OracleDataSets, I have learned to make a series of DeclareVariable calls following assigning SQL text to...

Am I missing a step with populating a TOracleDataSet's variables on an AppServer from a TClientDataSet's Params property? The TQuery automatically populated it's Params with whatever was populated in the TClientDataSet, but switching over to the TOracleDataset is complaining that all variables...

That makes perfect sense, now. Unfortunately our budget limits us to Delphi 4 for the time being. If you have any suggestion for how to implement the following with D4 and DOA, your suggestions would be much appreciated: How to store additional Field Properties on the App Server (such as...

All the documentation I've encountered about Midas support and the Provider info says that DOA supports the TDatasetProvider in Delphi 5. Although I can't exactly tell, it also appears to state that TOracleProvider should be used in D4, but not for D5. We use D4 and I am trying to see what's...