Search results for query: *

...minimukm wage? lol

Well thats the obviouse answer and we already know that. However, its been our experience that the more we think outside the box, the more we are able to develope what we need. This is a mear bump in the road. Thanks for your observation though.

I have upgraded my Internet Explorer to 7.0 and my Crystal Viewers stopped working. I can nolonger view Crystal Reports using Internet Explorer. Any ideas about upgrading my viewers with out upgrading Crystal 7?

Ah yes, I tried both of those things, but now luck! Thanks for the tip though.

Hello I trying to access data from Crystal 8.5 from a SQL table. The field length is 500 but Crystal seems to only want to show the first 255 characters. Is there a setting I can tweak to see the entire field value?

Stevexff How would that help me bleed out the BLANK/NULL fields?

Does anyone know of a better way to do the following? The code pushes out BLANKS/NULLS in a row of records. i.e. Before push code is run: Field1 = "Summer" Field2 = NULL Field3 = "Fall" Field4 = NULL Field5 = "Winter" Field6 = NULL Field7 = "Spring" After push code is run: Field1 = "Summer"...

Thanks for all your replies. I wound up writing a function to handle this.

I am hoping to find a SQL function that will allow me to cast a money/int/dec field into actual text. So far I have had no luck. Ex: $152.50 needs to become One Hundred Fifty Two and 50/100 As Im sure you have guessed, this is needed for printing checks. Before I delve into the endless...

ESquared - Putting SET ANSI_NULLS OFF SET ANSI_WARNINGS OFF was my first remdy but it didnt help. Vongrunt - Jupiter is the server I am dealing with with this error.

I am trying to write and save a stored procedure but I keep getting the folling error. Error 7405 Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. The...

I am trying to write and save a stored procedure but I keep getting the folling error. Error 7405 Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. The...

Donutman is correct. Try switching the month and the day as so: UPDATE Bathrooms SET Bathrooms.[2nd Fix Hot and Cold Water AF]= '06/15/2004' WHERE Bathrooms.BathroomID = 77 I set up a test environment and this worked fine. Good Luck!

Donutman is correct. Try switching the month and the day as so: UPDATE Bathrooms SET Bathrooms.[2nd Fix Hot and Cold Water AF]= '06/15/2004' WHERE Bathrooms.BathroomID = 77