Form prompt trouble

[hpmsnell]

The application uses odbc-linked tables from an oracle back-end. By feeding
a member identifier through a form the user is able to query and see medical
and pharma historical claims (very large tables) and the return is almost
instantaneous.

The problem I'm having now is that the form fed prompts are hanging until
they time out by the 60 second time out default, and 60 seconds is way too
long for these queries to be acceptable. When I feed the raw memberid on the
criterion row, the query runs fine. If fed through a form
[Forms]![myform]![myobject].[value] prompt or a [Enter MemberID] prompt, it
hangs.

The peasants have taken up pitchforks and torch and are calling for blood.
Any help would be greatly appreciated.

-hpmsnell

 

[aaron.kempf]

Oracle is not a real database. It has lost the enterprise war-- it is
not acceptable for performance and affordability and usability and
interactivity reasons.

Sorry

Move to SQL Server. With SQL / ADP you don't need to scan fact
tables; hold them all in memory and then use chipmunks to sort through
the data.

-Aaron

 

[BruceM]

Ignore Aaron. He'll go away eventually.

 

[aaron.kempf]

Ignore Bruce;

he only plays with baby-sized databases

-Aaron

Ignore Aaron.  He'll go away eventually.

The application uses odbc-linked tables from an oracle back-end.  By
feeding
a member identifier through a form the user is able to query and see
medical
and pharma historical claims (very large tables) and the return is almost
instantaneous.

The problem I'm having now is that the form fed prompts are hanging until
they time out by the 60 second time out default, and 60 seconds is way too
long for these queries to be acceptable.  When I feed the raw memberidon
the
criterion row, the query runs fine.  If fed through a form
[Forms]![myform]![myobject].[value] prompt  or a [Enter MemberID] prompt,
it
hangs.

The peasants have taken up pitchforks and torch and are calling for blood.
Any help would be greatly appreciated.

-hpmsnell- Hide quoted text -

- Show quoted text -

 

[Ed Ferrero]

Sounds like it might be a Type conversion problem. Try using;

CLng([Forms]![myform]![myobject].[Text])

Ed Ferrero