Search results for query: *

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 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=...

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.&nbsp;&nbsp;They are saved in the table as (999) 888-7777 even the input mask is saved.&nbsp;&nbsp;They come out looking like 9998887777.<br><br>How can I change that?<br><br>code...