Recent content by LLudden

How are the numbers stored, and in what format? If these numbers are in a database, stored as type Float (or Single/Double), then you can use a SQL statement such as: Select * From Table Where Number is between 1234.02 and 1234.22 Doing this with regular expressions is much harder, as you...

I have tried adding this script both from QA and from EM. Both went off into nevernever land, and after 14hrs we rebooted the server to speed things up, so it was doing something. There has been no tech people working on this system for a long time. The databases and tables were all created...

CREATE TRIGGER [MakeorDeleteStops] ON [dbo].[Transport] FOR UPDATE AS Declare @Ticket int, @Transport int if ( UPDATE([Vehicle ID]) ) begin Select @Ticket = (Select [Ticket No] From Inserted) Select @Transport = (Select [Vehicle ID] from Inserted) if ( @Transport > 0 ) begin exec...

I am doing some work at a new customer who is running SQL 7 (unsure of Service pack #). I need to add an update trigger to one of the tables which contains about 70K records. There are currently no triggers defined on that (or any) tables in the database. When I enter the T-SQL for the...

I have a table of city names that are referenced in another table by the primary key: Table CityList, CityCode as int, City as nvarchar(25) Other tables that use the CityCode to reference the city name, so to get an address for a customer record, I have to query the customer table for the city...

Easiest way to do what you want is to use Adobe Acrobat and create all the data as .pdf files. Otherwise, you have 3 choices: 1. Alter the generating software so it creates an image file 2. Parse the output file and convert to graphic 3. Write your own printer driver that basically does what...

If you add a public variable to the class declarations, its visible to everyone. Make it private and it will be visible to all functions within the class.

I have a software package I am doing a major update to. The original was written as an Access 2000 front end, and I am changing it that to VB6. The backend data is in SQL server 7.0 What I want to do is write T-SQL to transfer all of the existing data to a new database in SQL, and then...

If you are using exchange server, you can create a security profile that allows the sending of messages with VBA unprompted.

The goal of the database is to be able to choose a manufactured item, and list all the components needed to make it. Some of the components themselves are manufactured from lesser components. There can be many sub components in any given piece. Using an automobile for an example: Car...

Can you post the code you have on the Click event for the button?

Its usually better when processing text files sequentially to stick to a single line for reading the file, then have your loop code determine how to handle that line. For example: Do While Not EOF(varFileNumber) Line Input #varFileNumber, varLineString If...

To use a wildcard in a WHERE clause, use: WHERE [Fieldname] LIKE 'Bob*' To use dates, surround the date with # #6/26/02#

This thread probably has the answer: thread222-298724

If you have many changes occuring to your database, then having too many indexes actually can slow it down (indexes have to be updated with each record modification). If you are mostly looking at existing data, then having each record that is searched on indexed can speed things considerably...