Search results for query: *

Date field for a database is usually system dependence, so for comparing the dates, I normally set the search text and the field to the same format. In your case, set PolicyEndDate, SearchD, and SearchE to the same format "yyyy-mm-dd". And simply using <, <=, >, >=, or =. Hope this help.

Thank you very much for the response, I definitely will give the DIRECT:TCP a try. Currently I have been using PATHNAME, DIRECT:OS and DIRECT:HTTP to try on different scenario, and the results are: Same Domain, Same Machine - PATHNAME ... work - DIRECT:OS ... work - DIRECT:HTTP ... work Same...

Hi All, I would like to know if there is a way to push message from Server B into Server A (or a confirmation that is impossible). Server A is running windows 2003, has a private queue in workgroup mode under Domain A. Server B is running windows NT 4 under Domain B, no message queue, but with...

Don't worry, I figure it out already, by include a line in the DATA command such as "Reply-To: <email address>" will do the job... Cheers.

Hi All, The application that I am working on is using winsock to send out mail. It has a requirement to include "ReplyTo" email address field. I have searched around for the winsock command, and only discovered that the command for: Sender ("From") = "MAIL FROM:" Recipient ("To") = "RCPT TO:"...

Thank you very much, it works!!!

Hi All, I have a function as follow to retrieve from DB and return the recordset to the caller. ---------------------------------------------- Public Function Retrieve() As ADODB.Recordset Dim oConnection As ADODB.Connection Dim oRecordset As ADODB.Recordset Dim oCommand As...

Double commas or double quotes? double commas ==&gt; instr(1, Text, &quot;,,&quot;) double quotes ==&gt; instr(1, Text, &quot;&quot;&quot;&quot;) S.

Hi All, My PC has vb 6.0 installed, due to some maintanences are required on an application which is written in 16 bit vb 4.0, I will need to have vb 4.0 installed on the PC as well. Before I am going ahead with the installation, I would like to have some advices on such as any impact is...

Hi Jay, Thank you very much, the article is very useful. I am still reading through it to see if any of those changes are applied to me...:-) Cheers.

Hi, My boss has finally decided to upgrade the SQL 6.5 to SQL 2000, and he want a list of possible impacts that may happen to the 10 VB applications that currently use the database, these applications are written in VB 4/5/6. I am not a database admin, and am a pure VB programmer, I only use...

Thank you for your help Brian, In fact, the command you suggested did knock down the first dialog box. I still try to kill the second (last) one &quot;Remove dBASE 'soft' carriage returns from memos?...&quot; Any more suggestion will be much appreciated...:-) Thanks.

Hi All, By using Visual FoxPro 6.0 to open a dBaseIV table which contains the memo fields, a Convert Memos dialog box will pop up to prompt &quot;Convert MEMO file to Visual FoxPro format?...&quot;, by pressing the Yes button, another dialog box will pop up to prompt &quot;Remove dBASE 'soft'...

The suggestion from Brian is exactly what I want. Thank you very much for both of you.

Hi All, Is there any function that can use to convert the date format from yyyymmdd into yyyy-mm-dd or from yyyy-mm-dd back to yyyymmdd? Currently I need to use something like SUBSTR(Date, 1, 4) + '-' + SUBSTR(Date, 5, 2) + '-' + SUBSTR(Date, 7, 2) Thanks in advance. MrSatan.

Hi All, I need an easy implemented way to keep track of the return Url that passed from one screen into another. Eg: screen A -> screen B -> screen C -> screen D ...etc... Currently, my code is set the current screen's returnUrl to the request object, and the next screen will get it from the...

Is that Connection Pooling is set on in the database will make a different???

I can't recall where I found this, but you can use it to open any type of document...:-) Public Sub OpenDocument(DocumentWithPath As String) Shell &quot;RUNDLL32.EXE URL.DLL, FileProtocolHandler &quot; & DocumentWithPath, vbMaximizedFocus End Sub

Since I am dealing with batch files and am running under Windows 2000, so Andreas's method is the one I am after...:-) Thank you very much.

Hi All, I know by using some API functions, we are able to determine when a shelled process has terminated, but this only work for the first level call. eg: Shell MyProgram.bat Is there a way to determine the subsequent call as well. eg: In MyProgram.bat, I am calling MyLongProgram.bat, so...