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 wOOdy-Soft 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: *

  • Users: TomSnider
  • Content: Threads
  • Order by date
  1. TomSnider

    Using Count(*) on an existing recordset in VB

    I have created a recordset, rsItems, from an SQL statement in ADO. Is there a way to use that recordset as the table in another SQL statement....? Like "Select Count(*) from rsItems;".....? Any direction will be appreciated. Tom Snider
  2. TomSnider

    record locking with ADO

    Has this topic, "Record locking in ADO", been discussed recently? I tried to search for it, but.....well you know. Anyway, I have a multiuser application using optimistic locking. I have placed error trapping code in the 'save' process to check for locking errors, and it correctly...
  3. TomSnider

    using LIKE in WHERE clause

    I am using Access 2000 with VB6 and I am trying to use the LIKE operator....and it is not working for me. The sql statement is: "SELECT lastname, firstname from PERSONS WHERE lastname like '*SM*'" I was expecting the results to include any record with 'lastname' having the string...
  4. TomSnider

    create database with ADO

    I want to use code to create a new Access Database. I know how to do this using DAO object, but I am now using ADO and cannot see how to accomplish this task. In DAO I would just use a 'set myDB = OpenDatabase(DBName, true)' and then I could create the tables using SQL statements. How do I do...
  5. TomSnider

    256 byte limit on SQL strings

    I am starting a new thread on the problem of a string being truncated to 256 chars when used in an 'opendataset' method. I really need to find out how to get a string longer than 256 to be processed. I have a database DB, a recordset RS and a string sSQL. sSQL is assigned from a multi-line text...
  6. TomSnider

    What is an alternative to Access

    I need some feedback from some of you experienced VB people. I am fairly new to VB, but over 25 years of programming. I have developed very large accounting apps using Revelation (from the Pick system) and some small (mainly single user) apps using both Delphi and VB. The Paradox DB seems better...

Part and Inventory Search

Back
Top