Ya I caught that too. Thanks! What happens is that the vb program gets caught in a loop trying to update or something and it appears that the table or row is locked. I took off the update trigger that updated the row saying that it had been inserted into the appropriate table. So, what now...
Ok, that works for one insert statement, but I am back to the problem of not being able to handle both insert statements together... It needs to be an if or something that is selective.
Thanks!
I have a vb program that scrapes data out of a text file into a sql server 2000 table called Orderlog. What I would like to do is have an insert trigger on Orderlog that searches for all orders that have not been updated (updated is a field set to 0 by default and then set to 1 after it has...
This is the new query:
SELECT
Orderlog.`Order`,
Orderlog.`Proc`,
Orderlog.`OpenDate`
FROM
`Orderlog` Orderlog
WHERE
Orderlog.`OpenDate` BETWEEN CDateTime({?sDate}) AND CDateTime({?eDate})
ORDER BY
Orderlog.`Order` ASC
This is the error message I receive:
ODBC...
This queries a msaccess 2000 database full of records. I haven't ever gotten any records to return from this query though.???? Does anyone know what is happening, as I am new to crystal. This is in the Crystal SQL designer. This is what I type in to the parameters (sdate= 7/7/01, edate=...
I am at my witts end....
I know no one wants to hold my hand and walk me through this, but I think that is the best way to get this stinking report out of my hair.
Can anyone send me an example of querying a table, looking for data between two dates. It needs to prompt for the start and end...
S2001,
Since I did that in the report designer do I need to query for all records and have Crystal filter it for me? Also, it doesn't prompt me for the variables, should I put this in a formula or something? I am unsure where I would put the filtering part if I get it to prompt for the...
Here is my query, I have created the parameters, but when I run it I get a message box that says they are not defined. Here is the query as it stands:
SELECT Orderlog.Proc, Orderlog.Order, Orderlog.OpenDate
FROM Orderlog
WHERE Orderlog.OpenDate Between {?Pm-@FirstD} and {?Pm-@SecondD}
ORDER BY...
I know this won't work but if someone can help put this together for me I would appreciate it. I have been banging my head against the wall on this one for a while now...
Trying to get data back from this stored procedure, I send it four variables but sometimes I would like to send it just...
I have a form that has an order number on it and I have a datagrid that needs to get that order number and show the notes that correspond to the main form's order number. They are on the same form, and would work together like a subform in Access would. The datagrid uses a dataenvironment...
How can I make a phone number look like a phone number??<br>I query a table in Access and pull phone numbers from it. They are saved in the table as (999) 888-7777 even the input mask is saved. They come out looking like 9998887777.<br><br>How can I change that?<br><br>code...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.