Tip Bank

Question: In Informix SE, I can use ISQL to generate a default form from a table and then query, update, or delete data within the form? How do I do

Question: Which is faster, LOCATE (without parameters) or GO TOP? How fast is the one from the other? Why is one faster than the other? Answer: They are usually equal

Question: I cannot initialize the program after I have installed it. When I run “oninit”, it seems to work, but then when I run “onstat” it tells me that the

Question: How can ‘Ontape’ functions be used to back up Informix/Lawson DB to disk? Is dbspace required or can a large area in a directory (e.g., /gsc/bigspace) be used? Answer:

‘ Modify a phone-number to the format “XXX-XXXX” or “(XXX) XXX-XXXX”.Function FormatPhoneNumber(ByVal text As String) As String Dim i As Long ‘ ignore empty strings If Len(text) = 0 Then

‘ Takes a first and last name and converts it to the format LastName, FirstNameFunction FormatFullName(ByVal FirstName As String, ByVal LastName As String) As _ String FirstName = Trim$(FirstName) LastName

‘ change a sentence in CamelCase to a sentence with spaces’ for example ConvertCamelCase(“FileExchange”) => “File Exchange”Public Function ConvertCamelCase(ByVal Value As String) As String Dim i As Long For i

‘ reverse a full name” for example: ReverseFullName(“John A. Smith”) ==> “Smith, John A.”Function ReverseFullName(ByVal FullName As String) As String Dim i As Long ‘ search for the last space

‘ Format a credit card numberFunction FormatCreditCard(ByVal text As String) As String Dim i As Long ‘ ignore empty strings If Len(text) = 0 Then Exit Function ‘ get rid