Search:

I tried:
filter ( (select * from table), (table.val LIKE '%foo%') )

But that returned an error at the comma. So how do I use FILTER?

I found an add-in DLL that includes its source code, at: http://www.codeproject.com/KB/database/xp_pcre.aspx

Does anybody have experiences with using the xp_pcre project?

Edited to add: ...

I see where I'm confused. The code sample that you posted, I understand it as an insert statement. I need a select statement with a pattern-matching WHERE clause.

Also, in the code sample, the...

That is definitely the long way to do anything, and doesn't help me because I will have an arbitrary number of terms to query for.

My ongoing VB6 project needs to build an SQL statement to match a list of values within a field. The field may look like 'foo,bar,baz' -- comma-delimited values.

I can do this easily in regular...

I added a call to DoEvents after the call to SendKey, as I noticed that the tab key was being processed after the menu event exited. This resolved the issue, and validation is now working as desired...

I have many controls on each of several major forms, relying heavily on custom user controls, and I strongly doubt I can attach one of the forms. It would be difficult to even put together a decent...

The SendKeys didn't work. Here's the current code:

'**
'Menu Click Event Handler
Private Sub MnuSave_Click()
'On Error Resume Next
'Manually fire validation for the current control
...

dglienna: I want to move focus to the next control in the tab order that can take focus.

dee-u: Maybe the TAB was being thrown off by stepping through code in the debugger. I'll put the...

The question is, how do I pick the control to use for ctl.SetFocus?

Edited to add: The Is operator worked properly for the comparison. Thanks; that's part of the issue resolved.

I gave it a shot and had two issues.

1. I was trying to use pointer comparisons in VB6; I can't do an equality comparison between control objects directly. I'll have to use control.Name and...

Returning to this issue one more time, now with a code extract.

Here is my handler:

'**
'Menu Click Event Handler
Private Sub MnuSave_Click()
On Error Resume Next
'Manually fire validation...

I finally found an obscure reference to how to install CDO. It is an advanced option in the MS Office 2003 setup, buried under MS Outlook and normally set to NOT install.

I ran this, reverted my...

I checked back with my testers today, and they said that they installed and configured CDO.dll on their test system. Once they did, the call to CreateObject ("MAPI.Session") worked properly and they...

Ooh, that would be a problem. Can you point me to the article on MSDN?

Outlook can properly send and receive the attachment.

Legacy functionality is to send the attachment from within the VB application, so the user does not have to search for the location of the attachment (the file is created at run time).

I added the extra settings from the VB.ITToolBox site, and it didn't improve the situation. I still get the error of "Unspecified failure has occurred." Here's my current code:



'**
'Sends...

I have legacy code in my system that was trying to create a MAPI.Session object, and failing. I found through this forum the recommendation to put the MAPISession and MAPIMessages controls in my...

I had forgotten about this until today, when we got a defect report that led to the same issue: Controls that require going through their Validate event do not fire Validate when the user clicks on...

Hello again,

My project's tester just found that while my infamous custom controls properly fire their validation methods when he saves data from a toolbar button, the menu command to save a...

I'm back, same project, different issue.

The customer has requested a change, that data be exported from our project into an Excel spreadsheet. For enterprise-wide compatability reasons, all MS...

Yes, and yes.

Fortunately, the project's tester has had no issues with the controls since I have em the fix for this issue.

I found it.

The issue was in fact the control name. I had tried the global find and replace this morning, and the issue returned.

So I changed one form one small step at a time. The issue...

WizBang: The user control that had the issue is called MemoText, and the clone that works just fine is currently called MultiLineText. The names are legacy-ish, as the original control that used...