Question: It seems like I cannot define my own data structures in OPO. I want to create an variable that actually consists of different underlying variables – a string followed
Question: What are the advantages/disadvantages of putting large binary files (1+ MB) in BLOB columns versus storing them on a file server with a reference such as a directory/file spec
Question: I have nine offices. I want each office to connect across aWAN and run client/server applications with all datacontained on one central server. However, we are finding the delays
Question: What are the differences between LEFT, RIGHT, INNER and OUTER JOINS? Answer: An INNER JOIN is the most common type: It combines all the data from the tables specified
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 want to have a form that does not appear in a MDI (multiple document interface) frame. Can I do this? Answer: In Version 2 of Power Objects, you
Question: I’ve got a “new user” question for you. Some of the tables in our databaseshave several columns containing data that’s not used very often. When I’musing ad-hoc queries, it
Question: What are the common uses of stored procedures? Answer: Many databases use stored procedures and/or triggers to implementreferential integrity [ensuring that data referenced by another tabledoesn’t get deleted or
Question: Our system is experiencing several lock conflicts. We’ve got a consultantlooking at the details, but I was hoping you could explain what’s going onbehind the scenes when records are