Viewing 15 posts - 16,756 through 16,770 (of 18,923 total)
It is that simple, unless I don't understand the question.
Do you have multiple triggers that insert in the same target table?
Can you post the code you're using with its problems?
June 14, 2005 at 9:43 pm
Good idea... but make sure it's a column with a default if possible. Just to avoid data that's be reloaded from an even older version of the app.
June 14, 2005 at 9:07 pm
Isn't there a collection for the queries in access just like for the forms and reports.
Like currentproject.allqueries
You could do a for each q in ... and recreate the queries on...
June 14, 2005 at 9:06 pm
Isn't there anyway to just return the recordset without transforming to xml?
Xml is only a much more bloated version of the data and therefore takes more resources to transport.
June 14, 2005 at 9:03 pm
You're right... first time I see this situation.
Always something else to learn
.
June 14, 2005 at 8:59 pm
on the first trigger :
CREATE TRIGGER...
FOR Insert
AS
SET NOCOUNT ON
Insert into dbo.Table2 (Col1, Col2, Coln) Select Col1, Col2, Coln from Inserted
GO
Repeat process for the next trigger. This will do...
June 14, 2005 at 8:50 pm
You have to keep the whole date to easily solve this problem :
Select datediff(d, '2005/01/01 20:00.000', '2005/01/02 04:00.000') = 480 minutes (8 hours)
This is the easy way out. ...
June 14, 2005 at 8:44 pm
So close yet so far
:
select custid from dbo.Txusage
where UsageTime between '2005-06-14 11:59' and '2005-06-14 17:00' and Venueid in (5,12)
group by custid
having...
June 14, 2005 at 8:40 pm
It's not hard
try
--fail
insert into SomeTable (SomeCol) values ('This fails : '')
--works
insert into SomeTable (SomeCol) values ('This works : ''')
June 14, 2005 at 2:32 pm
Forgot to ask (really the last one
)
Is it 10 consecutive records for the same name or can have different names?
June 14, 2005 at 2:15 pm
To quote Joe celko :
"You guys need to stop thinking proceduraly and start thinking in sets".
And I'm still waiting for my own answer on this one. Not the...
June 14, 2005 at 1:55 pm
Now if it's not a typing problem, I can't help you, otherwise there's always those typing teaching softwares
.
June 14, 2005 at 1:44 pm
You'd be the first to understand all this by himself.
Up to the challenge
?
June 14, 2005 at 1:43 pm
Is it possible that the user doesn't have permission to run FileProperty (can't find any info about the minimum permission required)?
June 14, 2005 at 1:42 pm
As I explained you'd need to replace all the (') with (''). Or you could create a stored proc and avoid the problem altogether. It would also shield...
June 14, 2005 at 1:38 pm
Viewing 15 posts - 16,756 through 16,770 (of 18,923 total)