Search results for query: *

I have created a dictionary base collection Public Class SBTSessions Inherits System.Collections.DictionaryBase Public Sub Add(ByVal Session As SBTSession, ByVal Key As String) Dictionary.Add(Key, Session) End Sub Default Public ReadOnly Property Item(ByVal Key As String) As...

Where do you create the XMLDoc object? JHall

I think maybe your where clause is using single quotes which works fine in, say, VFP but not in DAO. You might try "SELECT * From tblEmployees WHERE tblEmployees.Emp_Tracker= " & CHR(34) & USERID & CHR(34) & ";" JHall

In SQL Server you can use parameterized stored procedures. It's okay to use EXEC(sqlstr) but you won't get the benefits of a saved execution plan. JHall

Perhaps you could use OpenQuery() and see if you get a result like SELECT COUNT(*) FROM OPENQUERY(YourLinkedServer,'SELECT stuff FROM YourOracleTable') JHall

Once again I assumed something wrong, sorry, thought you wanted to calculate the duration. JHall

I think you'll have to use VBA to do it. Create an tabledefs object Create a table object and "SET" it to your table Change the Name property Then use the tabledefs UPDATE method JHall

Check out DateDiff in Books On-Line DateDiff(ss, <startdatetime>, <enddatetime>) JHall

My bust, you're right. I just had it work for me too. My apologies. JHall

How can you set the default to a system function. It doesn't return today's date when I try it. I believe Column Default Values must be constant expressions. JHall

You could try using Excel automation with sp_OACreate etc. JHall

I would comment out the trigger and see if you are able to insert into the table with your vb code. If not, then you probably have either a problem with your vb code or a permissions issue. JHall

The Default Value for a column must be a constant expression. You could maintain it with an insert trigger but whatever process is inserting a record would be the place to put code to insert the current date IMHO. JHall

Sorry, I forgot to divide by three , how about... I would first create this user defined function CREATE FUNCTION GetBeginDate (@InDate as datetime) RETURNS datetime AS BEGIN DECLARE @StartDate datetime SELECT @StartDate = DateAdd(d, -1 * (2 + CASE WHEN DatePart(dw,@InDate) BETWEEN 4...

I would first create this user defined function CREATE FUNCTION GetBeginDate (@InDate as datetime) RETURNS datetime AS BEGIN DECLARE @StartDate datetime SELECT @StartDate = DateAdd(d, -1 * (2 + CASE WHEN DatePart(dw,@InDate) BETWEEN 4 AND 6 THEN 0 WHEN DatePart(dw,@InDate) = 7 THEN 1...

Have you tried using an odbcCommand object and then invoking the method ExecuteNonQuery? That works pretty well for me getting to SBT Data (VFP 5) from .NET JHall

It sounds as if you are trying to earn a grade as well. I would use a switch like Hours * Switch(Grades=&quot;A&quot;, 4, Grades=&quot;B&quot;, 3, Grades=&quot;C&quot;, 2, Grades=&quot;D&quot;, 1) JHall

Does your DSN have under options &quot;Fetch Data in Background&quot; checked? If so, uncheck it. Hope that helps. JHall

Command line should work but just out of curiosity, is there are a lot of data/functionality that you are trying to make available? If not, how would the vendor feel about incorporating the information into their application. You could provide all the needed components and all they would have...

I think the RecordCount propert for DAO Recordsets (unlike ADO) only count the number of accessed records not the total number of records. To handle this just put a MoveLast and MoveFirst before you start your loop. JHall