Search results for query: *

Using SQL 7. When I try to pass a null value to a stored procedure which adds a new record, the value inserted into a datetime field is Jan 01, 1900. Have tried almost every conditional programming to force the null value, but to no avail. Any suggestions would be greatly appreciated. Thank you.

What database are you using? If it's SQL Server, you can use the xp_sendmail procedure to send an email. Or, you can add the MAPI controls to your VB front-end to send messages. There is MAPI documentation in the knowledge base at microsoft.com.

I'm trying to bind a datacombo box to a command based on a stored procedure. The stored procedure has one parameter. I am trying to refill the combo box after the user provides the parameter by selecting a record from a different combo box. When I refresh, I get an error stating that the...

did you ever figure this out? I'm having issues similar to yours and am having a difficult time finding documentation to help. thanks.

Has anyone used this datagrid before? I would really like any feedback about this product as I'm considering what to buy. Thanks. :o)

When a record is inserted, I need to export the data to a text file and email it. I tried using xp_sendmail with @attach_results set to true, but, the text file is not in a data format. Then, I used DTS to export the data which turned out well, but I cannot figure out how to do this on the...