I'm using Backup Exec 8 and trying to make a report based on the date. The problem is that the date is saved in the veritas database as a "dosdate". Veritas provides a function to translate the date for reports but you can't use the function in a where claus. I really want to make a...
I have a question about how merge replication works.
How is the data updated? For example, if you have table A that you are replicating to table B and data has been deleted from A, does it also delete the data on B? Does it reference a primary key to update the data? I can't find adequate...
I have a button on a page that sends the user to a different server. I want to write code so that the button checks to see if the server is available. If the server is not available, I want the user to be directed to a nice friendly page that tells them the server is down. I know I need an...
I have a dos database program that stores the data in a db file format. I want to convert it to an asci text format but I don't know how. I was told that there is some dos command that will convert it. Does anyone know how to do this?
I'm doing a report that counts (for example) the number of bananas, apples, and oranges sold in a given month. My query is a crosstab query. So, of course, if I didn't sell any oranges the category wouldn't show up on my report at all. How would I make it so my report would say 0 oranges were...
My report is supposed to be 3 pages long. After the 3rd page though, everything repeats (except the heading which is set for only the first page) so my report ends up being 6 pages long. It is the exact information that is repeating, so pages 1 & 4 are the same and so on. I don't know how to...
I have a report with many subreports and each query is dependent upon the date range. How do I pass the date parameters between queries. I tried entering the parameters in a form and linking them to my queries. This works for my plain select queries, but not my crosstab queries (which are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.