Search results for query: *

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.

DJS2 - Thanks for your reply. I've found that if the day is greater than 12, then Access will query using the Latin American date format, if the Regional Setting is for a Spanish Latin American country. ie inputing 1/1/2001 and 17/3/2001 will query between Jan 1 and Mar 17, without having to...

I am creating a form for inputs for a query to create a report. 2 of the boxes are unbound and will have dates entered in them, specifying a range. The users are Spanish and so will enter dates in dd/mm/yyyy format. I have changed the Windows regional settings to one where this date format is...

Thanks for all your help. Turns out subject I needed help with that was missing was DAO; it seems all DAO and ADO object references have been eliminated from the VBA help in Access. Somehow they were there in previous installations, but after reformating they have mysteriously disappeared...

I am having problems with accessing the Access Help and VBA Help files. Many of the results from doing a search are dead links. The topics I need help with are all inacessible ( Recordset, querydef,etc.) I have uninstalled Access and the VB help, rebooted, reinstalled Access and VB help and...

Can anyone help me with confirming that an entry in an textbox is an integer and not a float. I can confirm that it is numeric, using IsNumeric, but I am stuck with verifying that its an integer entry. Thanks.