Tip Bank

Question: [Joe Celko’s Employment Agency Puzzle]You are running an employment agency that has requests for jobs and applications from candidates. Both of these forms include a list of the skills

Question: When a user selects a value from a list box, I populate the contents of arepeater. I also want to set the focus into the repeater’s first field.How can

Question: I am using the EXEC SQL command to insert some data into a database on the CommitForm()method of a form, but the data is not showing up in the

Question: I want to use a unique compound key, with a string columns and a numeric column, in my table. Since Blaze does not support compound keys, I will have

Question: How do I arrange to sort within a GROUP BY clauserather than over the complete result set, e.g. L0 PDV …… L90 PDV …… L180 PDV …… L270 PDV

Question: [Joe Celko’s Equal Sets Puzzle]Set theory has two symbols for subsets. One is a “horseshoe” on its side, which means that set A is contained within set B and

Question: I’ve heard several of the arguments in favor of a server that supports datareplication. What are the potential problems? Answer: For our readers, the advantages of data replication [creating

Question: What is the syntax to get a series of “counts” on a table? An exampleof what I am trying to do is as follows:SELECT col1 = COUNT(tstfield1=’X’),col2 = COUNT(tstfield2=’Y’)

Question: How can I set the flushing of rows to the database or the locking strategy used by Power Objects? Answer: Oracle Power Objects ‘supports’ two ways that rows can