Search results for query: *

I need to pull birthdates of individuals who are 9 months old or less. I thought I can use the datediff funtion but it's not supported in ver 7? Any tips would be helpful. Thanks.

I'm using a subform with it's default view set to datasheet. In the cells of the datasheet, is it possible to place a drop down so that the user can select from a list?

Thanks Gary. That worked!!

Gary, Are you suggesting that in my stored procedure, if there are no records returned, I should insert a dummy record in my temp table and check against a field for a null value in Crystal Report?

Ok. That makes sense to me too. Thanks.

Turkbear, Thank you for your reply. Yes, the lack of records displayed would be an indication that there no records. However, for the end user some kind of message to say so would be nice. Which leads me to the second part of your reply... Recordcount > 0??? Seems to me that if it returns a...

I have a stored procedure attached to a crystal report. Is there a way to check the record count when the report is ran? In other words, I'd like to check if the record count = 0 if the stored procedure returned no records. Thanks!

Thanks to you both.

Can anyone suggest some documentation on this process, upgrading from CR7 to CR9. Really appreciate it. Thanks.

Using ADO if possible, I'm insteresting in opening a query as a recordset, loop through the recordset and addNew records to an existing table. This is what I have so far, but I believe it's using DAO Dim db As Database Dim qdf As New QueryDef Dim rs As Recordset Dim...

I am passing parameters into a stored proc from a vb6 app to produce a crystal report. Two of the parameters can be null. Running the stored proc from QA runs fine. In the vb6 app the null parameter appear as empty strings and when I run the app it doesn't produce the desired output. How can I...

Here's a piece of code that runs well from QA but when placed in a SP it errors out with "Syntax error converting datetime from character string" Any idea why? create table #test (appt_time varchar(255), dtAppt_time datetime null) insert into #test(appt_time) values ('2:20 AM') update...

Using version 8, I have suppress the group header based on certain conditions. If the condition is true it suppresses the group header but it still groups the details. I would like to disregard the group totally. How can i do this? Thanks

Thanks. It turns out that the third-party app is only compatible with MSDE and not SQL Server 2000.

Trying to do a db server installation of a third-party application on to our server (Windows 2000 Server) running SQL Server 2000. I keep getting the following error: "Instance name specified is invalid" Any reason why this may be happening? Thanks in advance for your help.

thanks to all.

Thanks for such an immediate response. Connect to the database....is that the same as saying attach to a database?

I have a third party application that has both a server installation and a client installation. When I did the server installation on the DB server (which use SQL Server MSDE) it installed an .mdf and .ldf files. That works fine. However, how do I create a database to view the mdf file? Thanks...

The exact error msg is "Incorrect syntax near '@champFile'." Ok here's the corrected code: if @currentmonth = 1 -- January begin set @champFile = 'f:\CC' + @lastyear + '1001.TXT' bulk insert ccm_Prov_Enct_Stat_Rep from @champFile with (DATAFILETYPE = 'CHAR') end

Here's a small piece code that I'm trying to run. I need to build by text file each time. Once built, I'd like to do a bulk insert, however it keeps complaining about my syntax in the "from" statement. All parameters have been declared, I'm just not showing it here. if @currentmonth = 1 --...