Recent content by jedaworks

My mistake, the WebModuleAfterDispatch method was never being called, therefor the OracleConnection was never being disconnected. Problem was fixed when I diconnected the connection in the Action.onAction event.

Am using session pooling = spInternal on a isapi dll. The oracleConnection is set Connected := true in the "before dispatch" and := false in the "after dispatch" methods. Occassionally, the database connection is dropped (the database server is rebooted and then comes back online. The isapi...

Could you please explain when I should use dataset.close, and when I should use dataset.closeAll? My understanding is if the query changes, use closeAll, if the query is parameterized and is going to be reopened, use close. Is this correct? I have a bunch of existing code that never calls...

Thanks Marco There does not seem to be any way to compress so there are still a certain number of free connections available. Any way to get the system to compress and leave x number of connections available? The way it is now, you either have the "open connections = max number of connections...

Could we get an explanation of how to use internal TOracleSession pooling in an ISAPI dll? Some questions I have are 1) In general how does the TOracleSession pooling work? I've read the help on it, but would like to know some of the internal workings. 2) In an ISAPI dll, should a global...

Has anyone made an inmemory table that can load directly from the TOracleQuery? And wishes to share the code?

I ran into the same problem. I solved it by (I cannot remember which), one of : setting the dataset/query session to nil then reassigning it; or freeing and recreating the dataset. If either of the above solutions do not work, reply here, and I will find the code I used to solve the problem...

Does this mean "CloseAll" should be used whenever a query is not going to be reused, thereby saving resources on the server?

I am using QBE on serveral of my forms, and need to know what part of the query is created by QBE. I need to pass the QBE portion of the query to a report module that runs selects records based on what was selected by the QBE query. I cannot pass in the complete query. Is there some easy way...

Asta has a sample DOA server that comes with their demo.

Has anyone had success using DOA with the Borland Decision Cube components (or any other 3rd party decision cube components)? They do not calculate the correct values when hooked up to DOA, though they seem to work fine when hooked up to Borlands TQuery. The interesting thing is the DOA...

If I call DeclareVariable is it nessicary to call DeleteVariable to recover the memory?

The following test code gets all the records in the database when the button is first clicked. When the button is clicked again, the records that meet the qbe criteria are selected. How can I make the qbe get the correct records on the first click? procedure TfrmEquipment.Button2Click(Sender...

How can I populate qbe fields with data at runtime? I want to do something like dataset.qbeMode := True; dataset.fieldbyName('field').asString := 'AA'; dataset.executeQBE;