Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. knechod

    Access Database file keeps corrupting?

    This message is only relevant because it started with the same error message. The environment was Access 2002/2003. The user saw the message: "This database is in an unexpected state;Microsoft Access can't open it. This database has been converted from a prior version of microsoft Access by...
  2. knechod

    Form/Subform with One-to-one relationship is read-only?

    Here's an interesting bit of information. I had the properties window up while looking at the subform, and I noticed that AllowAdditions, AllowEdits, and AllowDeletions were all set to False. However, when I look at the subform directly, they are all set True. Somewhere, somehow, something is...
  3. knechod

    Form/Subform with One-to-one relationship is read-only?

    I am working with Access 2003, with tables linked to an Oracle database. I have a main table, and a child table with a one-to-one relationship with the parent. Parent: RecPK: Primary Key Child: RecID: Primary Key, Foreign Key to Parent.RecPK The main form is using a Tab Control, and one of...
  4. knechod

    Control multiple copies of forms

    I am running Access 2003. I have a single form that I need to open several times. Some of the time, it is to inspect a record. Other times, it is to add a new record. I have built the collection that manages the open forms, and I use the New keyword to instantiate each one. But calling New...
  5. knechod

    Passing a query to a cffunction via a cfform

    You are right, no complex datatypes can be sent this way. You could use <CFWDDX> if you ABSOLUTELY HAVE to do it this way. However, if you are trying to persist this query across form submissions, then copy it to the session scope, assuming that you have session management set up. <cfset...
  6. knechod

    HTTP Header being displayed

    What version of CF are you using? I have seen something similar, where doing a CFLocation sends out header information. I was using <CFHTMLHEAD> in the Application.cfm file, and in some situations, the output was not completely flushed, and header junk was prepended to page jumped to. So...
  7. knechod

    jdbc - data source error

    If by Service Pack 4, you mean MX 6.1 (Redsky), then I had a problem when I did the upgrade, where it removed the backslashes from my Class Path defined in the Administrator. Just a thought. Kevin
  8. knechod

    Storage of bit flags

    I guess I muddied the waters, here. I'm not looking to violate atomicity. In SQL Server, it has its own datatype. Physically, the DB did the packing and unpacking. I'm trying to figure out about space usage when I don't have that option available. If I use NUMBER(1), does it store one byte...
  9. knechod

    Storage of bit flags

    From my SQL Server days, I was able to create bit flags. It would pack 8 to a byte. Now, I am looking to do similar things in Oracle, and there is no BIT/Boolean type. OK, no sweat. I build a number(1) field. But what are the storage and/or performance ramifications of doing that versus...
  10. knechod

    CASE or DECODE with ORDER BY

    ORDER BY CASE WHEN v_OrderBy = 'Col1' THEN 1 WHEN v_OrderBy = 'Col2' THEN 2 ELSE 3 END DESC DECODE is fine, but it's non-standard SQL. Kevin

Part and Inventory Search

Back
Top