Tip Bank

DevX - Software Development Resource

DataWindowChild problems

Question: I have a datawindow d_case with a retrieval argument al_case_id. In this datawindow, I have two columns that are ddlbcolumn1 = judge with dddw_judge and column2 = contact with

DevX - Software Development Resource

Replace – String replacement under VB4 and VB5

‘ A clone of the VB6’s Replace function for use under VB5’ Note: many routines in this collection uses the Replace functionFunction Replace(Source As String, Find As String, ReplaceStr As

DevX - Software Development Resource

SQL Server Transaction log

Question: Is there a way to turn off the transaction log while importing data? We are having a problem with a 1105 error. Answer: You cannot turn the transaction log

DevX - Software Development Resource

ReplaceMulti – Multiple string replacements

‘ Perform multiple substitutions in a string’ The first argument is the string to be searched’ The second argument is vbBinaryCompare or vbTextCompare’ and tells whether the search is case

DevX - Software Development Resource

Finding duplicate values in a table

Question: I have a table with the following fields: Physician Patient # Procedure One of the Procedures is “X-ray.” How can I list the Patient # of anyone who has