Recent content by dbinfoweb

Great, this works. Thanks so much. Now if I want to add this: if field1 in ('a','b','c') and field2 not in ('m',n') then 'lmnopq' as field3. I am not sure how to decode this. Thanks again.

Hello, I am jsut wondering how I can use decode in procedure in an insert into statement...here is what I try to accomplish... insert into table select field1, field2, (if field1 = this, and field2 = that) then 'thisthat' as field 3 from other table Thanks in advance for any help

Hi, I got an error trying to pull in the procedure I created in Oracle. The error said "Invalid Cursor" Is there any other way to call the procedure in Crystal? Any help will be appreciated.

Yes, it does. Thanks so much for your help, David.

I am just wondering if there is a way to remove the very last character in a field. Thanks in advance for any help.

Great! Thanks for all your assistances and insights. This really helps.

Is there a query that I can use to check sizes of tables in Sybase?

I have a problem of trying to export tables from Access to Sybase server. But I keep receiving error saying: "reading from server timeout". Does anyone know the cause of that and the resolution. Thanks in advance for any help.

I have a problem of trying to transfer tables from one Sybase to another Sybase. But I keep receiving error saying: "reading from server timeout". Does anyone know the cause of that and the resolution. Thanks in advance for any help.

Hello, just wondering if it is possible to change the modified date of a file in Windows without actually openning it and saving it.

Awesome! Thanks so much, it really did.

Hello, I am just wondering if there is any way to write all the information of files in a directory to a text file. (i.e. Name, Size, Type and Modified)

Awesome, it works! I actually had to use both. I had one param is a string and the other one is number. So...thank you so much for your help. It definitely has been a big help! Thanks again.

I am using version 8...thanks.

I have a parameter to allow users to enter as many values as they want and they will be used in Record Selection. I would like to print these parameter values on the report. I know I can use maximum and minimum for the upper and low bounds, What about those in between? say the user enters 10...