Search results for query: *

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...

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...

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...

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...

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...

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...

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

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...

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...

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