Recent content by purpledawn

Thanks, that works perfectly.

Thanks for your reply. I did think of a more nuclear approach (I was thinking update SQL, but I guess you mean update the value of the Field object on the Dataset, or something like that, which is better), but I wanted to see if there was a work-around for the Combobox. Thanks again, I'll give...

I am having troubles posting a value to a database from a DBLookupCombobox that has been updated at runtime. If the value is set normally by the user selecting a value from the list in the combo box, the value posts OK. If I set the KeyValue property at runtime (to a value that is in the...

Hello, I updated my system, and migrated to Delphi 7 from Delphi 5. Since these changes, I get an Oracle error in my application when posting to the database, 'ORA-01410 Invalid ROWID...'. I am using BDE objects in the application. If I change the DLL32 property for the native Oracle Driver...

Thanks again for your help.

The NVL solution gives Field1 Field2 ------ ------ A 1 and the CASE solution gives Field1 Field2 ------ ------ A 1 B 0 C 0 .

Thank-you for all your replies. As r037 sort of pointed out, my problem is not so much trying to count null records, as it is that I am trying to count some records that are excluded by the conditional statement, or that don't exist at all. The best suggestion I have received for this problem...

Thank you for your reply. I have tried nvl already, and it doesn't work. In my real table, field2 is actually a date field, but nvl(field2,'') and nvl(field2,null) both do not work either. Any more suggestions?

The issue I am having is with Oracle, and I think that it applies to ANSI SQL too. Please excuse me for not taking the time to do that research. I have a table as follows Field1 Field2 ------ ------ A 1 A 4 B [null] B [null] C [null] I am writing a...

I am running Tomcat 4.1.27 with Apache 2.0.47, using the jk2 2.0.43 connector and j2sdk 1.4.2 I connected Tomcat to Apache using the instructions at http://www.gregoire.org/howto/Apache2_Jk2_TC4.1.x_JSDK1.4.x.html I can open localhost/examples/servlet/HelloWorldExample If I move...

Thank-you so much. That makes it work perfectly. I hope you find work soon!

I have an access appliation where the user will run a query, and the results of the query will be displayed to them using an Excel file. A macro writes the saved query to an Excel file, using the OutputTo action. A sub writes additional metadata to cells in the Excel file, and does some minor...

I have tried to work around this by starting the service using the apache.exe in command line, which produces no messages, but neither does it start the service. I get the same result when I try to start the service from the Progams menu. I have searched on Google for parts of the error...

I have installed Apache 2.0.47 on Windows 2000 Server. The machine doesn't have a server name registered to the internet (it is a development server), but I can ping it from another computer. After installation, the Apache2 service has not started, and I chose the option to install Apache as a...

Thank-you DJS2, turns out you were right after all. As I see it, it is SQL in Access that has problems with date formats; SQL statements need dates in U.S. format. Dates were being entered OK, just SQL was interpreting inconsistently. Thanks again for your help.