Search results for query: *

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

Hello, This is the scenario. I have a table with saleperson, sale, and paid and some other columns. one saleperson may have multiple records in this table. What I want to do is to compare the paid and sale column. If any of the records for that saleperson with sale > paid then I will update a...

I am just wondering how I can remove a column from a table. I thought it would be alter table (table name) alter column (column name). But it gave me an “Incorrect Syntax” error. Thanks in advance for any help.

Awesome! it works! thanks so much for helping out. Your assistance is very much appreciated.

I have a field with char type and 17 in length and user entered various length of data in it. Some are 5, 10, 12, 14 or 15. But the last character is the one in interest. I am just wondering how I can run a query to get the last character of that field. I have tried substring, char_length...

Good job! This is great! It really works! Thanks you so much for the enlightening logic. I found this forum so technically educational and helpful. Thanks again for all your assistance and enlightenment.