I would like to write a sql statement that groups sales based on a range of values of a separate commission tier schedule.
So basically there would be two tables, the sales table and the commission rate table.
for example the sales person has three tier rates:
5% commission at sales...
I'm going to be merging multiple databases into a central one.
I know that during importing to a merged database, a GUID ID can be added. However, this will only be helpful for the database, not the GUI application I'm using. Is there anyway to make the Standard Primary Key ID's unique as...
Crystal Reports 10, Visual Basic 6.
When assigning the header of the report a company name, not using a database I get a permission error or an invalid name error:
I have this field in the header of the report. The code behind the header of the report is this:
Receipt.RecordSelectionFormula =...
How do I set the text of an unbound formula field with VB6 and CR10?
I have tried various methods, done lots of searches. I would post them, but I'll wait for an easy response if it's there first.
Mark P.
www.cafecartel.com
Providing Low Cost Powerful Point of Sale Solutions.
How would i detect if the database connection has been dropped. would i use a network or tcpip connection instead? The time out feature on ADODB connections doesn't seem to work as expected.
Basically I would like to know very quickly if the connection is broken.
Thank you
Mark P...
What's wrong with this:
DELETE
From ContactPurchases
INNER JOIN OrderDetails
ON ContactPurchases.OrderDetailID=OrderDetails.OrderDetailID
I get this error:
Server: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'INNER'.
But it works find when using it as a SELECT...
What is wrong with this:
UPDATE tblOrders
INNER JOIN tblOrderPayment ON tblOrders.OrderID = tblOrderPayment.OrderID
SET tblOrderPayment.OrderDate = tblOrders.ScheduleDate
Mark P.
www.cafecartel.com
Providing Low Cost Powerful Point of Sale Solutions.
I programmatically build a toolbar. However, i have been unable to find a function or macro to call a builtin toolbar function.
This is the tool bar button for security that sets the security level. (so people don't get the warnings on the application i have them set it to low in 2003)...
Hi,
I would like to know how to determine if the connection object is valid, before using it.
Invalid wouldn't necessarily mean, adStateClosed, because i can turn off my wireless device on my computer and ado won't recognize this. Then when i try to open a recordset i get an error.
I...
Hello,
I have a number of distributions of a database for a Sales application. We want to version each group of changes to the schema by the development team, then package those changes for distribution along with our application distribution updates.
Currently we have to connect to each...
Hello,
I have a field name of "1s" on a SQL Server Database. When using ADO to edit the field i get a 3265 error, that the field can't be found. I try to use an Alias, but it doesn't work.
What can i do without changing the Fieldname?
Mark P.
www.cafecartel.com
Providing Low Cost Powerful...
I have a mdf only that I need to attach. The back up is several weeks old.
The system crashed so the database couldn't be detached. The ldf could not be copied because it is corrupt. I'm trying to attach the mdf to a new server, but i can't use the sp_attach_single_file_db because from what i...
A customer had an operating system crash on their system running SQL Server.
Can the database be detached or copied and attached by just accessing the hard drive. (The folder is not secured). If not, what could be done with that database?
Thanks.
Mark P.
www.cafecartel.com
Providing Low...
I've been trying to figure this out for a while.
I have to set the tab index of about 60 or 70 controls on a form.
I have a sub that runs when the form loads, i've also tried it after the form is open:
It goes like this:
option explicit
private mlTabInit as integer
Private Sub...
I have been using the SQL Script Generated to update multiple databases after changing one.
It seems one or more of the are deleting all of the data from two or three tables in the datbase.
How would I identify which script causes the deletion?
Mark P.
www.cafecartel.com
Providing Low Cost...
I'm i'm trying to debug my dll. I Run the DLL, start the application. Some functions run, but I get an error only in debug mode on a Enumeration in the one class. Any ideas?
Mark P.
www.cafecartel.com
Providing Low Cost Powerful Point of Sale Solutions.
I have a related post on here, about binary compatability. My DLL compiles fine, however when using Binary Compatability, i have been getting a couple of messages, and it seems they are consisistent.
THe messages say i'm using an Obj type rather than the explict type. There are two object types...
I use a dll with word and Access, when I make any changes to the dll, i have to re-reference it in the WORD And access file. Is there any way to get around re-referencing?
Mark P.
www.cafecartel.com
Providing Low Cost Powerful Point of Sale Solutions.
How do i open a word template and create a new document from it?
There's like 20 parameters when opening a word.application
.documents.open(,,,,,,......
Mark P.
www.cafecartel.com
Providing Low Cost Powerful Point of Sale Solutions.
Earlier this month i had asked how to script changes to a SQL Server 2000 database. I was told to set the changes to be saved to a text file.
Now i have all these script files from the changes. I thought I could run the SQL in the scripts using ADO with VB, but I get an error.
For the...
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.