Recent content by MrSatan

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.