Tip Bank

Question: I would like to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static

Question: We have to connect VFP to SQL Server, and we have a lot of non-structural index files for tables. We’ve created remote views for the tables and need to

As you probably know, the “&” operator is rather slow, especially with long strings. When you have to repeatedly append chucks of characters to the same variable, you can speed

As explained in another item in this Tip Bank, you can use the Recordset’s GetString method to export a Recordset to a comma-delimited or tab-delimited text file. However, if you

‘ Filter out all invalid characters in a string.Function FilterString(text As String, ValidChars As String) As String Dim i As Long, result As String For i = 1 To Len(text)

Reading and writing an item of an array is always slower than accessing a simple variable. Therefore, if you need to repeatedly use the same array item in a loop,

The GetString method of the Recordset object returns a formatted string that contains all the values in each field and each row in the recordset, with your choice of column

When you want to assign a control’s Font to another control, the first obvious way is to assign the Font property directly, as in: Set Text2.Font = Text1.Font but in

The String$ function can replicate only 1-char strings, so it seems that you need a loop to duplicate strings that contain 2 or more characters. However, this is a one-liner