Recent content by markphsd

Awesome, I was clear. Yes that's exactly what I"m now doing in vb rather than sql. Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.

Multiple scales was the part I was trying to get to. It would basically be a GROUP BY that has a where clause as the field. GROUP BY Range So for every given range there's a row with a total. Your statement would require me to do a statement for each commission scale. which I was trying to...

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 would have to say, never mind this for now. I have a solution. Fortunately i have a SiteID witch would be the ID of each database. I will append this to the PKID's when importing into the main database. I believe this will cover it. Mark P. www.cafecartel.com Providing Low Cost Powerful...

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...

I worked with a company called SintelSystems.com they won't focused on the software but did focus on the solution. They know different software applications, security systems and so forth. They were an overall positive company to work with. Mark P. www.cafecartel.com Providing Low Cost...

Any one have any solution? I continue to have this problem. Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.

Also, I have used quotes in the second argument like this: "'My Company Name'" Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.

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 =...

The field "CompanyHeader" is in the report header section. The code is is in the ReportHeader section. Me.FormulaFields.GetItemByName("CompanyHeader").Text = "'MyCompany'" I get an invalid name error. This isn't using any dataabase at the moment. I actually had no problem generating records...

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.

While that may be interesting, I couldn't figure out how it could answer my question. But yes this is true: "want to time out and raise a flag or whatever when you can't" thanks 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...

Fastest help for me ever. Thank you. Mark P. www.cafecartel.com Providing Low Cost Powerful Point of Sale Solutions.

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...