Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. donutman

    Working with DataSets with VB Code

    Thanks MajP. While the link didn't really answer the question it pointed me in the right direction. My good fortune that you happened to visit this forum rather than Access. Rod Stephens Chapter on LINQ did the rest. Awesome, would never have studied that chapter otherwise, i.e. would have...
  2. donutman

    Working with DataSets with VB Code

    I'm trying to mimic DataSet table queries within VB code that are simple as pie in SQL Server. Another words I want to work with the data tables in vb and perform e.g. left joins that can then be used to create a new table within the DataSet that contains only rows from Table A that are not...
  3. donutman

    There must be a clever way

    I've learned something from each of you. Thanks Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com
  4. donutman

    There must be a clever way

    I believe there's a way to select e.g. either all customers from a table or just one customer from a table when given either a customer's unique id (alpha characters) or a null value as the parameter input to a stored procedure. Of course it is possible to just use an IF Else block, but isn't...
  5. donutman

    Dex.ini file for Version 10.0

    Yuck! It's no wonder why MS OS computers run so slow even with the unbelievably fast processors we now have. Why doesn't MS know how to write efficient code? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert...
  6. donutman

    Dex.ini file for Version 10.0

    Hi Victoria, Once again, you've provided excellent help. In your first response you eluded to the possibility of getting inundated with too much detail. My intention is to have the user go directly to the activity I want to analyze, perform it and exit. If that process in itself will...
  7. donutman

    Dex.ini file for Version 10.0

    Thanks Victoria! I guess the next question is where I can expect to find the log file - same directory? Also do I need to change the flag to TRUE for all 3 of these? SQLLogSQLStmt=FALSE SQLLogODBCMessages=FALSE SQLLogAllODBCMessages=FALSE Karl Cursors, triggers, user-defined functions and...
  8. donutman

    Dex.ini file for Version 10.0

    I'm new to Great Plaines. I'm trying to learn what tables are effected when various transactions are performed. I've read from another thread that the dex.ini file can be modified to create a SQL log file. I've also read that version 10.0 may not support this feature. My question is rather...
  9. donutman

    Could not make it work

    I really like the idea presented by gmmastros. It makes it easy to create reports that might include only a subset of all stores (with a simple inner join to a temporary Store-Report table). I would tweak his idea by just creating a reporting table in the Corpdb database for the actual...
  10. donutman

    Date comparison - but only Month and Day?

    Is there no concern for the possibility that the date range spans January 1? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com
  11. donutman

    2008 and 2000 compatibility

    Thanks and hi SQLSister. I've never used them, but I put them into the post for completeness. I assume you can't think of any other TSQL that I might have to change, can you? I also don't use triggers, so any compatibility problems there I can ignore. Karl Cursors, triggers, user-defined...
  12. donutman

    2008 and 2000 compatibility

    Thank you both. I read the links inside the link and I downloaded a 2008 evaluation. I guess I misread something, but it is a little tricky. Select a as b, c from aTable order by aTable.b That is invalid, but if you remove the aTable. from aTable.b, then it is ok. Select a as b, c from...
  13. donutman

    2008 and 2000 compatibility

    ...2008 from 2000. I’ve read that to run in 2008 mode, you must not use an alias (for a column name) in the Order By or Group By clauses. The use of *= and =* for joins is also verboten along with the keyword “WITH” (except in nolocks). Hmm, does that mean: Select a, b, c, 1 as AnAlias...
  14. donutman

    How to write an active x control for VB6 in .net

    Thanks for the link, but it confirms that I need to bid this project out to someone more fluent in .Net than I. Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com
  15. donutman

    How to write an active x control for VB6 in .net

    I think AxImp is for doing just the opposite, i.e. taking an existing ActiveX Control and porting it to .NET. I need to write an ActiveX Control in .NET so that it can print a SQL Server report, but I need to use the ActiveX Control in an existing VB6 application. I'm not very fluent in .NET...
  16. donutman

    How to write an active x control for VB6 in .net

    I need to print a SQL Server report (using the report server) from a vb6 application. Does anyone know of example code for creating a vb6 control in .net that could expose the properties and methods to accomplish the printing? Karl Cursors, triggers, user-defined functions and dynamic SQL are...
  17. donutman

    VB6 call to SSRS

    Does anyone know how to code a call to SSRS from VB6? Is there a .NET wrapper to do it? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com
  18. donutman

    Calling SSRS from VB6

    Does anyone have example code for calling a 2008 SQL server report (off the server) from VB6? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com
  19. donutman

    SQL Server Reporting Service

    Can a report be called from a stored procedure? I don't have SSRS, so I have no clue. Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com
  20. donutman

    SQL Server Reporting Service

    I don't use SSRS, but I'm wondering if the report server can run a report that is called from a stored procedure? Karl Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil! Life's uncertain...eat dessert first...www.deerfieldbakery.com

Part and Inventory Search

Back
Top